Data Architect

Ontario Power Generation Inc.; Oshawa; Hybrid; CAD 90,000 - 120,000; Full time

Job summary

A leading energy company in Oshawa is seeking a Data Architect to drive data architecture and governance. The ideal candidate should have a university degree and extensive experience with Microsoft SQL Server and Azure services. This role involves developing the data architecture framework and collaborating with teams to implement effective data solutions. The position will be located at the new Corporate Headquarters starting Summer 2025, with a temporary base in Toronto until then.

Benefits

Competitive salary

Flexible working conditions

Qualifications

• 4 years university education in relevant programs.
• 6-8 years of experience in data solution architecture.
• Expertise in data architecture design patterns and governance.

Responsibilities

• Translate business requirements into technology requirements.
• Develop Target Data Architecture and roadmap.
• Manage user expectations and facilitate data modeling discussions.

Skills

Data modeling

Big Data architecture

Microsoft SQL Server

Azure services

Analytical skills

Education

4-year university degree in computer science or related field

Tools

Azure Data Factory

Power BI

Hadoop

Job description

Press Tab to Move to Skip to Content Link

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 [e-mail].

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.