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 valuable 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.

#J-18808-Ljbffr

📌 Data Engineer (Ontario)
🏢 Payments Canada
📍 Ontario