Description:
Ontario Power Generation (OPG) is looking for a dynamic, strategic, and results-driven professional to join our team in the role of Senior Data Engineer (Project Controls Specialist).
Reporting to the Manager Project Controls, this position is responsible for championing the use of project planning and controls best practices by gathering and analyzing large sets of structured and unstructured data. They process and model the data, interpreting the results to create actionable plans for OPG and its clients.
Key accountabilities include working around data and integrating with various AI solutions, leading implementation Enterprise Projects AI tooling. Working with DTS/CIO & AI teams – providing support to data scientists with expertise in project controls. Need someone who is more specific experience with project controls background to provide the AI team data scientist, someone to ‘translate’ between the two teams.
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
- Identify and champion the use of project planning and control best practices, especially related to data warehousing.
- Develop modeling guidelines that ensure model extensibility and reuse by employing industry standard disciplines for building facts, dimensions, bridge, aggregates, slowly changing dimensions, and other dimensional and fact optimizations.
- Ensure data accuracy, increase trust in data, and safeguard our information assets.
- Operate across the people, process, and supports OPG Enterprise Projects, Refurbishment programs, Small Modular Reactors (SMRs), Renewable Generation (RG) Hydro projects.
- Act as the bridge between the project/business stakeholders and our Data Management Team.
- Provide decision support, to the Manager and Director, on matters related to planning and control practices, performance measures, project management systems and 'best industry' practices.
- Organize and transformation of data and integrating with various system and AI tools, supporting data warehousing and Master Data Management (MDM) structure.
- Transform data and map to more valuable and understandable semantic layer sets for consumption, transitioning from system-centric language to business-centric language.
- Collaborate with business analysts, data scientists, data engineers, data analysts, report developers, and solution architects to develop data pipelines to feed our data marketplace.
- Perform data cleansing activities and integrating to enhance data and exploring and implementing AI solutions based on a decade’s worth of data and translating into meaningful insights.
- Identify areas for data quality improvements and help to resolve data quality problems through the appropriate choice of error detection and correction, process control and improvement.
- 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.
- Collaborate with our Data Governance experts, Digital IT Team, and our Data Management Team to identify and meet data requirements.
- Participate in discussions with business partners to identify, understand and document functional and non-functional requirements resulting in data acquisition or integration.
- Ensure that designs are implemented with proper attention to data security, access management, and data cataloging requirements.
- Approve pull requests related to production deployments.
- Demonstrate solutions to business customers to ensure customer acceptance and solicit feedback to drive iterative improvements.
- Guide data modelers, business analysts and data scientists in the build of models optimized for KPI delivery, actionable feedback/writeback to operational systems and enhancing the predictability of machine learning models and experiments.
- Other duties as required.
EDUCATION
- Grade 12 plus 4 years' further concentrated study in project management and/or business economics
QUALIFICATIONS
- 8+ years of relevant experience in project management, controls, and data engineering concepts, methods, and techniques.
- Requires experience in the field of data modeling, data warehouse design.
- Experience with PowerShell and scripting experience.
- Experience with Python and Java. SQL would be a big asset.
- Experience with SQL data warehouse - relational database design, ETL/ELT and pipelines, Azure DevOps
- Direct experience working on data quality, enterprise data and data analytic quality management initiatives.
- Ability to work with concepts and techniques of trend analysis, forecasting, resource leveling and risk analysis.
- Comfortable generating, manipulating, and interpreting both qualitative and quantitative data.
- Exceptional ability to gather, analyze and document information requirements from business units and cross-functional groups and work with multiple stakeholders.
- Strong communication and interpersonal skills to interact effectively with management staff, and a demonstrated ability to work effectively in team settings.
- Experience in project design, construction, rehabilitation, and modification to appreciate the spectrum of work situations surrounding major projects and in particular to generating facilities.
- Ability to work effectively and efficiently in a flexible hybrid office environment.