Intermediate ETL Developers to design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities

Our client is seeking an Intermediate ETL Developer to design, implement, and continuously expand data pipelines by performing extraction, transformation, and loading activities

• Must Haves:
• 5+ years of experience as a ETL Developer in database and/or reporting environments incorporating Microsoft SQL Server technology.
• Experience in data warehouse/data mart design and development.
• Experience with ETL processes/tools
• Experience in visual design and development utilizing Microsoft Power BI, Tableau or similar software.
• Understanding of OLAP/multi-dimensional data organization techniques and one or more related
• SSIS and/or Informatica

• Nice to Have:
• SAS Data Integration studio
• Education/experience in Advanced Mathematics and/or Statistics is considered an asset
• Minimum 2-year diploma in Computer Science

Responsibilities:

• Develop complex, mission critical reports, projects and applications.
• Deliver professional quality of data analysis and ETL processes to reduce the high consequence of error.
• Gather and formally document the object inventory, capturing details including data sources and data requirements to fulfill internal and external audit requirements.
• Build Extract, Transform, Load processes using SAS Data Integrator based on a logical model or design.
• Perform peer code reviews to ensure adherence to design, development and maintenance standards.
• Contribute to design and development best practices and guidelines.
• Monitor and remediate all issues with the data warehouse/data marts and reports.
• Provide knowledge transfer to the other members of the development team.
• Perform and support daily tasks such as job scheduling, monitoring, troubleshooting and remediation.
• Support testing of solutions in all applicable environments.
• Support stakeholders in the use of information products.
• Assist with training materials, and demonstrations.
• Ensure issues are identified, tracked, reported on and resolved in a timely manner.
• Participate in post-project implementation reviews or ‘lessons learned’, incorporating these lessons into appropriate process documentation, standards templates and checklists.
• Perform other duties as assigned by the Information Management leaders.