ETL Developer

ETL Developer

Date: July 27, 2026

Location: Mississauga, ON – Hybrid

Requisition ID: 21169

Status: Regular

Business Unit: Information & Technology Services

Grade/Band: MP4

Shift Work: No

Annual Pay Range: For standard 35-hour work week

Step 1: $111,072 to Step 10: $158,704

The successful candidate will be placed at the appropriate step within the salary grade/band, based on relevant years of experience and other applicable considerations.

Why join us?

The IESO is committed to ensuring Ontario’s electricity system meets the province’s needs today and into the future. We are charged with purpose, delivering reliable, affordable, and sustainable electricity for homes, businesses, and communities across the province. We are energized to grow, embracing opportunities to shape the future of a dynamic and evolving energy sector while advancing our careers. We are powered by teamwork, supported by diverse and passionate colleagues who foster respect, celebrate successes, and thrive on shared achievements. At the IESO, it’s not just what we do—it’s who we are!

Who we are

Our central role includes managing the provincial power grid in real-time, overseeing and evolving Ontario’s electricity market, engaging with government, municipalities and Indigenous communities, and planning for Ontario’s future electricity needs. Our employees play a key role in driving grid innovation, protecting the system from threats, advancing the province’s energy conservation programs, and forecasting and procuring the electricity resources we’ll need in the decades to come.

This is a unionized position that falls within the Business Solutions Division in the Information & Technology Services Business Unit.

What makes this role exciting

The energy sector is rapidly evolving, offering exciting new opportunities for those who want to make a difference.

• Provide life cycle management of information technology solutions to the core components of IESO business related to operating the IESO Administered Markets, providing reliable operation of the electrical system (IESO controlled grid), and other corporate requirements. This role will involve providing solution and development support for integration of solutions leveraging extract transform and load solutions. This role will involve providing solution and development support for integration of solutions leveraging extract transform and load solutions (ETLS) using SAP BODS and Boomi platforms.

What you’ll do

In this role, you’ll make a meaningful impact by contributing to the IESO team and supporting the electricity needs of the province through:

• Develop and test integrated computer based information solutions for business and operations processes for the reliable operation of the power system, operation of the IESO Administered Market, and for other corporate needs of the IESO. Conduct analysis of customer requirements, the production of functional specifications, and the development of a satisfactory information solution (ie, impacting areas of software, hardware, communications and business processes).
• Oversee the evolution of existing information systems and tools related to the market operation, supply, security and settlement services related to the management of the power system and other corporate requirements by conducting/developing/monitoring enhancements to provide additional functionality, improved reliability/maintainability and problem correction.
• Identify opportunities for information solutions that will provide effective and economic benefits for customers. Address the total solution in terms of quality, communications, data sources, software tools, integration with existing functions, user interfaces, algorithms, etc.
• Monitor and oversee assigned projects for the development and expansion of information systems and tools. Provide periodic or limited work assignment, organizing, scheduling and checking work of others delegated to assist in specific work projects.
• Provide project management support to projects or teams involved in the expansion and improvement of information systems and tools.
• Provide Quality Assurance (QA) support for information solution changes by participating in the creation of QA deliverables and execution of QA plans.

In a typical day, you will

• Maintain a close customer relationship and be alert to identify potential improvements to existing systems and to propose new information system requirements.
• Participate in the development of strategic plans and standards.
• Act as a teacher or mentor to associates to advance their learning and facilitate their problem solving skills within their respective area of expertise.
• Perform other duties as required.

Role Requirements

Our team consists of experts from diverse backgrounds, each bringing their unique perspectives and skills.

To succeed in this role, you’ll need:

Education

• Requires a strong academic knowledge of computer science and associated subjects, including a strong theoretical knowledge pertinent to the specialist areas of the technical or business operations of the electricity market and administration processes related to the power system delivery. Requires communication skills, including report or business presentation skills.
• This knowledge is considered to be normally acquired either through the successful completion of a four-year University education in the appropriate field/discipline or by having the equivalent education.

Experience

• Requires significant exposure to the overall power system operation and electricity market operation as might be acquired through experience in positions related to the power system operation and market operation.
• Background should be related to the fields of:
• utilization of generation resources, including interconnections
• secure operation of bulk power system
• reliability
• means of operation including control equipment, staffing, techniques and procedures for the practice of operating
• market entry, maintenance and exit
• bidding and market information management
• market scheduling and dispatch
• metering and market settlement
• billing and market funds administration

#J-18808-Ljbffr