Sr Data Developer

Location: 

Toronto, ON, CA, M5G 1X6

Req ID:  45916

Status: Regular Full time

Working Conditions: Hybrid Work Environment (3 days in office)        

Education Level: 4 years of University degree in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.

Location: Toronto, ON 

Shifts(s): Days

Travel: 10% 

Deadline to Apply: April 24, 2024. 

 

Electrify your career and help build a brighter tomorrow.

 

Every generation has a challenge that defines them. At OPG, we are calling on all innovators, disruptors, thought leaders and change-makers. Join us to electrify life in one generation and build a sustainable future powered by our electricity, our ideas, and our people. Join OPG and make history.

 

Whether you work in the skilled trades or are a business professional, a career at OPG is an opportunity to electrify your life on -- and off -- the job.

 

ACCOMMODATIONS

OPG is committed to fostering an inclusive, equitable, and accessible environment where all employees feel valued, respected, and supported. If you require accommodation during the application or interview process, please advise us as soon as possible so appropriate arrangements can be made.

 

If you require information in a format that is accessible to you, please contact AODA@opg.com

 

NEW CAMPUS: 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 new space will enable teamwork, collaboration and innovation that will help us to achieve our mission to electrify life in one generation.

 

 

JOB OVERVIEW 

 

Ontario Power Generation (OPG) is looking for a dynamic, strategic, and results-driven professional to join our team in the role of Senior Data Developer.

 

Reporting to the Senior Manager, Data and Artificial Intelligence, in this position you will be designing, building, and supporting the data pipelines powering our analytics and artificial intelligence / machine learning products. You will build reliable, supportable, and performant data extraction and curation jobs for our data lake and warehouse. You will also build DevOps standards and best practices, as well as automation and tooling for other Data Engineers, Data Scientists, Analytics Engineers, and others.

 

This is an exciting opportunity to work in an environment where you will contribute to OPG’s public outreach, engagement, and education efforts as part of the company’s commitment to growing its social license.  

 

KEY ACCOUNTABILITIES  

  • Design, build and productionize modular and scalable data pipelines and data infrastructure leveraging the wide range of data sources across the organization.
  • Implement curated common data models that offer an integrated, business-centric single source of truth for business intelligence, analytics, artificial intelligence, and other downstream system use.
  • Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
  • Work with tools in the Microsoft Stack; Azure Data Factory, Azure Data Lake, Azure SQL Databases, Azure Data Warehouse, Azure Synapse Analytics Services, Azure Databricks, Microsoft Purview, and Power BI
  • Work within an agile work management framework in delivery of products and services, including contributing to feature & user story backlog item development.
  • Develop optimized, performant data pipelines and models at scale using technologies such as Python, Spark and SQL, consuming data sources in XML, CSV, JSON, REST APIs, or other formats.
  • Implement orchestration of data pipeline execution to ensure data products meet customer latency expectations, dependencies are managed, and datasets are as up to date as possible, with minimal disruption to end-customer use.
  • Create tooling to help with day-to-day tasks and reduce toil via automation wherever possible.
  • Build continuous integration / continuous delivery (CI/CD) pipelines to automate testing and deployment of infrastructure / code.
  • Monitor the ongoing operation of in-production solutions, assist in troubleshooting issues, and provide Tier 2 support for datasets produced by the team, on an as-required basis.
  • Write and perform automated unit and regression testing for data product builds, assist with user acceptance testing and system integration testing as required, and assist in design of relevant test cases.
  • Participate in code review as both a submitter and reviewer.
  • Other Duties as Required.

 

 

EDUCATION   

  • 4 years of University in computer science, computer/software engineering or other relevant programs within data engineering, data analysis, artificial intelligence, or machine learning.

 

  

QUALIFICATIONS   

  • Requires experience of over 4 years and up to 6 years in data modeling, data warehouse design and data solution architecture in a Big Data environment.  
  • Experience as a Data Engineer in a Big Data environment.
  • Experience with integrating structured and unstructured data across various platforms and sources.
  • Knowledge of content fragmentation, partitioning, query parallelism, and query execution plans.
  • Experience with implementing event-driven (pub/sub), near-real-time, or streaming data solutions.
  • Strong knowledge of programming methodologies (source/version control, continuous integration/continuous delivery, automated testing, quality assurance) and agile development methodologies.
  • Fluency with SQL, Python, and Spark/PySpark is required.
  • Experience with Airflow and DBT.
  • A period of over 4 years and up to and including 6 years in data ingestion, data modelling, data engineering, and software development.

 

The successful candidate will exhibit uncompromising integrity and commitment to upholding corporate values, and the OPG Code of Business Conduct. 

 

What Makes a Career at OPG Different?

 

As Ontario’s largest clean energy generator, we’re building, expanding, and innovating the equipment and technology that keeps Ontario powered with clean, reliable energy. 

 

At OPG, our values are our strengths.  They are fundamental truths about our organization that don’t change:  

 

Safety – it’s our business.

Integrity – always lead with integrity.

Excellence – never satisfied with good enough. 

Inclusion – working together for powerful outcomes.

Innovation - creativity accelerates possibility.

 

Here's why OPG might just be the ideal workplace for you:

  • Exceptional range of opportunities province-wide
  • Long-term career growth and development opportunities
  • Electricity is vital to the province and OPG’s clean electricity is helping decarbonize other sectors.

 

Our promise to you:

  • We care about the safety and the well-being of our employees. It is our utmost priority.
  • A supportive work environment where you can be your best every day.
  • Opportunities to stretch and develop.
  • Offer different ways for you to give back to communities where we operate.
  • Partner with Indigenous communities and support local businesses.
  • We support employment equity, diversity, and inclusion.

 

Are you ready to start a career that has the power to electrify life on and off the job? Apply now

 

APPLICATION PROCESS 

Please submit your application online at https://jobs.opg.com/ by 11:59 PM E.S.T. April 24, 2024.  OPG thanks all those who apply; however, only candidates considered for an interview will be contacted. 

#LI-Hybrid

.