Data Engineer

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.