Job Title : Data Integration Specialist

Status : Regular Full Time

Working Conditions : Hybrid Working Environment - 3 days in the office

Education Level : University degree in Engineering, Science or Business

Location(s) : Courtice, ON

Deadline to Apply : October, 11th, 2023

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 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.

ACCOMMODATIONS

OPG is committed to fostering an inclusive, equitable, and accessible environment where all employees feel valued, respected, and supported. If you require accommodation during the application or interview process, please advise us as soon as possible so appropriate arrangements can be made.

If you require information in a format that is accessible to you, please contact [email protected]

JOB OVERVIEW

Ontario Power Generation (OPG) is looking for dynamic, strategic and results-driven professional to join our Enterprise Project Office team in the role of a Data Integration Specialist located in Courtice, Ontario .

The Data Integration Specialist is responsible for providing support to the Section Manager through deploying code changes to the TIBCO EBX Platform, handling SQL ETL and TSQL scripting tasks, and facilitating direct communication with stakeholders. Your expertise in data integration, SQL scripting, and stakeholder management will contribute to the successful execution of our projects. This position is within OPG's Enterprise Project Organization and is an incredible opportunity to gain exposure to projects across different lines of business including Renewable Generation, Nuclear Refurbishment, IT Projects, New Nuclear and more!

This is an exciting opportunity to work in an environment where you will contribute to Ontario Power Generation's continued growth and success in being Ontario's low cost electricity generator of choice.

KEY ACCOUNTABILITIES

• Deploy code changes to the TIBCO EBX Platform, ensuring smooth and efficient implementation.
• Collaborate with development teams to understand code changes and their impact on the TIBCO EBX Platform.
• Perform SQL ETL tasks, including data extraction, transformation, and loading, to support data integration processes.
• Develop and maintain TSQL scripts for data manipulation, data validation, and data cleansing.
• Work closely with stakeholders to gather requirements, provide technical guidance, and address any concerns or issues.
• Conduct data analysis to identify data quality issues, data inconsistencies, and opportunities for data optimization.
• Collaborate with cross-functional teams, including developers, database administrators, and business analysts, to ensure seamless data integration.
• Monitor and troubleshoot data integration processes, identifying and resolving any performance or operational issues.
• Maintain documentation for data integration processes, code changes, and troubleshooting procedures.
• Stay updated with industry trends and advancements in data integration, SQL scripting, and relevant technologies.

EDUCATION

QUALIFICATIONS

The successful candidate will exhibit uncompromising integrity and commitment to upholding corporate values, and the OPG Code of Business Conduct.

What Makes a Career at OPG Different?

As Ontario's largest clean energy generator, we're building, expanding, and innovating the equipment and technology that keeps Ontario powered with clean, reliable energy.

At OPG, our values are our strengths. They are fundamental truths about our organization that don't change :

Safety - it's our business

Integrity - always lead with integrity

Excellence - never satisfied with good enough

Inclusion - working together for powerful outcomes

Innovation - creativity accelerates possibility

Here's why OPG might just be the ideal workplace for you :

Our promise to you :

Are you ready to start a career that has the power to electrify life on and off the job? Apply now.