Data Warehouse Developer
Previous Job
Data Warehouse Developer
Ref No.: 18-30370
Location: Warren, Michigan
Position Type:Contract
Start Date: 05/02/2018
Summary: This role will act as a consultant to colleagues in IT and other departments regarding data integration and data quality between various cloud and on-premise systems and solutions.
The Data Warehousing Engineer will work closely with the BI Reporting team and the client liaison in all aspects of delivering a robust the data warehouse systems. The engineer will be responsible for the technical design, development and maintenance of the data warehouse, ETL processes, SQLServer and SSAS databases, and reporting and analytic applications.
Duties & Responsibilities:
• Plan, create, coordinate, and deploy data warehouse and business intelligence solutions.
• Follow best practices for data creating and managing the data extraction, transformation and loading (ETL) framework.
• Develop data architecture, data modeling, and ETL mapping solutions.
• Understand, recommend and support robust reporting and analytic architectures.
• Develop unique, simple solutions to meet the immediate and long-term needs of information customers and stakeholders.
• Design and build Data Warehouse structures (databases and SSAS cubes).
• Support the development and validation required throughout the entire lifecycle of the data warehousing and business intelligence systems.
• Maintain user connectivity and provide adequate security for data warehouse.
• Monitor the data warehouse and business intelligence system performance and integrity and provide corrective and preventative maintenance as required.
• Support the data warehouse technical ecosystem, including Power BI for the delivery of reporting and analytic applications.
• Additional tasks and duties are assigned.
• Five or more years of experience as a Data Warehouse architect and ETL developer.
• Five or more years of experience with the Microsoft Data Warehousing and Business Intelligence stack (SQL Server, SSIS, SSRS, SSAS, PowerPivot, Power BI).
• Five or more years of experience with data analysis and data profiling using SQL and other tools.
• At least three years of data modeling experience, and knowledge of 3NF, Star-Schema and other data warehousing modeling techniques.
• Ability to communicate information clearly, concisely, and effectively both orally and in writing.
• Experience with BI reporting tools
• Comfortable working in a collaborative, team-centric environment.
• Comfortable with ambiguity, and changes in priority
• Ability to work well with a wide variety of people with varying technical skill sets and business knowledge.
• Experience in complex, cross-departmental projects involving multiple platforms.
Education Requirements:
• Bachelor's Degree in Computer Science, Mathematics and Statistics, or Management Information Systems.
• Master's Degree a plus