Senior Data Engineering Consultant

Intello Technologies Inc.; Toronto; Hybrid; CAD 104,000 - 156,000; Full time

Job summary

A technology consulting firm based in Ontario is searching for a Senior Data Engineering Consultant to lead MDM projects. The successful candidate will have expertise in Informatica MDM SaaS and a strong background in data engineering, designing data pipelines, and ensuring data quality. Responsibilities include developing strategies for MDM, collaborating with global teams, and implementing automation. This role offers a competitive salary and flexible working arrangements, along with comprehensive benefits.

Benefits

Minimum 3 weeks of vacation

Company-matched pension plan

Career growth opportunities

Qualifications

• 5+ years of experience with MDM concepts and best practices.
• Hands-on experience in configuring data models and validation.
• Strong skills in ETL processing and complex SQL queries.

Responsibilities

• Lead the design and implementation of MDM projects.
• Develop batch and real-time data pipelines.
• Collaborate with global teams for data integration.

Skills

Informatica MDM SaaS

Data engineering

SQL

Python

CI/CD

Education

Bachelor’s degree or equivalent experience

Tools

Informatica Intelligent Data Management Cloud

Google Cloud Platform

ETL tools

Terraform

Job description

As a Senior Data Engineering Consultant, you will lead the design, development, implementation and support of Master Data Management (MDM) projects. The ideal candidate will have extensive experience with Informatica MDM SaaS with proficiency in configuring MDM tools and integrating them with cloud environments. You will utilize your expertise in data engineering to design, build and maintain data pipelines, optimize performance, and ensure data quality. You will be working as part of a friendly, cross‑disciplinary agile team who helps each other solve problems across all functions. As a custodian of customer trust, you will employ best practice in development, security, accessibility and design to achieve the highest quality of service for our customers.

What you'll do

• Develop and maintain the Master Data Management development strategy in line with business objectives and enterprise architecture standards
• Design, develop, test, deploy, maintain and improve batch and real‑time data pipelines for MDM systems and data projects
• Collaborate extensively with a global technology and business team, fostering seamless integration of the master data platform within the organizational ecosystem, ensuring its scalability and efficiency
• Identify opportunities for and implement automation in the development and production process to reduce upfront hands‑on work
• Participate in requirements review sessions or attend intake assessment meetings to estimate effort for high‑level solutions
• Provide guidance on enterprise data and architecture choices across our solutions and processes
• Identify potential risks and vulnerabilities within existing architectures. Develop mitigation strategies and contingency plans to address these risks and ensure business continuity
• Be a senior strategist and mentor who is sought out when it comes to analyzing and translating technicalities into business implications
• Develop and evaluate key performance indicators (KPIs) and metrics, assessing the effectiveness of master data initiatives, tracking progress, and identifying optimization opportunities

What you bring

• Bachelor’s degree or 5 years of experience in related field
• Extensive experience with Informatica Intelligent Data Management Cloud and comprehensive understanding of MDM concepts and industry best practices
• Expertise in configuring data models, match and merge rules, trust and validation
• Hands‑on experience in configuring IDQ rule sets, including data cleansing, parsing, standardization, validation, and DQ exception monitoring/handling
• Proficiency in integrating MDM with external tools such as cloud environments (GCP, AWS, Azure) and/or ERP and CRM systems (SFDC, Workday, D365)
• Experience with the Google Cloud Platform (GCP) and its related technologies (CloudSQL, PubSub, GCS, Logging, Analytics Hub)
• Strong skills in ETL processing, validation and complex SQL query writing and Python for data processing and automation
• Capability to perform design and code reviews, and experience in preparing technical design documents and test plans
• Experience with CI/CD implementation, GitHub Actions/Workflows and managing IaC using Terraform/Pulumi
• Ability to work independently and in a team environment

Great‑to‑haves

• 8+ years of progressive and relevant work experience with Informatica MDM SaaS and GCP
• AI/Machine learning and data science knowledge
• Experience in the healthcare data and technology domain, specifically around supporting Private & Public Payors, Providers and Employer‑based programs
• API development using Node.js and testing using Postman/SoapUI

Compensation & Benefits

Salary Range: $104,000 - $156,000

Performance Bonus or Sales Incentive Plan: 15%

Actual total compensation will be determined based on factors such as knowledge, skills, performance and experience. In addition, TELUS offers rewarding benefits such as:

• Comprehensive total rewards package highlighting competitive salary and bonus structures, minimum 3 weeks of vacation, and flexible benefits plan to meet the needs of you and your family
• Flexibility to work in‑office, virtually or a combination of both, based on the role’s requirements
• Generous company‑matched pension and share purchase programs
• Opportunity to give back to communities in which we work, live and serve
• Career growth and learning & development opportunities to develop your skills
• And much more …

EEO & Accessibility

When you join our team, you’re helping us make the future friendly.

Note for Quebec candidates: if knowledge of English is required for this position, it is because the team member will be asked, on a regular basis, to interact in English with external or internal parties or to use English applications or software as part of their tasks.

We are committed to fair employment practices and all qualified applicants will receive consideration for employment.

We offer accommodation for applicants with disabilities, as required, during the recruitment process.