Senior Data Engineer

Ontario Power Generation

Ontario Power Generation (OPG), a key player in the electricity sector, calls upon innovators and leaders to help shape a sustainable future powered by low-carbon energy. As the leading power generator in Ontario, OPG is on a mission to electrify life and advance low-carbon technology development as part of its vision for a brighter tomorrow.

In this role you can expect to have the responsibilities:

• Construct and enhance scalable ELT/ETL pipelines for diverse organizational data sources.
• Collaborate in implementing common data models for business intelligence and reporting.
• Ensure the security of data in transit and at rest through collaboration with infrastructure and cyber teams.
• Clean, prepare, and optimize datasets, ensuring applied lineage and quality controls.
• Aid Business Intelligence Analysts through data modeling and reporting optimization.
• Troubleshoot data-related issues such as ingestion, transformation, pipeline performance, and accuracy.
• Work on developing data pipelines for the data marketplace with analysts, scientists, and engineers.
• Implement process improvements, task automation, and data delivery optimization for scalability and efficiency.

This role comes with the following benefits:

• OPG offers a unique career experience with diverse operations across North America.
• Involvement in advancing new low-carbon technologies and initiatives.

This role requires you to have:

• 4-Year University education in computer science or related field.
• 4-6 years experience in a similar field.
• Experience as a Data Engineer building data pipelines.
• Proficiency with Python, PySpark, SparkSQL, and SQL.
• Experience with Azure Data Factory, ADLS, Synapse Analytics, and Databricks.
• Knowledge of data governance and quality principles.

You would benefit from having:

• Effective communication skills for translating technical details to non-technical stakeholders.
• Understanding of data structures and processing frameworks.

OPG is dedicated to fostering an inclusive and equitable environment. They prioritize hiring equity-seeking groups and view diversity as crucial to strengthening their team. The role will move to OPG's new Corporate Headquarters in Oshawa, Ontario in Summer 2025.