Programmer/Analyst - Data Engineering

at  Hydro Ottawa

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

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 years of hands-on experience with transactional databases specifically Oracle databases, Oracle Enterprise Monitoring, Oracle Apex, and SQL Server
• Minimum 2 years of hands-on experience with administration, patching, migration and high availability solutions with transactional databases specifically in Oracle technology
• Minimum 2 years of hands-on experience with transactional database backup, recovery and performance tuning
• Strong hands-on experience working in a Linux environment
• Minimum 2 years of experience working with a major cloud provider (GCP or AWS preferred)
• Minimum 2 years of experience with Python, Spark or R
• Minimum 1 year experience with AI, machine learning, LLMs, and vector databases
• Hands-on experience with Oracle database applications or other Oracle technologies is an asset
• Experience with Docker, Kubernetes, API development and utility sector experience considered an asset
• Strong computer skills; proficient in the use of office productivity and collaboration tools, preferably Google Workspace
• 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, the details of which 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:
  $70,146.95
  Pay Range Maximum:
  $105,220.44
  Posting End Date (if applicable):
  November 15, 2024
  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

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