Data Engineer

The Group Benefits Product Data Analytics team is a diverse team that is responsible for providing accurate data, visualization, and prescriptive analytics across the Group Benefits organization and our customers.

The Data Engineer will play a key role by building certified data pipelines and views to be consumed by other business areas and visualization layers and will encompass an end-to-end view from data sourcing, lineage, quality, transformation, and storage.

Responsibilities:

• Engage with business partners to comprehend their data, metrics, and insights needs.

• Locating the data required to fulfill the data needs - be it in systems of origin or systems of reference (such as the GB Data Lake)

• Develop business use cases, translation of business problem/requirements into analytics tasks and work on development of conceptual prototypes and mock-ups of analytics solutions.

• Ability to interact with business on explaining analytics solution and communicating analytics insights.

• Implement Development and Integration activities (planning, implementation, testing, deployment, and post implementation support) of existing and new data and visualization technologies.

• Continue to improve and advance our team's current data & reporting platform.

• Build container-based solutions, pipelines, APIs and analytics portal for heterogeneous data sources on internal data lakes or cloud platforms and prepare data to be used for diagnostic/descriptive reporting and data work.

• Collaborate with Process Engineers and Business Stakeholders to develop data pipelines and assist with prescriptive analytics through consolidated data.

• Identify and resolve data movement/transformation/processing bottlenecks.

• Stay updated on emerging Data and Visualization technologies trends/standard processes and propose solutions for Technology and Business partners.

• Collaborate with collaborators and analysts to detail and validate data sources to expand existing data marts and warehouses.

• Build, test, and maintain data pipelines with focus in continuous integration and fault tolerant ETL processes.

• Maintain/improve our PowerBI / SSAS datasets and SSRS/SSIS Solutions.

What we are looking for?

• Bachelor’s or Master’s degree in computer science or related technical programs.

• 5+ years of data engineering experience in related industry working with enterprise data.

• 5+ years of advanced SQL knowledge and experience working with relational databases.

• 5+ years of experience in design, testing and implementing ETLs and building data pipelines, harmonizing raw data into a consumer-friendly format using Azure stack and Azure Databricks.

• Advance knowledge of data visualization tools such as Tableau, QlikView, PowerBI

• Experience building data ingestion pipelines using Azure Data Factory to ingest structured and unstructured data.

• Proven experience on data processing by using SQL, Pyspark, Python or similar open source and commercial technologies.

• Proficiency in data processing frameworks and techniques such as Azure, Hortonworks, Spark, Hive.

• Experience with Cloud technologies: OpenShift, Docker, Kubernetes and knowledge of AWS, GCP, Azure and Sagemaker, and security considerations for cloud.

What motivates you?

• You obsess about customers, listen, engage and act for their benefit.

• You think big, with curiosity to discover ways to use your agile approach and enable business outcomes.

• You thrive in teams and enjoy getting things done together.

• You take ownership and build solutions, focusing on what matters.

• You do what is right, work with integrity and speak up.

• You share your humanity, helping us build a diverse and inclusive work environment for everyone.

What can we offer you?

• A competitive salary and benefits packages.

• A growth trajectory that extends upward and outward, encouraging you to follow your passions and learn new skills.

• A focus on growing your career path with us.

• Flexible work policies and strong work-life balance.

• Professional development and leadership opportunities.

Our commitment to you

Values-first culture: We lead with our Values every day and bring them to life together.

Boundless opportunity: We create opportunities to learn and grow at every stage of your career.

Continuous innovation: We invite you to help redefine the future of financial services.

Delivering the promise of Diversity, Equity and Inclusion:  We foster an inclusive workplace where everyone thrives.

Championing Corporate Citizenship: We build a business that benefits all partners and has a positive social and environmental impact.

About Manulife and John Hancock

Manulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit https://www.manulife.com/en/about/our-story.html.

Manulife is an Equal Opportunity Employer

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 [email protected].

Toronto, Ontario

Hybrid

Salary range is expected to be between

$75,880.00 CAD - $140,920.00 CAD

If you are applying for this role outside of the primary location, please contact [email protected] for the salary range for your location. The actual salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. Employees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance.

Manulife offers eligible employees a wide array of customizable benefits, including health, dental, mental health, vision, short- and long-term disability, life and AD&D insurance coverage, adoption/surrogacy and wellness benefits, and employee/family assistance plans. We also offer eligible employees various retirement savings plans (including pension and a global share ownership plan with employer matching contributions) and financial education and counseling resources. Our generous paid time off program in Canada includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for this role in the U.S., please contact [email protected] for more information about U.S.-specific paid time off provisions.