The Opportunity
Manulife is embarking on replacing and building new data capabilities to help fuel our bold ambition to become a digital customer leader. We are seeking a skilled and motivated data engineer to join our dynamic team and play a key role in implementing optimizing and maintaining assets that deliver these capabilities. The ideal candidate possesses a solid background in data engineering ETL processes and data integration with a passion for understanding data to drive strategic business decisions.
Responsibilities
- Data Pipeline Development: Design develop and manage endtoend data pipelines that facilitate the detailed extraction transformation and loading of data from diverse sources.
- Data Mapping & Integration: Collaborate closely with multifunctional teams to understand and design schemas for data from various source systems and other transactional or application databases ensuring accuracy and reliability.
- ETL Optimization: Continuously improve and optimize ETL processes to enhance data flow efficiency minimize latency and support realtime and batch processing requirements.
- Data Transformation: Implement data cleansing enrichment and transformation processes to ensure highquality data is available for analysis and reporting.
- Data Quality Assurance: Design testing plans develop and implement data quality checks validation rules and supervising mechanisms to maintain data accuracy and integrity.
- Platform Enhancement: Collaborate with various technical resources from across the organization to identify and implement enhancements to the infrastructure integrations and functionalities.
- Data Architecture: Work closely with business leads and data architects to design implement and manage endtoend architecture based on business requirements.
- User Documentation: Create and maintain comprehensive documentation for data pipelines processes and configurations to facilitate knowledge sharing and onboarding.
- Collaboration: Partner with other data engineers data analysts business collaborators and data scientists to understand data requirements and translate them into effective data engineering solutions.
- Performance Monitoring: Monitor data pipeline performance and solve issues to ensure optimal data flow and proactively find opportunities for enhancement.
- Data Governance and Compliance: Ensure consistency with data privacy and compliance standards throughout the data lifecycle.
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 we are looking for
- Bachelors Degree in Computer Science Information Technology or a related field. Masters degree is a plus.
- 5 years of experience as a Data Engineer with a track record of efficiently implementing and maintaining data pipelines scheduling monitoring notification and ETL processes using Azure Data Factory Databricks PythonPyspark Java Scala.
- Understanding of Azure infrastructure; subscriptions resource groups resources access control with RBAC (rolebased access control) integrations with Azure AD and Azure security principles (user group service principal managed identity) network concepts (VNet Subnet NSG rules private endpoints) passwordcredentialkey management and data protection.
- Experience deploying and integrating Azure Data Services (Azure Data Factory Databricks) using DevOps tools and principles: GitHub Repository Jenkins CICD pipelines integrated unit tests etc.
- Knowledge of Azure Data Lake Storage (ADLS Gen2 and its topology on blob storage with file hierarchy storage account containers and folders.
- Proficient in data mart fact and dimension design concepts ETLELT logic to perform upsert and type2 and applyingimplementing with pythonpysparkstore procSQL in ADLS (with Lakehouse architecture using Databricks) or in Azure Synapse (with Dedicated SQL pool)
- Experience using Power BI to connect to sources with ADLS (including Delta Lake) Databricks SQL Azure Synapse (SQL pool) design semantic layerdata models createpublish reporting content (data setspaginate reportinteractive dashboard) and manage workspaces.
- Solid understanding of data privacy and compliance regulations and standard methodologies.
- Excellent problemsolving skills and the ability to solve technical issues efficiently.
- Effective communication skills to collaborate with technical and nontechnical partners.
- Thorough approach with a commitment to delivering highquality work in a fastpaced environment.
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 worklife balance.
- Professional development and leadership opportunities.
Our commitment to you
- Valuesfirst 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.
#LIHybrid
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 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 pregnancyrelated 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 .
Waterloo Ontario
Hybrid
Salary range is expected to be between
$75880.00 CAD $140920.00 CAD
If you are applying for this role outside of the primary location please contact for the salary range for your location. The actual salary will vary depending on local market conditions geography and relevant jobrelated 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 longterm 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 for more information about paid time off provisions.