THE OPPORTUNITY

Manulife is looking for hands -on data engineer to join our dynamic team and play a key role in the implementation, optimization, and maintenance of our Customer Data Platform (CDP). This role is a member of the Global Performance Marketing Shared Services team. The candidate we’re seeking should have a validated foundation in data engineering, ETL processes, and data integration and extract valuable insights from customer data for strategic business decisions.

WHAT WE ARE LOOKING FOR

• Looking for a Data Engineer with a consistent track record of implementing and maintaining data pipelines and ETL processes, with 5 or more years of proven enterprise experience.
• Bachelor’s Degree in Computer Science , Information Technology, or a related field, or equivalent experience. Master’s degree is a plus.
• Prior experience in working on a Customer Data Platform implementation is a plus.
• Familiarity with XDM (Experience Data Model) concepts is a plus.
• Proficiency in programming languages such as Python, Java, or Scala for data manipulation and transformation.
• Hands-on experience with ETL tools, data integration platforms, and data warehousing concepts.
• Familiarity with cloud platforms (e.g., Azure, Amazon, GCP) and their associated data services.
• Detailed understanding of data privacy and compliance regulations and standard methodologies.
• Excellent problem-solving skills and the ability to fix technical issues efficiently.
• Effective communication skills to collaborate with technical and non-technical partners and team members.
• Diligent approach with a dedication to delivering high-quality work in a fast-paced environment.

• Design, develop, and handle end-to-end data pipelines that facilitate the flawless extraction, transformation, and loading of data from diverse sources into the CDP.
• Design testing plans, develop and implement data quality checks, validation rules, and monitoring mechanisms to maintain data accuracy and integrity within the CDP.
• Develop and maintain detailed documentation for data pipelines, processes, and configurations to support easy understanding and smooth onboarding.
• Implement data cleansing, enrichment, and transformation processes to ensure high-quality data is available for analysis and reporting.
• Continuously improve and optimize ETL processes to enhance data flow efficiency, minimize latency, and support real-time and batch processing requirements.
• Monitor data pipeline performance and solve issues to ensure efficient data flow, and proactively find opportunities for improvement.
• Ensure alignment with data privacy and compliance standards provided by internal compliance teams throughout the data lifecycle within the CDP.
• Collaborate with data analysts, business collaborators, and data scientists to comprehend data needs and transform them into efficient data engineering solutions.
• Work closely with business leads and data architects to design, implement and lead end-to-end CDP architecture based on business requirements.
• Collaborate with the technical lead/architect to identify and implement enhancements to the CDP infrastructure, integrations, and functionalities.
• Work closely with teams from different functions to create XDM schemas for data from diverse source systems, including Azure data lake, CRM, marketing platforms, and transactional databases, to ensure accuracy and reliability.