Data Engineer

Payments Canada; Toronto; Hybrid; CAD 83,000 - 97,000; Full time

Benefits offered by this job

Hybrid work

Professional development

Competitive compensation

Pension plan

Job summary

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

You will work with technical architects and designers to map data conversion requirements and ensure robust data ingestion, processing and storage for Canada’s financial ecosystem.

Qualifications

• Bachelor-level or higher education in IT/CS or related field.
• 3+ years of experience in data engineering, ETL/ELT development, and data warehousing.

Responsibilities

• Modeling and design of warehousing data structures.
• Design and develop ETL/ELT processes for data modernization.

Skills

SQL

BigQuery

ETL/ELT

Data Modeling

Programming (Python/Java/JS)

GIT

Education

Post-secondary education in IT/CS

Tools

Google Cloud Platform

Pentaho Data Integration

Git

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.

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 safer for 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.
• Provide suggestions and solutions to resolve problems.

Technical Competencies

• Strong expertise in SQL
• Knowledge of Google Cloud Platform data technologies (BigQuery, Cloud Data Storage, Data Flow)
• Knowledge of Pentaho data tools including Pentaho Data Integration.
• Proficiency in at least 2 programming languages (javascript, java, python, etc)
• Proficiency in database design and architecture.
• Knowledge of source code management principles and experience with GIT

Personal Competencies

• Social and self-awareness
• Ability to convey complex technical concepts into business terms
• Excellent written, verbal communication and presentation skills
• Ability to develop and maintain effective working relationships
• Sound judgment, initiative and flexibility
• Strong attention to detail and quality
• Team player; strong sense of responsibility in taking ownership

What you need to be successful

• Post-secondary education in Information Technology, Computer Science, Software Development.
• Minimum of three (3) years of experience in data engineering, ETL/ELT development, Database Design.
• Experience in Google Cloud Platform data technologies (BigQuery, Cloud Data Storage, Data Flow).
• Eligibility to obtain and maintain a Government of Canada Reliability Status Clearance and can successfully complete enhanced background checks that may be carried out by Payments Canada.

You will really stand out with

• Experience or understanding of Machine Learning techniques.
• GCP certification.

Salary range

Our target starting rate for this role is $83,300 with flexibility based on your experience and qualifications. The full salary range and benefits package are detailed below.

What's in it for you?

• Flexible, hybrid (remote/office) environment.
• Competitive compensation package, including annual variable bonus and defined contribution pension plan with employer matching percentage (if eligible).
• Comprehensive health and dental benefit coverage, including mental health coverage, life insurance and a health spending account for you and your dependents (Permanent and temporary employees with contracts 12 months and over).
• Paid time off: minimum four weeks paid vacation, sick and personal days, December holiday shutdown and cultural holiday observance days.
• 26 weeks of paid maternity and parental leave top-up (if eligible)
• Rewards and recognition program.
• Access to office gym facilities.
• Internal and external professional development opportunities.
• Fun team and organizational events.
• Monthly all staff forums led by our Executive Leadership Team.

Our Commitment to Fair Hiring

At Payments Canada, we are dedicated to fair, transparent and inclusive hiring. We are an equal opportunity employer and value diversity at our company. Our recruitment process uses automated tools, but not generative AI, to objectively screen and evaluate applications and confirm that a candidate’s qualifications meet job requirements. It is important to remember that these tools support, but do not replace, human decision-making. Our trained recruitment professionals and hiring managers always make the final hiring decisions.

Our diversity, inclusion and equity commitment

At Payments Canada, we are committed to making everyone feel they can be themselves and thrive at work. We will continue to build on a foundation of respect and appreciation for diversity in all forms and collectively create an inclusive and equitable culture where our differences are valued. We are committed to employment equity and actively encourage applications from women, Aboriginal people, persons with disabilities and visible minorities. If selected for an interview, please advise us if you require special accommodation by emailing [e-mail]. We thank all applicants for their interest in this opportunity. Preference will be given to Canadian citizens and permanent residents. Only selected candidates will be contacted for an interview.