Job Description :
Title: ETL Developer

Location: Southfield, MI

Duration: 12 + Months

Key Responsibilities:

Design, implement and maintain BI solutions that meet business needs. This includes but not limited to reports, dashboards, ETL scripts, semantic layers, data marts, stored procedures and functions.
Translate business requirements into functional BI designs.
Create and maintain technical documentation including data models, data workflow diagrams and design documents.
Collaborate with the Data Insights & Analytics team and other IT resources throughout the development lifecycle; enforcing best practices where necessary.
Analytically come up with improved and more efficient processes for IT and business users.
Participate on project teams to deliver new BI and Analytics solutions or enhance current ones.
Provide support of existing applications and services provided by the Data Insights & Analytics team.
Investigate and troubleshoot problems. Collaborate with business units and team members to determine root cause and appropriate functional solutions.
Quality assurance testing of BI solutions to ensure completeness and accuracy.
Additional responsibilities as identified.


University degree or College diploma in the field of Information Technology; equivalent experience may be considered in lieu of education.
Minimum 5 years of hands-on experience designing and developing BI and data warehouse solutions
Demonstrated proficiency with ETL scripts and tools. Experience with ADF, SSIS, SSAS and T-SQL is a must.
Demonstrated proficiency with relational databases. Experience with SQL Server databases and SQL scripting is a must.
Demonstrated proficiency with enterprise business intelligence products. Power BI reporting experience is a definite asset.
Ability to work independently, manage multiple tasks and meet delivery commitments with accuracy.
Exceptional customer service skills, including the ability to interact professionally with a diverse group of customers.
Working knowledge of Information Technology concepts and principles, theories and functions of computer systems, and principles and techniques of IT documentation.
Solid understanding and proven experience in requirements definition and management techniques including business process, use case, workflow and data modelling.
Proven analytical abilities and able to understand system architecture and the integration of system components.
Azure certification is a definite asset.