Data Architect

Ontario Power Generation Inc.; Oshawa; Hybrid; CAD 125,000 - 150,000; Full time

Job summary

Join a forward-thinking company as a Data Architect, where you'll play a pivotal role in shaping the future of data architecture. This dynamic position involves translating business needs into technology solutions, ensuring robust data governance, and leveraging cutting-edge tools like Azure Synapse and Data Factory to drive data transformation. With a commitment to sustainability and innovation, this organization is at the forefront of electrifying life in one generation. If you're passionate about data and eager to make a difference, this is the perfect opportunity for you.

Qualifications

• 6-8 years in data modeling and data solution architecture.
• Expert knowledge of Microsoft SQL Server and Azure services.
• Experience with Enterprise Architecture frameworks.

Responsibilities

• Translate business requirements into technology requirements.
• Define data standards and principles for data governance.
• Develop and maintain documentation for data architecture.

Skills

Data Modeling

Data Warehouse Design

Data Solution Architecture

Microsoft SQL Server

Azure SQL

Azure Data Factory

Azure Synapse

Hadoop Distributed File System

Data Lake

Power BI

Education

4-year University education in computer science

Relevant programs in data engineering

Tools

Azure Synapse Analytics

Azure Data Factory

Microsoft SQL Server

Power Apps

Job description

Press Tab to Move to Skip to Content Link

Select how often (in days) to receive an alert:

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: OshawaON
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-drivenprofessional to join our team in the role of Data Architect.

Reporting to the Senior Manager, Enterprise Architecture, this position is responsible totranslate 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 oneof themost diverse power producers in North America. As the largest generator in Ontario, we meet approximately50%ofthe province’selectricityneeds, largely from low-carbonsources like nuclearand 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 applicationonline 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.