Location:Pickering, ON, CA, L1W 3J2
Req ID: 49717
Status: Regular Full Time
Working Conditions: Hybrid
Education Level: 4-Year University education in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.
Base Location: Oshawa, ON
Temporary Work Location: Pickering, ON
Shifts(s): Days
Travel: 10%
Deadline to Apply: January 31, 2025
Salary Range: $2,658.86 - $3,118.72 Per Week

JOB OVERVIEW

Ontario Power Generation (OPG) is looking for a dynamic, strategic and results-driven professional to join our team in the role of a Senior Data Engineer.
Reporting to the Senior Manager, Data Lake & Platform Engineering, this position is responsible to build and support the data driven applications which enable innovative, customer centric digital experiences. You will build reliable, supportable & performant data lake & data warehouse products to meet the organization’s need for data to drive reporting analytics, applications, and innovation. You will employ best practice in development, security and accessibility to achieve the highest quality of service for our customers.

KEY ACCOUNTABILITIES

• Build and optimize scalable data ELT/ETL pipelines across various organizational data sources.
• Collaborate with Data Architect to implement common data models for business intelligence and reporting.
• Ensure data security in transit and at rest with infrastructure and cyber teams.
• Clean, prepare, and optimize datasets, applying lineage and quality controls throughout the data lifecycle.
• Support Business Intelligence Analysts with data modeling and reporting optimization techniques.
• Troubleshoot issues related to data ingestion, transformation, pipeline performance, and data accuracy.
• Develop data pipelines for the data marketplace in collaboration with analysts, scientists, and engineers.
• Implement process improvements, automate tasks, and optimize data delivery for scalability and efficiency.

QUALIFICATIONS

• 4-Year University education in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.
• 4-6 years working experience in a similar or related field
• Experience as a Data Engineer building data pipelines.
• Fluent in creating data processing frameworks using Python, PySpark, SparkSQL and SQL
• Experience with Azure Data Factory, ADLS, Synapse Analytics and Databricks
• Experience building data pipelines for Data Lakehouses and Data Warehouses
• Good understanding of data structures and data processing frameworks
• Knowledge of data governance and data quality principles
• Effective communication skills to translate technical details to non-technical stakeholders
  The successful candidate will exhibit uncompromising integrity and commitment to upholding corporate values, and the OPG Code of Business Conduct.
  OPG is committed to fostering an inclusive, equitable, and accessible environment. If you require accommodation during the application or interview process, please contact AODA@opg.com.
  This position is moving to OPG Corporate Headquarters: In Summer 2025, OPG will officially welcome employees to our new Corporate Headquarters located at 1908 Colonel Sam Drive, Oshawa, Ontario. This position will be temporarily based in Pickering, ON until the move to Headquarters in the Summer of 2025. Remove entire paragraph if not based at CHQ.

WHAT MAKES A CAREER AT OPG DIFFERENT?

With operations across Ontario and the United States, OPG is one of the most diverse power producers in North America. As the largest generator in Ontario, we meet approximately 50% of the province’s electricity needs, largely from low-carbon sources like nuclear and hydro.
As we work to achieve our vision of Electrifying life in one generation, OPG and our family of companies are also helping advance the development of new low-carbon technologies such as Small Modular Reactors (SMRs), refurbishment projects, and electrification initiatives to help power the growing demands of a growing economy. Join OPG and make history.
Please submit your application online at jobs.opg.com. OPG thanks all those who apply; however, only candidates considered for an interview will be contacted.

LI-Hybrid

.
The base salary range considers many factors including, but not limited to experience, education, and training, including any collective agreement requirements for union represented positions. It is not typical for the salary to be offered near the top of the range, and salary is dependent on numerous factors. For management roles, the base salary range does not represent the total compensation package. The total compensation package for regular full-time management roles includes pay-for-performance programs for annual and medium time periods. Maintaining a high-performance culture and excellence is a core expectation of every member of our leadership team and is rewarded through the established compensation framework.
OPG is committed to employment equity. As such, we encourage applicants from equity-seeking communities (Indigenous Peoples, racialized persons, persons with disabilities, and women). We strongly believe that alleviating the under-representation of equity-seeking individuals will create a stronger OPG team and allow us to better serve the needs of our diverse communities.
In order to fulfill the above-mentioned purpose, priority in hiring may be given to qualified persons who self-identify as a member of equity-seeking groups as identified in the application process. This initiative constitutes a special program under the Human Rights Code/Canadian Human Rights Act.

Please refer the Job description for details