About the Role
As a Data Engineer at Manulife, you will play a critical role in developing and maintaining the company's data systems and architecture. You will collaborate with other data professionals in designing, developing, and deploying data pipelines and ETL processes. This role is essential for driving efficiency and innovation by developing and maintaining automation to streamline operations and improve efficiency.
Responsibilities
- Design, develop, and maintain scalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, and other relevant services.
- Develop and maintain the company's 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 to understand data requirements and develop solutions.
- Stay up to date with the latest tools and technologies and see opportunities to enhance Manulife's data infrastructure.
- Learn and implement best practices of big data and cloud computing to ensure solutions are scalable, efficient, and effective.
Requirements
- 4 or more years of relevant industry experience as a Data Engineer.
- Experience building and operationalizing data pipelines in Microsoft Azure using Azure Data Factory and Azure Databricks.
- Experience implementing and supporting data governance solutions using Databricks Unity Catalog.
- Experience automating data pipelines and familiarity with DevOps and CI/CD pipelines.
- Strong knowledge of Microsoft Azure services (SQL, ADLS Gen2, ADF, Databricks, Synapse, SQL Server) and designing scalable data ecosystems.
- Strong understanding of data warehousing concepts and relational data modeling.
- Experience with programming languages such as Python, SQL, Java, and/or Scala.
- Understanding of Agile Scrum methodologies and experience working within Agile teams.
- Experience in data processing, performance tuning, monitoring, and capacity planning.
Skills
- Azure Data Factory
- Azure Databricks
- Databricks Unity Catalog
- DevOps
- CI/CD pipelines
- Microsoft Azure services
- SQL
- ADLS Gen2
- Synapse
- SQL Server
- Python
- Java
- Scala
- Agile Scrum
Location
- Waterloo, Ontario
Work Type
- Hybrid
Experience Level
- 4 or more years of relevant industry experience
Salary/Compensations
- $86,100.00 CAD - $136,100.00 CAD
Benefits
- Opportunity to participate in incentive programs and earn incentive compensation.
- Health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage.
- Adoption/surrogacy and wellness benefits.
- Employee/family assistance plans.
- Retirement savings plans (including pension and a global share ownership plan with employer matching contributions).
- Financial education and counseling resources.
- Holidays, vacation, personal, and sick days.
- Full range of statutory leaves of absence.
About the Company
- Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better.
- Visit https://www.manulife.com/en/about/our-story.html to learn more.
Equal Opportunity
- At Manulife/John Hancock, we embrace our diversity. We strive to attract, develop and retain a workforce that is as diverse as the customers we serve and to foster an inclusive work environment that embraces the strength of cultures and individuals.
- We are committed to fair recruitment, retention, advancement and compensation, and we administer all of our practices and programs without discrimination on the basis of race, ancestry, place of origin, colour, ethnic origin, citizenship, religion or religious beliefs, creed, sex (including pregnancy and pregnancy-related conditions), sexual orientation, genetic characteristics, veteran status, gender identity, gender expression, age, marital status, family status, disability, or any other ground protected by applicable law.
- It is our priority to remove barriers to provide equal access to employment.
- A Human Resources representative will work with applicants who request a reasonable accommodation during the application process.
- All information shared during the accommodation request process will be stored and used in a manner that is consistent with applicable laws and Manulife/John Hancock policies.
- To request a reasonable accommodation in the application process, contact hr@manulife.com.
