Senior Data Engineer

Ottawa, ON +1

| About the role

Reporting to the Manager, Information, Data and Analytics, the Senior Data Engineer will work with the team on establishing and maturing the business intelligence end to end process. They will develop, manage and maintain the extraction, translation and loading of Payments Canada data to a data warehouse environment, and craft and execute queries for data and present the information through reports and visualization.


|What you’ll be doing

  • Designing, building, and maintaining data pipelines by building and maintaining ETL code/scripts;
  • Performing data analysis and develop source to target mapping models;
  • Reviewing the current data storage and data models, creating tools to store data;
  • Interfacing with all internal/external customers to gather requirements that will be used for the ETL process;
  • Collaborating with other teams to integrate systems;
  • Developing and executing database queries and conducting analyses for the BI solution;
  • Creating visualization template and reports;
  • Developing and maintaining relevant technical documentation.

|You’ll need to have

  • Minimum of 5 years of experience working with data, with a focus on developing enterprise BI solution;
  • Minimum of 5 years of experience in translating data between multiple formats using scripting language and ETL tools;
  • Experience in designing the implementing a robust ETL pipeline;
  • Experience in working with relational databases and SQL;
  • Experience in developing or working with Data Warehouse;
  • Experience in scripting language (JavaScript, Python, DOS BAT, Shell);
  • Experience working in a cloud environment such as GCP;

|It would be great if you had

  • Experience with data mining techniques and statistical analysis;
  • SQL, Oracle, Google certification;
  • Experience with BigQuery, Google Data Studio, and other Google tools;
  • Experience with Pentaho Data Integration and related tooling.

| What we can offer you

  • Competitive compensation package;
  • Health and dental benefits;
  • Defined contribution pension plan;
  • Flexible work arrangements;
  • Professional development opportunities;
  • Prime downtown locations (Ottawa & Toronto) close to transit and shopping;
  • Gym and shower facilities;
  • Bike lockers.

| About us


We are a unique organization at the centre of the payments ecosystem and Canadian economy. We are responsible for balancing and leading in an environment of multiple interests, ideas and challenges. We successfully navigate these challenges by adhering to a set of values that in themselves are tensions: Think Big + Act Responsibly, Be Ambitious + Raise the Team, Keep Momentum + Be Rigorous. We are successful as individuals, as teams, as an organization and for our members and stakeholders if we strike to balance these values in all that we do.


Payments Canada is committed to having a diverse, representative workforce and continuing to build an inclusive environment. We encourage applications from qualified women, men, visible minorities, aboriginal peoples, and persons with disabilities. All employment decisions are made based on business needs, job requirements, and individual qualifications.


We are committed to developing inclusive, barrier-free recruitment and selection processes, and a work environment that supports our diverse workforce. Please let us know if you require accommodations at any stage of the recruitment process. We can be reached at

Other details

  • Pay Type Salary Min Hiring Rate $86,064.00 Max Hiring Rate $114,751.00 

Subscribe to Job Alerts