Data Solutions Analyst

2 days ago

Ottawa, Ontario, Canada Hydro Ottawa Full time
Job Summary

Hydro Ottawa is seeking a skilled Programmer/Analyst - Data Solution to join our team. As a key member of our organization, you will be responsible for maintaining and enhancing all enterprise data platforms vital to the performance of corporate management and regulatory reporting.

Main Responsibilities
  1. Design, manage, administer, document, and provide technical and strategic support for all corporate and business-critical transactional database systems.
  2. Develop system integrations and messaging standards to support required data flows across systems while optimizing them for efficient data extraction, transformation, and analysis.
  3. Architect enterprise databases and data platforms to ensure their reliability, scalability, and performance to support critical corporate management reporting and regulatory compliance.
  4. Ensure corporate data integrity by securing access to confidential and strategic information, and ensure system compliance with the Affiliate Relationships Code.
  5. 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.
  6. Determine scope and prepare detailed requirements documents for tasks and projects to ensure scope and business requirements are understood and acceptable to all stakeholders.
  7. Responsible for development and re-engineering initiatives aimed at increasing the quality and efficient use of the corporate data platform.
  8. 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.
  9. Test delivered systems solutions and monitor systems after implementation to ensure requirements are satisfied.
  10. Recommend enhancements to reporting, visualization, dashboard, and insights tools used for monitoring key performance measures necessary for making strategic business decisions.
  11. Provide direction to internal and external users and assist in the effective and efficient resolution of data issues.
  12. Provide data administration such as backups, disaster recovery, database tuning, configuration, and troubleshooting.
  13. Safeguard all confidential information.
Requirements
  • 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 SQL Servers.
  • 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 strong 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, especially 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.
What We Offer

Hydro Ottawa offers a Hybrid Work Model. Hybrid work is position-specific, the details of which 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

  • Data Management Solutions Architect

    3 weeks ago

    Ottawa, Ontario, Canada Data Sentinel Full time

    About the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...

  • Data Management Solutions Architect

    3 weeks ago

    Ottawa, Ontario, Canada Data Sentinel Full time

    About the RoleWe are seeking a highly skilled Data Management Solutions Architect to join our team at Data Sentinel. As a key member of our delivery team, you will be responsible for working with our clients to deploy and implement our sensitive information intelligence platform.Key ResponsibilitiesDeployment and Configuration: Responsible for the successful...

  • Data Solutions Analyst

    6 days ago

    Ottawa, Ontario, Canada Hydro Ottawa Full time

    Job SummaryHydro Ottawa is seeking a skilled Programmer/Analyst - Data Solution to join our team. As a key member of our organization, you will be responsible for maintaining and enhancing all enterprise data platforms vital to the performance of corporate management and regulatory reporting.Main ResponsibilitiesDesign, manage, administer, document, and...

  • Data Solutions Analyst

    6 days ago

    Ottawa, Ontario, Canada Hydro Ottawa Full time

    Job SummaryHydro Ottawa is seeking a skilled Programmer/Analyst - Data Solution to join our team. As a key member of our organization, you will be responsible for maintaining and enhancing all enterprise data platforms vital to the performance of corporate management and regulatory reporting.Main ResponsibilitiesDesign, manage, administer, document, and...

  • Lead Architect Data and Digital Solutions

    3 weeks ago

    Ottawa, Ontario, Canada NTT DATA Full time

    Job Summary:We are seeking a highly skilled and experienced Lead Architect Data and Digital Solutions to join our team at NTT DATA. As a key member of our team, you will be responsible for leading the development of a Power Platform based compliance solution to streamline processes.Key Responsibilities:Conduct business process analysis and create a...

  • Lead Architect Data and Digital Solutions

    3 weeks ago

    Ottawa, Ontario, Canada NTT DATA Full time

    Job Summary:We are seeking a highly skilled and experienced Lead Architect Data and Digital Solutions to join our team at NTT DATA. As a key member of our team, you will be responsible for leading the development of a Power Platform based compliance solution to streamline processes.Key Responsibilities:Conduct business process analysis and create a...

  • Data Analyst

    1 day ago

    Ottawa, Ontario, Canada Export Development Canada Full time

    Job Title: Data AnalystWe are seeking a highly motivated and detail-oriented Data Analyst to join our team. As a Data Analyst, you will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Design and implement data visualizations to communicate insights to stakeholdersDevelop and maintain databases...

  • Data Analyst

    2 days ago

    Ottawa, Ontario, Canada Export Development Canada Full time

    Job Title: Data AnalystWe are seeking a highly motivated and detail-oriented Data Analyst to join our team. As a Data Analyst, you will be responsible for analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Design and implement data visualizations to communicate insights to stakeholdersDevelop and maintain databases...

  • Solution Architect

    2 weeks ago

    Ottawa, Ontario, Canada Data Sentinel Full time

    About YouYou are a skilled and experienced professional with a strong background in software solution deployments, particularly with containerized applications. Your expertise in data management, including data inventory, data quality, data classification, data privacy, and data compliance, is highly valued. You have a university or college degree and a...

  • Solution Architect

    2 weeks ago

    Ottawa, Ontario, Canada Data Sentinel Full time

    About YouYou are a skilled and experienced professional with a strong background in software solution deployments, particularly with containerized applications. Your expertise in data management, including data inventory, data quality, data classification, data privacy, and data compliance, is highly valued. You have a university or college degree and a...

  • Senior Business Solutions Analyst

    7 days ago

    Ottawa, Ontario, Canada Bronson Technical Search Full time

    Job Title:Senior Business Solutions AnalystJob Summary:We are seeking a highly skilled Senior Business Solutions Analyst to join our team at Bronson Technical Search. As a Senior Business Solutions Analyst, you will be responsible for analyzing client needs, designing data and technology solutions, and leading project execution.Key Responsibilities:Lead the...

  • Senior Business Solutions Analyst

    6 days ago

    Ottawa, Ontario, Canada Bronson Technical Search Full time

    Job Title:Senior Business Solutions AnalystJob Summary:We are seeking a highly skilled Senior Business Solutions Analyst to join our team at Bronson Technical Search. As a Senior Business Solutions Analyst, you will be responsible for analyzing client needs, designing data and technology solutions, and leading project execution.Key Responsibilities:Lead the...

  • Senior Business Solutions Analyst

    3 days ago

    Ottawa, Ontario, Canada Bronson Technical Search Full time

    Job Title:Senior Business Solutions AnalystJob Summary:We are seeking a highly skilled Senior Business Solutions Analyst to join our team at Bronson Technical Search. As a Senior Business Solutions Analyst, you will be responsible for analyzing client needs, designing data and technology solutions, and leading project execution.Key Responsibilities:Lead the...

  • Senior Business Solutions Analyst

    3 days ago

    Ottawa, Ontario, Canada Bronson Technical Search Full time

    Job Title:Senior Business Solutions AnalystJob Summary:We are seeking a highly skilled Senior Business Solutions Analyst to join our team at Bronson Technical Search. As a Senior Business Solutions Analyst, you will be responsible for analyzing client needs, designing data and technology solutions, and leading project execution.Key Responsibilities:Lead the...

  • Data Quality Specialist

    3 weeks ago

    Ottawa, Ontario, Canada LeverageTek IT Solutions Full time

    About the RoleLeverageTek IT Solutions is seeking a highly skilled Data Quality Specialist to join our team on a 12-month contract basis.Key ResponsibilitiesCollaborate with our customer's team to establish business rules, data quality rules, and thresholds for data assessmentConduct data testing, profiling, and assessment based on customized data quality...

  • Data Quality Specialist

    3 weeks ago

    Ottawa, Ontario, Canada LeverageTek IT Solutions Full time

    About the RoleLeverageTek IT Solutions is seeking a highly skilled Data Quality Specialist to join our team on a 12-month contract basis.Key ResponsibilitiesCollaborate with our customer's team to establish business rules, data quality rules, and thresholds for data assessmentConduct data testing, profiling, and assessment based on customized data quality...

  • Business Data Analyst

    3 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Data AnalystElectricity Canada is seeking a highly skilled Business Data Analyst to join our team. As a Business Data Analyst, you will play a critical role in supporting our reliability program by analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Collect and process large data sets to identify...

  • Business Data Analyst

    3 days ago

    Ottawa, Ontario, Canada Electricity Canada Full time

    Job Title: Business Data AnalystElectricity Canada is seeking a highly skilled Business Data Analyst to join our team. As a Business Data Analyst, you will play a critical role in supporting our reliability program by analyzing and interpreting complex data sets to inform business decisions.Key Responsibilities:Collect and process large data sets to identify...

  • Senior Business Solutions Analyst

    5 days ago

    Ottawa, Ontario, Canada Bronson Technical Search Full time

    Job Title:Senior Business Solutions AnalystJob Summary:We are seeking a highly skilled Senior Business Solutions Analyst to join our team at Bronson Technical Search. As a key member of our consulting team, you will be responsible for analyzing client needs, designing data and technology solutions, and leading project execution.Key Responsibilities:Lead the...

  • Senior Business Solutions Analyst

    5 days ago

    Ottawa, Ontario, Canada Bronson Technical Search Full time

    Job Title:Senior Business Solutions AnalystJob Summary:We are seeking a highly skilled Senior Business Solutions Analyst to join our team at Bronson Technical Search. As a key member of our consulting team, you will be responsible for analyzing client needs, designing data and technology solutions, and leading project execution.Key Responsibilities:Lead the...