Programmer/Analyst - Data Engineering

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 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 seeking a Programmer/Analyst - Data Engineering, a strategic thinker who can take initiatives from concept to completion and engineer the way to a smart energy future.

Are you ready to make a difference in our community?

JOB SUMMARY

The Programmer/Analyst - Data Engineering is responsible for maintaining, enhancing and ensuring the reliability and scalability of Hydro Ottawa’s enterprise data systems, including transactional databases and data lake platforms. The Programmer/Analyst supports corporate management and regulatory reporting needs by maintaining the data infrastructure and ensuring it is robust, recoverable, and capable of meeting the business demands and reporting requirements.

MAJOR RESPONSIBILITIES

• Maintain, document, and provide technical and strategic support for all corporate and business-critical transactional database systems and data warehouse platforms.

• Ensure enterprise databases and data warehouse platforms ensure their reliability, scalability, and performance to support critical corporate management reporting and regulatory compliance.

• Ensure corporate data integrity by securing access to confidential and strategic information, and ensure system compliance with cybersecurity roadmaps and recommendations.

• Advise application development and support teams on optimal use of database and transaction management technology through the creation and communication of standards and instructions of critical application components.

• Resolve data-related problems across various systems, including transactional databases and data warehouses.

• Investigate and analyze problems and business requirements, including impact analysis of change, on all data ecosystems and its life cycle in order to recommend appropriate solutions.

• Test and monitor systems post-implementation to ensure requirements are met.

• Perform data administration such as patching, backups, disaster recovery, database tuning, configuration & troubleshooting of transactional databases.

• Participate in Data Modeling, Data transformation, Data Extraction and performance optimization of all data platforms.

• Protect all confidential information by ensuring secure access to systems and databases, adhering to company policies on data privacy and security, and maintaining the highest level of integrity in handling sensitive data.

• Perform other related duties as required.

EDUCATION AND EXPERIENCE

• Post- secondary degree in computer science, computer engineering or information technology

• Minimum 3 years hands-on experience with SQL

• Minimum 3 years experience with Snowflake (preferred) or other cloud-based data warehouse technologies such as BigQuery or Redshift

• Minimum 3