ETL Developer

Date: July 27, 2026

Location: Mississauga, ON – Hybrid

Requisition ID: 21169

Status: Regular

Business Unit: Information and 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,
  
  
  • prudential risk management
  
  
  • forecast and assessment  
  
  
  • market administration such as dispute resolution, waiver process, compliance and surveillance,
  
  
  • Financial accounting and reporting,
  
  
  • Payroll services.  
  
  
  
  


• Expertise can be in the areas of
  
  
  
  • design concepts as they relate to the functions and characteristics of power system components,
  
  
  • analytical studies and the application of computer techniques to solving power system problems,
  
  
  • familiarity with power system operation, practices and policies,
  
  
  • district operating and system requirements,
  
  
  • concepts of power system operation including technical features of equipment and facilities, high-tension transmission and system interchange between systems,
  
  
  • familiarity with the Market Rules,
  
  
  • design concepts for market scheduling and dispatch algorithm and equations,
  
  
  • familiarity with market and internal bid-to-bill business processes and procedures,
  
  
  • design concept for financial risk management at the IESO administered market level
  
  
  • familiarity with various market administration processes and procedures,
  
  
  • familiarity with financial and pay services business processes and procedures and information analysis reporting systems.
  
  
  • expertise with ETL development (SAP BODS and Boomi)
  
  
  • proficiency in SQL query and data modeling.
  
  
  
  


• A period of over eight years, up to and including ten years, is considered necessary to gain this experience.

How We Support You

From a comprehensive total rewards program to dynamic learning and development opportunities—including job rotations to broaden your expertise—we empower you to define and shape your own success. When you join the IESO, here’s what you can expect:

• Best-in-class benefits and long-term support in the form of a defined benefit pension plan. 


• Work in a dynamic and evolving sector that offers exciting opportunities and the chance to explore new career paths.


• Leadership that values meaningful discussions, welcomes feedback, and prioritizes career development. 


• A strong, inclusive culture and a collaborative team environment with a shared passion for impactful work.


• Compensation packages that are regularly reviewed to remain competitive and to best accommodate the diverse needs of our employees. 

Deadline: August 10, 2026 at 11:59PM

For future reference, please save a copy of the job posting as it will no longer be available once the posting closes.

Thank you for your interest in a career at the IESO. Only candidates selected for an interview will be contacted. Please note that the successful candidate must be legally eligible to work in Canada and will be subject to applicable background checks. 

IESO will not conduct interviews or offer positions via online, text, chat or social media platforms. We will not gather personal information directly from candidates or potential candidates. Selected candidates will work with our Talent Acquisition team to ensure their application is processed.

The IESO currently has a 3-day in-office work week for applicable roles. Over the course of 2026, the IESO will advance plans to acquire additional office space to accommodate more in-office time. While the timeline for moving to a full 5-day in-office model has not yet been established, we are committed to keeping employees and candidates informed as plans progress and give them as much advance notice as possible to prepare for any changes. 

We believe in opportunities for everyone. 

At the IESO, we know that achieving great results depends on embracing diversity by attracting, developing, and retaining people from a wide variety of backgrounds. We do this by ensuring our recruitment and advancement policies are fair and equitable, and by creating an accessible and inclusive environment—one that values every team member’s unique skills and experiences and ensures they have the support they need to achieve their potential. If you require accommodation during the recruitment process, please let us know. We’re proud to say we’ve been recognized as a supportive, inclusive employer. 

Be sure to follow us on LinkedIn.