Data Architect (Oshawa, ON, CA, L1H 8W8)

Location: 

Oshawa, ON, CA, L1H 8W8

Status: Contract (Up to 12 Months) 
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: Toronto, ON 
Shifts(s): Days 
Travel: 10% 
Deadline to Apply: May 26, 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 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 Toronto, ON until the move to Headquarters in the Summer of 2025. 

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.