Senior Data Engineering Consultant

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

Job summary

A technology solutions firm in Toronto is seeking a Senior Data Engineering Consultant to lead Master Data Management projects. The ideal candidate has extensive experience with Informatica MDM, cloud integration, and data pipeline development. This position offers a salary range of $104,000 to $156,000, along with flexible work options and a performance bonus of 15%. The firm promotes a dynamic culture focused on innovation and teamwork.

Benefits

Comprehensive total rewards package

Flexible work arrangements

Career growth opportunities

Generous pension and share purchase programs

Qualifications

• Extensive experience with Informatica Intelligent Data Management Cloud.
• Expertise in configuring data models and match rules.
• Hands-on experience in configuring IDQ rule sets.

Responsibilities

• Develop and maintain the Master Data Management development strategy.
• Design, develop, test, and deploy data pipelines.
• Collaborate with a global technology and business team.

Skills

Informatica Intelligent Data Management Cloud

Data pipeline development

Cloud integration (GCP, AWS, Azure)

ETL processing

SQL queries

Python for data processing

CI/CD implementation

Education

Bachelor’s degree or 5 years of experience in related field

Tools

GitHub Actions

Terraform

Informatica MDM SaaS

Job description

Select how often (in days) to receive an alert:

Jobs by Category: Technology Solutions

Job Function: Data Science

Status: Full Time

Schedule: Regular

Join our team and what we'll accomplish together

The Chief AI Office is on a continuous journey towards helping TELUS Health create healthier communities around the globe, doing so by 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 always keeping an eye on the horizon, 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 working as 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 practice in development, security, accessibility and design to achieve the highest quality of service for our customers.

Join a dynamic team that is paving the way towards digital transformation and enable teams across the organization to make better use of data. Make use of your analytical skills and ability to analyze and assess the impact of data on upstream and downstream systems and help clarify and define cloud-related business processes and best practices across TELUS Health.

What you'll do

At TELUS Health, we put ‘Customers First’. With a broad set of responsibilities and a high degree of visibility across the TELUS Health organization, the successful candidate will have the opportunity to:

• 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,
• 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
• AAbility 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

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 …

A bit about us

We’re a people-focused, customer-first, purpose-driven team who works together every day to innovate and do good. We improve lives through our technology solutions and foster a culture of innovation that empowers team members to solve complex problems and create remarkable human outcomes in a digital world.

You’ll find our engaging, high-performance culture personally fulfilling, professionally challenging, and financially rewarding. We’re committed to diversity and equitable access to employment opportunities based on ability. Your unique contributions and talents will be valued and respected here. 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.

Technology Solutions

We’re into seeing where technology can take us, so if you have ever imagined what the future of supply chain management, cybersecurity, the cloud and Internet of Things will look like, we want you to be part of the team that makes it happen.

We are honoured to be recognized

5G
TELUS’s fastest network. 5G enables a superior experience with fast downloads and richer multimedia applications

6
Innovation centres across Canada that bring our team members together with customers, partners, start ups, universities, hospitals and fellow colleagues to tackle some of the biggest technological hurdles Canada will face in the near future.

Accessibility

TELUS is proud to foster an inclusive culture that embraces diversity. 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.