Data Engineer

As a Data Engineer at Manulife, you will play a critical role in the development and maintenance of the companys data systems and architecture. You will collaborate with other highly skilled data engineers, data architects and governance team in designing, developing, and deploying data pipelines, ETL processes, and other data integration solutions to extract, transform, and load data from various sources into Manulifes data warehouse.

This Data Engineer role is essential for driving efficiency and innovation within our organization. By developing and maintaining automation, this position helps streamline operations and improve efficiency, contributing to our mission of delivering high-quality products and platform services. This role is integral to our goal of continuous improvement and operational excellence.

Position Responsibilities:

• Design, develop, and maintain scalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, and other relevant services
• Develop and maintain the companys data architecture, including data models, schemas, and data dictionaries.
• Integrate data from various sources, ensuring data quality and consistency, and prepare it for analytical and operational use
• Follow consistency of data governance policies and processes to ensure data security, privacy, and compliance.
• Collaborate with other data professionals, including data scientists, analysts, and business team members, to understand data requirements and develop solutions to meet those needs.
• Stay up to date with the latest tools and technologies and see opportunities to enhance Manulifes data infrastructure.
• Ability to learn and implement best practices of big data and cloud computing to ensure solutions are scalable, efficient, and effective.

Required Qualifications:

• 4 or more years of relevant industry experience as Data Engineer
• Experience in building and operationalizing Data pipelines in cloud MS Azure using Azure Data Factory, Azure Databricks.
• Experience in automating data pipelines and familiarity with DevOps and CICD pipelines
• Good working knowledge on MS azure services (SQL Queries, ADLS gen 2, ADF, Databricks, Synapse, SQL Server) to design a data ecosystem.
• Good knowledge of data warehousing concepts and relational data modelling
• Familiarity with programming in both compile languages (Java, Scala) and scripting languages (Python, SQL, R)
• Understanding of Agile scrum methodologies and experience of working in an Agile team, with exposure to and working understanding of collaboration tools like Teams, JIRA, Mural
• Experience in Data processing, performance analysis, tuning and capacity planning
• Amenable to work on a hybrid set-up (3x onsite per week)
• Amenable to work on a night shift schedule (with flexibility for mid shift depending on business need)

Preferred Qualifications:

• Excellent communication and interpersonal skills
• Excellent analytical, problem solving and solutioning skills
• A capacity for constant learning from both success and failure, remaining open to change and continuous improvement
• Familiarity with production release and operational support model

When you join our team:

• We’ll empower you to learn and grow the career you want.
• We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.
• As part of our distributed team, we’ll support you in crafting the future you want to see!