3 days ago
Toronto, Canada or Waterloo, CanadaMid Level
Responsibilities
- Analyze legacy data structures, relationships, transformations, and business rules across source and downstream systems.
- Design and develop ETL/ELT pipelines using Informatica, Azure Data Factory, SQL, or Databricks.
- Support data conversion and migration into the target compensation platform and Data Lake.
- Perform source-to-target mapping, profiling, cleansing, transformation, validation, and reconciliation.
- Design and maintain 3NF, dimensional, and analytical data models.
- Build automated extracts, interfaces, and feeds for Finance, Distribution, Operations, Treasury, and other consumers.
- Develop operational, reconciliation, and analytical reports using Power BI, Tableau, Cognos, SSRS, Crystal Reports, or similar tools.
- Implement automated controls for record counts, financial totals, balances, results, and source-to-target completeness.
- Investigate data issues and support root-cause analysis and remediation across source, transformation, target, and downstream systems.
- Build and maintain scheduling, monitoring, alerting, restart, and exception-handling capabilities for production pipelines.
- Maintain data lineage, mappings, transformation rules, technical specifications, and reconciliation evidence.
- Contribute to migration planning, test-data preparation, conversion rehearsals, parallel validation, cutover, and post-production stabilization.
- Partner with business analysts, engineers, architects, Operations, and business teams to translate legacy requirements into future-state solutions.
Requirements
- Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field, or equivalent professional experience.
- At least 4 years of experience in data engineering, ETL development, data migration, or cloud data engineering.
- Advanced SQL skills and experience analyzing and transforming large, complex datasets.
- Hands-on experience with Informatica, Azure Data Factory, Databricks, or comparable ETL/ELT platforms.
- Knowledge of data warehousing, 3NF, Medallion Architecture, dimensional modeling, and enterprise data-model design.
- Experience with large-scale data migration or system-conversion initiatives, including mapping, profiling, transformation, validation, and reconciliation.
- Experience building automated extracts and file-based integrations using formats such as CSV, TSV, XML, and JSON.
- Experience delivering data through SFTP, Managed File Transfer, APIs, or enterprise integration frameworks.
- Experience implementing data-quality controls, financial reconciliation, exception handling, data governance, and auditability.
- Experience developing operational or analytical reporting with Power BI, Tableau, SSRS, Crystal Reports, or similar technologies.
- Experience with scheduling and orchestration technologies such as Azure Data Factory, CA WLA, or MuleSoft.
- Strong analytical, troubleshooting, communication, and cross-functional collaboration skills.
- Preferred experience with legacy modernization, complex data-conversion programs, Azure Databricks, Synapse, Spark, Python, Git, CI/CD pipelines, automated deployment, and DevOps practices.
- Preferred familiarity with REST APIs, API gateways, Kafka, Azure Event Hubs, event-driven integration patterns, insurance or financial services, producer compensation, distribution technology, AI, Business Intelligence, or Generative AI solutions.
Benefits
- Hybrid working arrangement in Toronto, Ontario.
- Flexible environment supporting learning, career growth, well-being, and inclusion.
- Eligible employees may receive health, dental, mental health, vision, disability, life, AD&D, adoption/surrogacy, wellness, and employee/family assistance benefits.
- Eligible employees may participate in retirement savings plans, including pension and a global share ownership plan with employer matching contributions.
- Financial education and counseling resources are available.
- Paid holidays, vacation, personal and sick days, and statutory leaves are provided in Canada.
- Employees may participate in incentive programs tied to business and individual performance.
Tech Stack
Categories
Data Engineering
About Manulife
Manulife is a Toronto‑headquartered public financial services company that provides life and health insurance, retirement plans, and wealth and asset management to individuals and institutions. It earns premiums and fee income from insurance, investment, and advisory products delivered across Canada, Asia, and Europe, and operates as John Hancock in the United States. Founded in 1887, the company is listed on the Toronto Stock Exchange.