Please Note: If you are a current Hydro Ottawa employee with access to Workday, apply to this job via the Workday application.
At Hydro Ottawa, we empower the lives of the people in the communities we serve.
As the electricity distributor to the Nation’s Capital, our work powers all the essential activities that make up our lives - at home, at work and at play. And as Ontario’s largest municipally-owned producer of green power, we are leading the way to a greener tomorrow.
We are looking for trailblazers and innovators to join us as we build an energy future that will keep our City and our planet green for generations to come.
Are you ready to make a difference in our community?

JOB SUMMARY

The Programmer/Analyst, Integration and Data Architecture is responsible for development, testing and implementation of data management and integration processes and technology. This role is focused on improving the efficiency of various information systems and establishing reliable communication between systems. End-to-end “hands on” experience is required working with data, including querying, aggregation, analysis, modelling and visualization to translate raw data into actionable information for decision makers. Acting as the technical lead to project teams, the Programmer/Analyst will manage various aspects of data and integration requirements to meet strategic objectives and data transformation The successful candidate must be a self-motivated team player with the ability and passion to see enhancement initiatives through from design to completion within prescribed time frames.

EDUCATION AND EXPERIENCE

• Post-secondary education in a related field such as Computer Science, Computer Engineering, Data Engineering
• Minimum 3 years’ experience in the Information Technology field
• Experience with databases such as Oracle (SQL,PL/SQL, ODA) , SQLServer
• Experience with integration and extract transform load (ETL) tools (such as Oracle Data Integrator, Boomi, Jitterbit, Kafka, AWS integration solution)
• Minimum 3 years’ experience integrating systems with web services and cloud based solutions such as Okta, Workday, Salesforce and principles such as REST, API
• Experience with application development and source control
• Experience with cloud in general including cloud-based data solutions considered an asset (AWS, Oracle, Microsoft, Google)
• Experience with full project lifecycle including estimating, design, and development
• Experience with web servers and middleware (e.g. Web Logic, Java, Apache ecosystem)
• Experience with Linux and scripting languages (Python, Shell scripts, Perl)
• Broad knowledge of technologies and applications and gathering and interpreting data
• Utility experience considered an asset
• Experience with data warehousing solutions such as AWS Redshift, Oracle Warehouse, Hadoop, Snowflake considered an asset
• English essential, both oral and written; Bilingual (English/French) considered an asset
  This is a management group opportunity and salary will be commensurate with qualifications.
  Hydro Ottawa offers a Hybrid Work Model. Hybrid work is position specific, details of the hybrid model will be discussed with successful candidates.
  Hydro Ottawa may use artificial intelligence (“AI”) during the recruitment process to aid in the screening and selection of candidates.
  Location:
  Ottawa, ON
  Pay Range Minimum:
  $74,517.10
  Pay Range Maximum:
  $111,775.67
  Posting End Date (if applicable):
  August 27, 2025
  Hydro Ottawa is committed to establishing a qualified workforce that reflects the diverse population it serves and we encourage applications from all qualified individuals. We are also committed to preventing and removing barriers to employment for people with disabilities, and we invite you to inform us should you have any accessibility or accommodation needs.
  Applicants must be legally entitled to work in Canada

• Lead technical activity related to data management and integrations, including working with internal and external resources, as it relates to assigned IT projects and/or ongoing operational work.
• Understand and translate business requirements into detailed solution requirements to form technical scope of project.
• Architect data models, data dictionaries, analytical approaches, and data transformations that empower stakeholders, enabling them to access data and draw insights in a self-serve manner.
• Contribute to design and implementation of Big Data and Data Warehouse solutions, including requirements analysis, platform selection, technical architecture design, application design and development, testing, and deployment.
• Develop system integrations and data feeds to and from corporate data sources in alignment with the corporate data strategy
• Act as a liaison between the project team and other functional groups on technical matters relevant to the project deliverables.
• Participate in the architecture review process and contribute to the formation and implementation of the IT application roadmap.
• Assist in leveraging technology and use knowledge of IT solutions to maximize opportunities, support business process design and drive organizational change.
• Investigate and troubleshoot problems, including impact analysis of change on all systems and business areas in order to recommend appropriate remediation.
• Perform both unit and integration tests to delivered solutions and monitor accordingly after implementation to ensure requirements are satisfied.
• Provide direction to end users and assist in the effective and efficient resolution of issues.
• Create, edit and maintain documentation, such as but not limited to, process mapping, interface mapping, entity relationship diagrams, database schemas and test cases.
• Other related duties as required.