Data Engineer
Payments Canada Ottawa, Ontario, Canada · CA$74K–CA$122K/yr
Banking · 201-500 employees
About the role
The Data Engineer will design, develop, and test data ingestion and analytical solutions, including ETL/ELT processes and data warehousing structures. They will also provide production support, resolve system issues, and communicate technical data concepts to stakeholders.
What they look for
Requirements
Candidates must have a post-secondary degree in Information Technology, Computer Science, or Software Development and at least three years of experience in data engineering. Proficiency in SQL, Google Cloud Platform technologies, and database architecture is required, along with eligibility for Government of Canada Reliability Status clearance.
Benefits
Full 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 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.
Please submit your application by September 25, 2026.
| 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 hrinfo@payments.ca.
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.
Similar roles
-
Senior Data Engineer R&D 26-27 H/F
MAZARS Levallois-Perret, Ile-de-France, France
-
Data Engineer Intern (Summer 2027)
Lyft Toronto, Ontario, Canada · CA$83K–CA$94K/yr
-
Senior Data Engineer
Prenuvo United States · $90K–$100K/yr
-
Data Engineer
Ford Motor Company Dearborn, Michigan, United States · $115K–$193K/yr
-
Data Engineer, Ground Network Engineering (Gateway)
SpaceX Redmond, Washington, United States · $125K–$200K/yr
-
Senior Data Engineer
Adyen San Francisco, California, United States · $198K–$293K/yr