Programmer/Analyst - Data Solution

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 Solution, 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 Solution is responsible for maintaining and enhancing all enterprise data platforms vital to the performance of corporate management and regulatory reporting.

The Programmer Analyst - Data Solution is also responsible for developing plans and overseeing all aspects of providing reliable, recoverable, and scalable transactional database / computing environments as well as data warehouse environments that store and integrate company data for insights and reporting.

MAJOR RESPONSIBILITIES

Design, manage, administer, document, and provide technical and strategic support for all corporate and business-critical transactional database systems.

Develop system integrations and messaging standards to support required data flows across systems while optimizing them for efficient data extraction, transformation, and analysis.

Architect enterprise databases and data 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 the Affiliate Relationships Code.

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.

Determine scope and prepare detailed requirements documents for tasks and projects to ensure scope and business requirements are understood and acceptable to all stakeholders.

Responsible for development and re-engineering initiatives aimed at increasing the quality and efficient use of the corporate data platform .

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 delivered systems solutions and monitor systems after implementation to ensure requirements are satisfied.

Recommend enhancements to reporting , visualization, dashboard and insights tools used for monitoring key performance measures necessary for making strategic business decisions.

Provide direction to internal and external users and assist in the effective and efficient resolution of data issues.

Provide data administration such as backups, disaster recovery, database tuning, configuration & troubleshooting.

Safeguard all confidential information

Other related duties as assigned.

EDUCATION AND EXPERIENCE

University Degree in Computer Science, Information Technology or related discipline.

Experience and other formal training combined with demonstrated performance may substitute for stipulated academic requirements.

Minimum 6 years working with Oracle databases, Oracle Enterprise Monitoring, Oracle Apex and SQLServers.

Minimum 3 years working with Snowflake.

Expert using data integration tools such as Boomi, Kafka, ODI.

Experience and knowledge with data orchestration such as Apache Airflow, dbt, Data cleansing and data quality tools, data catalog and data migration.

Experience and thorough knowledge of programming SQL, PL / SQL, Python, Java or Spark.

Experience and strong knowledge of financial databases and interaction between subsystems and tables (AR, AP, GL, HR, Work Orders, Contract Billing, Inventory etc.).

Past experience managing databases for ERP.

Familiarity working with cloud providers specially GCP . AWS and Oracle Cloud.

Experience with Data migration and High Availability solutions.

Strong working knowledge of Windows and Linux environments, Docker and Kubernetes considered an asset.

Utility experience is considered an asset.

Experience with MySQL and PostgreSQL, NoSQL Databases such as MongoDB, DynamoDB, Cloud Data Warehouses such as Amazon Redshift, Google BigQuery and Graph Databases such as Neo4j, Amazon Neptune considered an asset.

English language skills essential, Bilingualism (French / English) or other languages 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

Ottawa, ON

Pay Range Minimum : $70,146.95

$70,146.95

Pay Range Maximum : $105,220.44

$105,220.44

Posting End Date (if applicable) :

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