Sr. Data Warehouse Engineer -TS
Company Name:
Career Development Partners
The Senior Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development of the data warehouse. Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance and database administration. The DWE will work closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data. The DWE will also work closely with the front-end developers to ensure data being brought in and managed is clean, accurate, available and complete. The DWE will help to ensure the data warehouse processes are running optimally.
Responsibilities
Design and support database and table schemas for new and evolving sources of data being brought into the data warehouse
Create and support the ETL to facilitate bringing data into the data warehouse using SQL Server Integration Services
Create and support the SQL Server Analysis Services cubes to help with query performance
Monitor and troubleshoot performance issues on the data warehouse servers
Follow design principles and best practices for data warehousing techniques and architecture
Participate in on-call rotation and monthly production code pushes after regular business hours
Requirements
Associate or Bachelor's degree in computer science or equivalent work experience.
Five years of experience with SQL Server 2005/2008/2012 T-SQL coding and database administration
Five years of experience with SQL Server Integration Services or similar ETL tool
Five years of experience with SQL Server Analysis Services
Five years of programming experience in VBScript, .Net or similar
Experience leading small project teams and mentoring others
Estimated Salary: $20 to $28 per hour based on qualifications.
Career Development Partners
The Senior Data Warehouse Engineer (DWE) is responsible for the full life cycle of back-end development of the data warehouse. Responsibilities include the development of ETL processes, dimensional design of the table structure, cube development for performance and database administration. The DWE will work closely with the Business Analyst to work through business requirements and develop processes necessary to provide visibility into the data. The DWE will also work closely with the front-end developers to ensure data being brought in and managed is clean, accurate, available and complete. The DWE will help to ensure the data warehouse processes are running optimally.
Responsibilities
Design and support database and table schemas for new and evolving sources of data being brought into the data warehouse
Create and support the ETL to facilitate bringing data into the data warehouse using SQL Server Integration Services
Create and support the SQL Server Analysis Services cubes to help with query performance
Monitor and troubleshoot performance issues on the data warehouse servers
Follow design principles and best practices for data warehousing techniques and architecture
Participate in on-call rotation and monthly production code pushes after regular business hours
Requirements
Associate or Bachelor's degree in computer science or equivalent work experience.
Five years of experience with SQL Server 2005/2008/2012 T-SQL coding and database administration
Five years of experience with SQL Server Integration Services or similar ETL tool
Five years of experience with SQL Server Analysis Services
Five years of programming experience in VBScript, .Net or similar
Experience leading small project teams and mentoring others
Estimated Salary: $20 to $28 per hour based on qualifications.
|
|
 | |
