Senior ETL Developer

1 month ago

Ottawa, Canada Canadian Institute for Health Information Full time
Category

Software Development

City

Ottawa, Toronto, Ontario, Canada

Job Description

Senior ETL Developer

Who we are
We are an organization comprised of industry thought leaders who are passionate about health data and want to make a difference in the health care field. We are an independent, not-for-profit organization and together with our partners we provide essential information on Canada's health systems, enabling decisions that lead to healthier Canadians. As a valued member of the CIHI team, you and your work will have a pivotal role in the evolution of Canada's health care systems.

CIHI is recognized as an exceptional place to work that embraces diversity, respect, integrity, collaboration and innovation. Learn about our Equity, Diversity and Inclusion Strategy and the work being done to create a more inclusive and welcoming organization by focusing on how we learn, govern and practise.

At CIHI, we recognize what matters to our employees. Some of the benefits of working at CIHI include:

  • HOOPP Pension Plan (Defined Benefits Pension)
  • Retirement Planning Program
  • Generous vacation days for permanent and long-term contracts
  • Work-life balance
  • Career Planning Program
  • Learning and Professional Development Program
  • Flexible benefits program from your first day on the job for permanent and long-term contracts
Why is this role important?

The Senior ETL Developer works on defining system solutions to acquire and share data and develop information and analyses to CIHI’s clients and stakeholders. The Senior Developer operates, maintains and develops system solutions in current technologies as well as supporting and enabling initiatives on new platforms, technologies and services.

What you'll do
  1. Develops information systems, which may include the full range of requirements and feasibility analysis, design, coding, testing, quality assurance, implementation and documentation, as well as day-to-day application operation and end-user support, as part of a technical team.
  2. Develops business processes knowledge and maintain ongoing contact, to ensure satisfaction by meeting business partner needs through information systems development, enhancements and integrations.
  3. Executes the operational tasks related to incident troubleshooting and correction and scheduled product releases and works on optimizing and automating these tasks to reduce operational effort, on a rotation basis.
  4. Analyses software deficiencies/problems and change requests, implements the changes within the production systems and may be required to oversee and ensure timely implementation of the changes for the technical team.
  5. Develops, modifies and executes test plans, using automation to improve testing coverage and reduce effort.
  6. Ensures the correct testing and sign-off procedures as part of CIHI’s quality assurance review.
  7. Ensures the promotion and implementation of applications in accordance with departmental change management processes.
  8. Participates in the planning, development and delivery of end user training.
What you'll bring to the table
  • University Degree or equivalent education/experience in Computer Science, Mathematics or related discipline.
  • Three (3) + years experience as an ETL developer, developing technical solutions for a web/Cloud based environment utilizing the below technologies.
  • Three (3) + years proven experience with ETL tools (Informatica DEI/BDM), PySpark, Oracle DB, PL/SQL, Git, Airflow, Python.
  • Knowledge and experience with Cloud AWS environment, tools and services is an asset.
  • Proficient knowledge and experience in shell scripting in Linux/Unix environment.
  • Experience in creating and maintaining documentation of project ETL design, technical artifacts and ETL environment.
  • Experience with AWS EMR platform is an asset.
  • Experience with the following is an asset: Scrum/Kanban Agile framework, Data warehousing platforms (AWS RDS, Redshift), Data analytics (Python, R, SAS), BI Tools (MicroStrategy, Qlik).
  • Knowledge and experience with automated testing and DevOps is an asset.
  • Ability to understand and prioritize user and business requirements, and to conceptualize information processing solutions in response to them.
  • Ability to plan and coordinate workload effectively, including managing and prioritizing multiple tasks.
  • Strong team player with a client/user orientation.
  • Fluency in English is required; bilingualism, in both official languages is an asset.
Closing Statement

To find out more about this role and other exciting opportunities visit our website at www.cihi.ca and check out our 'Careers' section.

We thank all those who apply, however, only candidates selected for an interview will be contacted.

Employment Equity

At CIHI we are committed to fostering an inclusive, barrier-free and accessible environment. Part of this commitment includes arranging accommodations to ensure an equitable opportunity to participate in the recruitment and selection process. If you require an accommodation, we will work with you to meet your needs.

#J-18808-Ljbffr

  • Senior ETL Developer

    4 days ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    Senior ETL Developer OpportunityWe are seeking a highly skilled Senior ETL Developer to join our team at Nexus Systems Group Inc.Key Responsibilities:Design and implement complex data transformations to load target databases from multiple systems.Monitor and troubleshoot data loads to ensure accuracy and efficiency.Collaborate with ETL Design and Project...

  • Senior ETL Developer

    5 days ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    Senior ETL Developer OpportunityWe are seeking a highly skilled Senior ETL Developer to join our team at Nexus Systems Group Inc.Key Responsibilities:Design and implement complex data transformations to load target databases from multiple systems.Monitor and troubleshoot data loads to ensure accuracy and efficiency.Collaborate with ETL Design and Project...

  • DI ETL Developer – Senior

    4 months ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    DI ETL Developer - Senior DUTIES • Load target data bases using complex transformations that come from many systems. • Monitor loads and troubleshoot any issues that arise. • Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues. • Participate...

  • DI ETL Developer – Senior

    4 months ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    DI ETL Developer - Senior DUTIES • Load target data bases using complex transformations that come from many systems. • Monitor loads and troubleshoot any issues that arise. • Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues. • Participate...

  • DI ETL Developer – Senior

    4 weeks ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    DI ETL Developer - SeniorDUTIESLoad target databases using complex transformations that come from many systems.Monitor loads and troubleshoot any issues that arise.Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.Participate in the design sessions...

  • DI ETL Developer – Senior

    4 weeks ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    DI ETL Developer - SeniorDUTIESLoad target databases using complex transformations that come from many systems.Monitor loads and troubleshoot any issues that arise.Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.Participate in the design sessions...

  • DI ETL Developer – Senior

    4 weeks ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    DI ETL Developer - SeniorDUTIESLoad target databases using complex transformations that come from many systems.Monitor loads and troubleshoot any issues that arise.Meet with ETL Design and Project Leads to understand business, financial, and operations requirements and systems goals, and identify and resolve systems issues.Participate in the design sessions...

  • Senior ETL Developer

    2 weeks ago

    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    Job SummaryThe Senior ETL Developer works on defining system solutions to acquire and share data and develop information and analyses to CIHI's clients and stakeholders.The Senior Developer operates, maintains, and develops system solutions in current technologies as well as supporting and enabling initiatives on new platforms, technologies, and...

  • Senior ETL Developer

    3 weeks ago

    Ottawa, Ontario, Canada Canadian Institute for Health Information Full time

    Job SummaryThe Senior ETL Developer works on defining system solutions to acquire and share data and develop information and analyses to CIHI's clients and stakeholders.The Senior Developer operates, maintains, and develops system solutions in current technologies as well as supporting and enabling initiatives on new platforms, technologies, and...

  • ETL Developer

    2 weeks ago

    Ottawa, Ontario, Canada CB Canada Full time

    Job Title: Data Analytics SpecialistJob Summary:The Data Analytics team at CB Canada is seeking a highly skilled Data Analytics Specialist to join our team. As an ETL Developer, you will play a critical role in receiving and processing work packages, working closely with the business to understand requirements, and delivering project solutions.Key...

  • ETL Developer

    2 weeks ago

    Ottawa, Ontario, Canada CB Canada Full time

    Job Title: Data Analytics SpecialistJob Summary:The Data Analytics team at CB Canada is seeking a highly skilled Data Analytics Specialist to join our team. As an ETL Developer, you will play a critical role in receiving and processing work packages, working closely with the business to understand requirements, and delivering project solutions.Key...

  • Senior Software Developer

    7 days ago

    Ottawa, Ontario, Canada Dell Technologies Full time

    Unlock Your Potential as a Senior Software DeveloperAt Dell Technologies, we're committed to empowering our team members to drive innovation and excellence. As a Senior Software Developer, you'll be part of our Software Engineering team, delivering cutting-edge software application enhancements and new products that transform the world.About the RoleWe're...

  • Senior Software Developer

    7 days ago

    Ottawa, Ontario, Canada Dell Technologies Full time

    Unlock Your Potential as a Senior Software DeveloperAt Dell Technologies, we're committed to empowering our team members to drive innovation and excellence. As a Senior Software Developer, you'll be part of our Software Engineering team, delivering cutting-edge software application enhancements and new products that transform the world.About the RoleWe're...

  • AWS Data Architect Senior Developer

    5 days ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperJob Summary:Nexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and...

  • AWS Data Architect Senior Developer

    4 days ago

    Ottawa, Ontario, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperJob Summary:Nexus Systems Group Inc. is seeking a highly skilled AWS Data Architect Senior Developer to join our team. As a key member of our Data Analytics team, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions.Key Responsibilities:Design and...

  • AWS Data Architect Senior Developer

    4 months ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior Developer SCOPE:As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting...

  • AWS Data Architect Senior Developer

    4 months ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior Developer SCOPE:As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting...

  • AWS Data Architect Senior Developer

    4 weeks ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperSCOPE: As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting...

  • AWS Data Architect Senior Developer

    4 weeks ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperSCOPE: As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting...

  • AWS Data Architect Senior Developer

    4 weeks ago

    Ottawa, Canada Nexus Systems Group Inc. Full time

    AWS Data Architect Senior DeveloperSCOPE: As an AWS Data Architect Senior Developer, you will be responsible for designing, implementing, and maintaining AWS data pipelines, databases, and data warehousing solutions. You will collaborate closely with our cross-functional teams to ensure efficient data extraction, transformation, loading (ETL), and reporting...