Senior Data Engineering Consultant

The Chief AI Office is on a continuous journey towards helping TELUS Health create healthier communities around the globe, delivering data analytics capabilities built upon unified scalable platforms, advanced AI tooling, high quality data, and a data-product and data platform oriented culture while preparing for the next big thing.

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 part of a friendly, cross-discipline agile team who helps each other solve problems across all functions. As a custodian of customer trust, you will employ best practices in development, security, accessibility and design to achieve the highest quality of service for our customers.

• 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, ensuring the master data platform is scalable and integrated within the organizational ecosystem
• Identify opportunities for and implement automation in the development and production process to reduce manual work
• Participate in requirements review sessions or intake assessment meetings to estimate effort for high-level solutions
• Provide guidance on enterprise data and architecture choices across solutions and processes
• Identify potential risks and vulnerabilities within existing architectures; develop mitigation strategies and contingency plans
• Mentor others in translating technical concepts into business implications
• Develop and evaluate KPIs and metrics for master data initiatives, tracking progress and identifying optimization opportunities

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

• Master level or equivalent
• 8+ years of relevant experience with Informatica MDM SaaS and GCP
• AI/Machine learning and data science knowledge
• Experience in healthcare data and technology domain (payors, providers, employers)
• API development using Node.js and testing using Postman/SoapUI