Data engineer

Société Financière Manuvie; Waterloo; Hybrid; CAD 75,000 - 141,000; Full time

Job summary

A leading financial services company is seeking a skilled Data Engineer to join their team. This role involves designing and managing data pipelines, optimizing ETL processes, and ensuring data quality and compliance. The ideal candidate will have a strong background in data engineering and a passion for leveraging data to drive business decisions. The position offers a competitive salary and benefits, along with opportunities for professional growth in a dynamic work environment.

Benefits

Medical Insurance

Dental Insurance

Mental Health Support

Flexible Work Policies

Professional Development Opportunities

Qualifications

• 5+ years of experience as a Data Engineer.
• Proficient in data mart design concepts and ETL/ELT logic.

Responsibilities

• Design, develop, and manage end-to-end data pipelines.
• Collaborate with teams to design schemas for data integration.
• Monitor data pipeline performance and solve issues.

Skills

Data Engineering

ETL Processes

Data Integration

Problem Solving

Communication

Education

Bachelor’s Degree in Computer Science

Master's Degree

Tools

Azure Data Factory

Databricks

Python

SQL

Power BI

Job description

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 end-to-end data pipelines that facilitate the detailed extraction, transformation, and loading of data from diverse sources.
• Data Mapping & Integration: Collaborate closely with multi-functional 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 real-time and batch processing requirements.
• Data Transformation: Implement data cleansing, enrichment, and transformation processes to ensure high-quality 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 end-to-end 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

• Bachelor’s Degree in Computer Science, Information Technology, or a related field. Master's 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, Python\Pyspark, Java, Scala.
• Understanding of Azure infrastructure; subscriptions, resource groups, resources, access control with RBAC (role-based access control), integrations with Azure AD and Azure security principles (user group, service principal, managed identity), network concepts (VNet, Subnet, NSG rules, private endpoints), password\credential\key management and data protection.
• Experience deploying and integrating Azure Data Services (Azure Data Factory, Databricks) using DevOps tools and principles: GitHub Repository, Jenkins CI\CD 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, ETL\ELT logic to perform upsert and type-2, and applying\implementing with python\pyspark\store proc\SQL 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 layer\data models, create\publish reporting content (data sets\paginate report\interactive dashboard), and manage workspaces.
• Solid understanding of data privacy and compliance regulations and standard methodologies.
• Excellent problem-solving skills and the ability to solve technical issues efficiently.
• Effective communication skills to collaborate with technical and non-technical partners.
• Thorough approach with a commitment to delivering high-quality work in a fast-paced 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 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.

#LI-Hybrid

À propos de Manuvie et de John Hancock

La Société Financière Manuvie est un chef de file mondial des services financiers qui aide les gens à prendre leurs décisions plus facilement et à vivre mieux. Pour en apprendre plus à notre sujet, rendez vous à l’adresse www.manuvie.com.

Manuvie est un employeur qui souscrit au principe de l’égalité d’accès à l’emploi

Chez Manulife/John Hancock nous valorisons notre diversité. Nous nous efforçons d’attirer, de perfectionner et de maintenir une main d'oeuvre qui est aussi diversifiée que nos clients, et de favoriser la création d’un milieu de travail inclusif qui met à profit la diversité de nos employés et les compétences de chacun. Nous nous engageons à assurer un recrutement, une fidélisation, une promotion et une rémunération équitables, et nous administrons toutes nos pratiques et tous nos programmes sans discrimination en raison de la race, de l’ascendance, du lieu d’origine, de la couleur, de l’origine ethnique, de la citoyenneté, de la religion ou des croyances ou des convictions religieuses, du genre (y compris grossesse et affection liée à une grossesse), de l’orientation sexuelle, des caractéristiques génétiques, du statut d’ancien combattant, de l’identité de genre, de l’expression de genre, de l’âge, de l’état matrimonial, de la situation de famille, d’une invalidité ou de tout autre motif protégé par la loi applicable.

Nous nous sommes donné comme priorité d’éliminer les obstacles à l’accès égalitaire à l’emploi. C’est pourquoi un représentant des Ressources humaines collaborera avec les candidats qui demandent accommodement raisonnable pendant le recrutement. Tous les renseignements communiqués pendant le processus de demande d'accommodement seront stockés et utilisés conformément aux lois et aux politiques applicables de Manuvie. Pour demander une mesure d’accommodement raisonnable dans le cadre du recrutement, écrivez à [e-mail].

Région de référence du salaire

Waterloo, Ontario

Modalités de travail

Hybride

L’échelle salariale devrait se situer entre

$75,880.00 CAD - $140,920.00 CAD

Si vous posez votre candidature à ce poste en dehors de la région principale, veuillez écrire à [e-mail] pour obtenir l’échelle salariale correspondant à votre région. Le salaire varie en fonction des conditions du marché local, de la géographie et de facteurs pertinents liés au poste telles les connaissances, les compétences, les qualifications, l’expérience et l’éducation ou la formation. Les employés ont également la possibilité de participer à des programmes de motivation et de toucher une rémunération incitative liée au rendement de l’entreprise et au rendement individuel.

Manuvie offre aux employés admissibles une vaste gamme d’avantages sociaux personnalisables, notamment une assurance soins médicaux, soins dentaires, santé mentale, soins de la vue, invalidité de courte et de longue durée, assurance vie et assurance DMA, assurance adoption, de maternité de substitution et de soins médicaux non urgents ainsi que des programmes d’aide aux employés et leur famille. Nous proposons également aux employés admissibles différents régimes d’épargne-retraite (y compris des régimes de rente et un programme international d’actionnariat assortie de cotisations patronales de contrepartie) ainsi que des ressources en matière d’éducation et de conseils financiers. Notre généreux programme de congés rémunérés au Canada comprend les jours fériés, les congés annuels, les congés personnels et les congés de maladie, et nous offrons toute la gamme des congés autorisés prévus par la loi. Si vous posez votre candidature à ce poste aux États-Unis, veuillez écrire à [e-mail] pour obtenir de plus amples renseignements sur les dispositions relatives aux congés rémunérés spécifiques aux États-Unis.