Programmer/Analyst - Data Engineering

5 days ago

Ottawa, Canada Hydro Ottawa Full time
Programmer/Analyst - Data Engineering

Locations: Ottawa, ON

Time Type: Full time

Posted on: Posted 5 Days Ago

Time left to apply: End Date: November 16, 2024 (9 days left to apply)

Job Requisition ID: R004127

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.

MAJOR RESPONSIBILITIES

  1. Maintain, document, and provide technical and strategic support for all corporate and business-critical transactional database systems and data warehouse platforms.
  2. Ensure enterprise databases and data warehouse platforms ensure their reliability, scalability, and performance to support critical corporate management reporting and regulatory compliance.
  3. Ensure corporate data integrity by securing access to confidential and strategic information, and ensure system compliance with cybersecurity roadmaps and recommendations.
  4. 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.
  5. Resolve data-related problems across various systems, including transactional databases and data warehouses.
  6. 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.
  7. Test and monitor systems post-implementation to ensure requirements are met.
  8. Perform data administration such as patching, backups, disaster recovery, database tuning, configuration & troubleshooting of transactional databases.
  9. Participate in Data Modeling, Data transformation, Data Extraction and performance optimization of all data platforms.
  10. 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.
  11. Perform other related duties as required.

EDUCATION AND EXPERIENCE

  1. Post-secondary degree in computer science, computer engineering or information technology.
  2. Minimum 3 years hands-on experience with SQL.
  3. Minimum 3 years experience with Snowflake (preferred) or other cloud-based data warehouse technologies such as BigQuery or Redshift.
  4. Minimum 3 years of hands-on experience with transactional databases specifically Oracle databases, Oracle Enterprise Monitoring, Oracle Apex, and SQL Server.
  5. Minimum 2 years of hands-on experience with administration, patching, migration and high availability solutions with transactional databases specifically in Oracle technology.
  6. Minimum 2 years of hands-on experience with transactional database backup, recovery and performance tuning.
  7. Strong hands-on experience working in a Linux environment.
  8. Minimum 2 years of experience working with a major cloud provider (GCP or AWS preferred).
  9. Minimum 2 years of experience with Python, Spark or R.
  10. Minimum 1 year experience with AI, machine learning, LLMs, and vector databases.
  11. Hands-on experience with Oracle database applications or other Oracle technologies is an asset.
  12. Experience with Docker, Kubernetes, API development and utility sector experience considered an asset.
  13. Strong computer skills; proficient in the use of office productivity and collaboration tools, preferably Google Workspace.
  14. 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.

Power Your Future at Hydro Ottawa

Why choose a career at Hydro Ottawa?

We are Committed to a Better Tomorrow

Our creative, innovative and forward-thinking employees are blazing the trail to a better tomorrow as we work towards our ambitious goal of achieving net-zero operations by 2030.

We Celebrate Diversity and Inclusivity

Hydro Ottawa is committed to employing a diverse workforce that better reflects the communities we serve; we want our employees to be their true selves.

We Have an Award-Winning Environment

We are recognized year over year as a National Capital Region Top Employer, one of Canada’s Greenest Employers, and one of Canada’s Top Employers for Young People.

Together we are shaping the future - join us #J-18808-Ljbffr

  • Programmer/Analyst - Data Engineering

    5 days ago

    Ottawa, Canada Hydro Ottawa Full time

    Programmer/Analyst - Data Engineering Locations: Ottawa, ON Time Type: Full time Posted on: Posted 5 Days Ago Time left to apply: End Date: November 16, 2024 (9 days left to apply) Job Requisition ID: R004127 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...

  • Data Analyst

    3 weeks ago

    Ottawa, Ontario, Canada Geofirma Engineering Ltd Full time

    Job Title: Data AnalystWe are seeking a highly skilled Data Analyst to join our team at Geofirma Engineering Ltd. As a Data Analyst, you will be responsible for conducting studies of groundwater flow and contamination, developing models and applied software for the analysis and interpretation of data, and working with a team of experts to provide innovative...

  • Environmental Data Analyst

    3 days ago

    Ottawa, Ontario, Canada Geofirma Engineering Ltd Full time

    Job Title: Environmental Data AnalystAt Geofirma Engineering Ltd, we are seeking a highly skilled Environmental Data Analyst to join our team. As an Environmental Data Analyst, you will play a key role in conducting studies of groundwater flow and contamination, developing models and applied software for the analysis and interpretation of data, and ensuring...

  • Programmer/Analyst - Data Solution

    4 months ago

    Ottawa, Canada Hydro Ottawa Full time

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

  • Systems Analyst

    5 months ago

    Ottawa, Canada NTT DATA Full time

    We are currently seeking a Systems Analyst to join our team in Canada. Location: Remote Language: Bilingual (English/French) Security: Reliability **How You'll Help Us**: We are looking for a Systems Analyst with 5 years experience. You will work collaboratively with stakeholders to identify improvements and design systems to implement those and...

  • Clinical Programmer Analyst

    1 month ago

    Ottawa, Ontario, Canada Adecco Canada Full time

    Adecco Canada is Hiring a Clinical Programmer AnalystWe are seeking a highly skilled Clinical Programmer Analyst to join our team in Ottawa, Canada. As a Clinical Programmer Analyst, you will be responsible for generating and validating tables, listings, and figures (TLF) based on specifications provided by Statistics and/or Clinical Writers.Key...

  • Senior Programmer Analyst

    4 weeks ago

    Ottawa, Canada MDOS Consulting Full time

    We are looking for a Senior Programmer Analyst for Communications Security Establishment (CSE) with security clearance of Top Secret – SIGINT. Job Specifications: Must have a University degree at the Bachelor level in Science, Computer Science, Engineering, or Mathematics and/or Community College Diploma in Information Technology, Computer Science, or...

  • Senior Programmer Analyst

    1 month ago

    Ottawa, Canada MDOS Consulting Full time

    We are looking for a Senior Programmer Analyst for Communications Security Establishment (CSE) with security clearance of Top Secret – SIGINT. Job Specifications: Must have a University degree at the Bachelor level in Science, Computer Science, Engineering, or Mathematics and/or Community College Diploma in Information Technology, Computer Science, or...

  • Data Analyst

    3 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are seeking a skilled Database Specialist to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and models.The ideal candidate will have a...

  • Data Analyst

    2 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    At SEAMS DATA, we are seeking a skilled Database Specialist to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems to analyze data, and developing and implementing data administration policy, standards, and models.The ideal candidate will have a strong...

  • Data Architect

    1 month ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet business...

  • Data Architect

    1 month ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet business...

  • Project Oversight Analyst, Programme Analyst and

    1 month ago

    Ottawa, Canada Fisheries and Oceans Canada Full time

    Fisheries and Oceans Canada and the Canadian Coast Guard - Shipbuilding and Materiel, Vessel Procurement Ottawa (Ontario) AS-04 $80,612 to $87,108 For further information on the organization, please visit Fisheries and Oceans Canada and the Canadian Coast Guard **Closing date: 7 October 2024 - 23:59, Pacific Time** **Who can apply**: Persons residing in...

  • Data Architect

    4 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet business...

  • Data Architect

    4 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data management team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet business...

  • Data Architect

    3 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet business requirementsOperate...

  • Data Architect

    3 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDesign and develop databases to meet business requirementsOperate...

  • Data Architect

    4 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDatabase Design and Development: Design and develop databases to...

  • Data Architect

    4 weeks ago

    Ottawa, Ontario, Canada SEAMS DATA Full time

    Job DescriptionSEAMS DATA is seeking a highly skilled Database Analyst to join our team. As a key member of our data team, you will be responsible for designing and developing databases, operating database management systems, and analyzing data to inform business decisions.Key ResponsibilitiesDatabase Design and Development: Design and develop databases to...

  • Data Analyst

    5 months ago

    Ottawa, Canada CAA North & East Ontario Full time

    **Job Title: Data Analyst** **Location: HYBRID: Work-From-Home / 1031 Bank St, Ottawa, ON** **Job Summary**: The Data Analyst plays a pivotal role in facilitating data-driven decision-making across the organization by collecting, analyzing, and interpreting complex datasets. They possess a keen analytical mindset, a knack for problem-solving, and a passion...