Data Architect
About the role
**Location:**Oshawa, ON, CA, L1H 8W8
Req ID: 53766
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
Shifts(s): Days
Travel: 10%
Deadline to Apply: November 11, 2025
Salary Range: $2,865.82 - $3,325.66 Per Week
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 as we work 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.
JOB OVERVIEW
Ontario Power Generation (OPG) is looking for a dynamic, strategic and results-driven professional to join our team in the role of Data Architect.
Reporting to the Senior Manager, Enterprise Architecture, this position is responsible to translate business requirements into technology requirements, and define data standards and principles, often in support of data or digital transformations. The data architect is responsible for visualizing and designing an organization’s enterprise data management framework, which describes the processes used to plan, specify, enable, create, acquire, use, archive, retrieve, control, and purge data. Additionally, the architect will be responsible for the OPG data standards and governance, utilizing solutions like Azure Synapse Analytics and Azure Data Factory to orchestrate and automate data movement and transformation across platforms such as Hadoop Distributed File System (HDFS), Data Lake and SQL Databases.
KEY ACCOUNTABILITIES
-
Champion, negotiate, and express the future state of data architecture at the OPG by developing the Target Data Architecture and identifying candidate architecture roadmap to get there.
-
Define and apply architecture governance to enable the enterprise to develop and implement data solutions and capabilities that are clearly aligned with business drivers.
-
Develop understanding of the business and successfully translate data models/concepts/capabilities in a way the business understands.
-
Act as the SME in data architecture best practices, data architecture design patterns, reference architecture, service-oriented architecture, micro-service architecture, and available off-the-shelf components.
-
Identifies architectural and data risks associated with all aspects of the solution and makes recommendations on strategies to mitigate risks.
-
Ensures data architecture standards and guidelines are maintained through the establishment and maintenance of documentation including best practices, processes, and associated templates.
-
Produces and maintains design artifacts and documentation for decision making process throughout the application development life cycle.
-
Manages users' expectations by providing education to the users and presents architectural concepts to management and technical audiences and facilitates data modeling discussions.
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.
-
A period of over 6 years and up to and including 8 years in data modeling, data warehouse design, and data solution architecture in a Big Data environment is considered necessary to gain this experience.
-
Expert knowledge of Microsoft SQL Server (i.e. SQL, SSAS, SSIS, SSRS) and Azure database and analytics services (i.e. Azure SQL, Azure Synapse, Azure Data Factory, Azure Data Lake, Purview, Power Apps, Power BI).
-
Extensive experience in developing, deploying, managing, and supporting real-time mission critical database.
-
Experience in using Enterprise Architecture frameworks and development methodologies (e.g., TOGAF, Zachman, SABSA).
-
Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
-
Experience in migration of database and analytics services to Azure.
-
Strong technical documentation, research, and analytical skills.
-
Solid understanding of product management, agile principles, and development methodologies.
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 selection process, please contact AODA@opg.com
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 https://jobs.opg.com/. OPG thanks all those who apply; however, only candidates considered for an interview will be contacted.
#LI-Hybrid
Please note: All job postings at OPG are to fill existing vacancies within our organization.
OPG may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.
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.
About Ontario Power Generation
At Ontario Power Generation (OPG), our power is changing the world as we strive to electrify life in one generation. As the province’s largest clean power generator, OPG operates one of North America’s most diverse generating fleets. We are now advancing several clean energy innovations, including Small Modular Reactors, low-carbon hydrogen, and energy storage, to help set Ontario and the world on the path to an electrified future, where more aspects of life – from cars to homes and industries – are powered by clean electricity. As part of this vision, we’re also focused on becoming a net-zero company by 2040 and enabling a net-zero economy by 2050. We have already made major strides to a sustainable future. In 2014, OPG burned its last piece of coal to make electricity, which represented one of the world’s single-largest climate change-specific actions. Today, through the dedication of more than 9,500 employees, OPG generates almost half of the electricity that Ontario’s homes, schools, hospitals, and businesses rely on each day. We are committed to ensuring our energy production is reliable, safe, and environmentally sustainable for Ontarians today and for the future. In Ontario, our diverse fleet includes two nuclear stations, 66 hydroelectric stations, two thermal generating stations, one solar facility, and four combined-cycle gas generating stations, which are operated by our subsidiary, Atura Power. Additionally, we own two other nuclear generating stations in Ontario, which are leased on a long-term basis to Bruce Power L.P. In the United States, OPG owns and operates 85 hydroelectric stations in 18 states through our subsidiary, Eagle Creek Renewable Energy. Some of the actions OPG is taking now to prepare for our electric future include the ongoing refurbishment and upgrades of our hydro fleet, refurbishment of our Darlington Nuclear Generating Station, which will secure 30 more years of clean, reliable, low-cost power.
Data Architect
About the role
**Location:**Oshawa, ON, CA, L1H 8W8
Req ID: 53766
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
Shifts(s): Days
Travel: 10%
Deadline to Apply: November 11, 2025
Salary Range: $2,865.82 - $3,325.66 Per Week
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 as we work 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.
JOB OVERVIEW
Ontario Power Generation (OPG) is looking for a dynamic, strategic and results-driven professional to join our team in the role of Data Architect.
Reporting to the Senior Manager, Enterprise Architecture, this position is responsible to translate business requirements into technology requirements, and define data standards and principles, often in support of data or digital transformations. The data architect is responsible for visualizing and designing an organization’s enterprise data management framework, which describes the processes used to plan, specify, enable, create, acquire, use, archive, retrieve, control, and purge data. Additionally, the architect will be responsible for the OPG data standards and governance, utilizing solutions like Azure Synapse Analytics and Azure Data Factory to orchestrate and automate data movement and transformation across platforms such as Hadoop Distributed File System (HDFS), Data Lake and SQL Databases.
KEY ACCOUNTABILITIES
-
Champion, negotiate, and express the future state of data architecture at the OPG by developing the Target Data Architecture and identifying candidate architecture roadmap to get there.
-
Define and apply architecture governance to enable the enterprise to develop and implement data solutions and capabilities that are clearly aligned with business drivers.
-
Develop understanding of the business and successfully translate data models/concepts/capabilities in a way the business understands.
-
Act as the SME in data architecture best practices, data architecture design patterns, reference architecture, service-oriented architecture, micro-service architecture, and available off-the-shelf components.
-
Identifies architectural and data risks associated with all aspects of the solution and makes recommendations on strategies to mitigate risks.
-
Ensures data architecture standards and guidelines are maintained through the establishment and maintenance of documentation including best practices, processes, and associated templates.
-
Produces and maintains design artifacts and documentation for decision making process throughout the application development life cycle.
-
Manages users' expectations by providing education to the users and presents architectural concepts to management and technical audiences and facilitates data modeling discussions.
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.
-
A period of over 6 years and up to and including 8 years in data modeling, data warehouse design, and data solution architecture in a Big Data environment is considered necessary to gain this experience.
-
Expert knowledge of Microsoft SQL Server (i.e. SQL, SSAS, SSIS, SSRS) and Azure database and analytics services (i.e. Azure SQL, Azure Synapse, Azure Data Factory, Azure Data Lake, Purview, Power Apps, Power BI).
-
Extensive experience in developing, deploying, managing, and supporting real-time mission critical database.
-
Experience in using Enterprise Architecture frameworks and development methodologies (e.g., TOGAF, Zachman, SABSA).
-
Advanced knowledge of database security, backup and recovery, and performance monitoring standards.
-
Experience in migration of database and analytics services to Azure.
-
Strong technical documentation, research, and analytical skills.
-
Solid understanding of product management, agile principles, and development methodologies.
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 selection process, please contact AODA@opg.com
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 https://jobs.opg.com/. OPG thanks all those who apply; however, only candidates considered for an interview will be contacted.
#LI-Hybrid
Please note: All job postings at OPG are to fill existing vacancies within our organization.
OPG may use artificial intelligence (AI) tools as part of the applicant screening process. However, applications will also be reviewed by a member of our Recruitment team to ensure a fair and thorough assessment.
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.
About Ontario Power Generation
At Ontario Power Generation (OPG), our power is changing the world as we strive to electrify life in one generation. As the province’s largest clean power generator, OPG operates one of North America’s most diverse generating fleets. We are now advancing several clean energy innovations, including Small Modular Reactors, low-carbon hydrogen, and energy storage, to help set Ontario and the world on the path to an electrified future, where more aspects of life – from cars to homes and industries – are powered by clean electricity. As part of this vision, we’re also focused on becoming a net-zero company by 2040 and enabling a net-zero economy by 2050. We have already made major strides to a sustainable future. In 2014, OPG burned its last piece of coal to make electricity, which represented one of the world’s single-largest climate change-specific actions. Today, through the dedication of more than 9,500 employees, OPG generates almost half of the electricity that Ontario’s homes, schools, hospitals, and businesses rely on each day. We are committed to ensuring our energy production is reliable, safe, and environmentally sustainable for Ontarians today and for the future. In Ontario, our diverse fleet includes two nuclear stations, 66 hydroelectric stations, two thermal generating stations, one solar facility, and four combined-cycle gas generating stations, which are operated by our subsidiary, Atura Power. Additionally, we own two other nuclear generating stations in Ontario, which are leased on a long-term basis to Bruce Power L.P. In the United States, OPG owns and operates 85 hydroelectric stations in 18 states through our subsidiary, Eagle Creek Renewable Energy. Some of the actions OPG is taking now to prepare for our electric future include the ongoing refurbishment and upgrades of our hydro fleet, refurbishment of our Darlington Nuclear Generating Station, which will secure 30 more years of clean, reliable, low-cost power.