Data Engineer

Socket.dev; Ottawa; On-site; CAD 90,000 - 120,000; Full time

Job summary

Payments Canada is seeking a Data Engineer to design and develop data ingestion and analytical solutions within our organization. Reporting to the Manager, Data Analytics and BI, you will build data solutions, unit test them, and provide production support.

Collaborating with technical architects and functional designers, you will shape data conversion procedures, apply strong communication and problem-solving skills, and help steer decisions on data ingestion, processing and storage for a

Qualifications

• Experience designing ETL/ELT pipelines.
• Strong SQL and data modeling skills.
• Ability to design dashboards and reports.
• Understanding data lakes and data warehouses.

Responsibilities

• Design and model warehousing data structures.
• Design and develop ETL/ELT solutions for modernization data.
• Create SQL solutions and dashboards for stakeholders.
• Lead data storage and processing components (custom or reused).
• Provide production support and monitor data solutions.

Skills

Data ingestion

ETL/ELT design

SQL

Dashboards

Data modeling

Job description

Payments Canada is at the forefront of the Canadian payment ecosystem. Our purpose is to make payments easier, smarter and safer for all Canadians. Every day we are working diligently to ensure your payments are cleared and settled. In 2025 alone, our systems cleared approximately $103 trillion or $411.9 billion every business day! If you are passionate about payments and want to help ensure that these financial transactions in Canada are carried out safely and securely, working with us is for you!

Who we are

We are a public purpose, non-profit organization situated at the center of Canada's payment ecosystem. We own and operate payment systems that process hundreds of billions of dollars' worth of payment transactions every business day. We convene ecosystem participants to discuss their multiple and diverse interests and ideas and to navigate industry-level challenges. We adhere to a set of values that are our north star:

Inspire trust, build community and enable change.
Payments Canada - where our country connects

Our culture

With our people in mind, we have created a culture that fosters authenticity, collaboration, innovation and development. We empower one another, make meaningful contributions that not only impact the organization, but our country! We develop and nurture meaningful connections that drive innovation in our ecosystem. We are Payments Canada!

Do you want to make payments easier, smarter and saferfor Canada? Join us today!
You need to work here if

• You love working with passionate, ambitious and collaborative colleagues.
• You want to be challenged and lead unique initiatives.
• You want to grow, develop and become a subject matter expert in your field.
• You want your work to make an impact in your community and country.

Come and join us - where payments meet purpose!

What we are looking for

The Data Engineer will design and develop data ingestion and analytical solutions within Payments Canada. Reporting to the Manager, Data Analytics and BI, the Data Engineer will design and develop and unit test data solutions. In addition, the Data Engineer will be called upon to provide production support and resolve issues that may arise running data solutions.

The Data Engineer will be called upon to work with technical architects and functional designers to understand data conversion requirements and design the conversion procedures and applications for new and legacy systems that underpin the Canadian economy. Additionally, the Data Engineer will apply proven communication, analytical, and problem-solving skills to help the business make good technology decisions as it relates to the ingestion, processing and storage of data.

Duties and Responsibilities of the Data Engineer position will include but is not limited to:

Modeling and design of new warehousing data structures

• Thorough understanding of the data lake/data warehouse solutions being built.
• Key player on data lake data warehouse solution development.
• Design and develop ETL/ELT solutions for Modernization data.
• Design and develop SQL solutions.
• Design and develop dashboards and reporting outputs.
• Understand the data landscape of source systems.
• Design data lakes, data warehouses to hold and serve data (Data Modeling).
• Design and develop data ingestion ETL/ELT processes.
• Design and develop dashboards and other reporting outputs.
• Leading the analysis, design, and build efforts for all data storage and processing components being custom built or reused.

Stakeholder communications

• Advocate on data best practices.
• Champion on organization data literacy.

Production support

• Participate in monitoring production systems.
• Research and diagnose failures and issues in a timely manner.