Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Full Stack Data Engineer

$86.1k - $136.1k

John Hancock

Manulife / John Hancock is seeking a highly skilled Full-Stack Data Engineer, Modernization & Migration to join our Insurance Licensing & Compensation Engineering team.The successful candidate will play a key role in themigration of legacy licensing & compensation capabilities to vendor Platform & Data Lake. This role will focus on analyzing and transforming complex legacy data, building scalable ETL/ELT pipelines, supporting data conversion and reconciliation, and developing the reports, extracts, and downstream feeds required to enable the future-state platform.The ideal candidate combines strong SQL, Informatica/ADF/Data Bricks, data warehousing, data modeling, ETL, reporting, and data analysis skills with the ability to understand complex business rules and data relationships across legacy and modern platforms.Position Responsibilities:Analyze data structures, relationships, transformations, and business rules across multiple legacy systems, and related upstream and downstream platforms.Design and develop ETL/ELT pipelines using Informatica, Azure Data Factory (ADF), SQL, or Databricks to support data conversion, integration, and downstream delivery.Support the migration and conversion of data into the target compensation platform and the Data Lake.Perform source-to-target mapping, data profiling, cleansing, transformation, validation, and reconciliation throughout the migration lifecycle.Design and maintain 3NF, dimensional, and analytical data models supporting business processing, reporting, reconciliation, and downstream consumption.Build automated data extracts, interfaces, and feeds for Finance, Distribution, Operations, Treasury, and other enterprise consumers.Develop operational, reconciliation, and analytical reporting using tools such as Power BI, Tableau, Cognos, SSRS, or Crystal Reports.Develop automated controls to validate record counts, financial totals, balances, results, and source-to-target completeness.Partner with business analysts, engineers, architects, and Operations to translate legacy data structures and processing requirements into future-state solutions.Investigate complex data issues across source systems, transformation layers, target vendor platform, and downstream consumers and support root-cause analysis and remediation.Build and maintain scheduling, monitoring, alerting, restart, and exception-handling capabilities for production data pipelines.Maintain clear data lineage, mappings, transformation rules, technical specifications, and reconciliation evidence to support auditability and production readiness.Contribute to migration planning, test-data preparation, conversion rehearsals, parallel validation, cutover, and post-production stabilization.Required Qualifications:Bachelor’s degree in Computer Science, Software Engineering, Data Engineering, or a related field, or equivalent professional experience.4+ years of experience in data engineering, ETL development, data migration, Cloud data engineering.Advanced SQL skills with experience analyzing and transforming large and complex datasets.Strong hands-on experience with Informatica, Azure Data Factory (ADF), Data Bricks or comparable ETL/ELT platforms.Strong working knowledge of data warehousing, 3NF, Medallion Architecture, dimensional modeling, and enterprise data-model design.Work experience with large-scale data migration or system-conversion initiatives, including source-to-target mapping, profiling, transformation, validation, and reconciliation.Experience building automated extracts and file-based integrations, including CSV, TSV, XML, JSON, or similar formats.Experience delivering data through SFTP, Managed File Transfer (MFT), APIs, or enterprise integration frameworks.Strong experience implementing data-quality controls, financial reconciliation, exception handling, data governance and auditability.Practical experience developing operational or analytical reporting using Power BI, Tableau, SSRS, Crystal Reports, or similar technologies.Experience with scheduling and orchestration technologies such as ADF, CA WLA or MuleSoft.Strong analytical and troubleshooting skills with the ability to reverse-engineer complex legacy data structures and transformation logic.Strong communication skills with the ability to work across engineering, architecture, operations, and business teams.Preferred Qualifications:Experience with legacy-system modernization and complex data-conversion programs.Exposure to Azure Databricks, Synapse, Spark, Python or other modern cloud/data platforms.Experience with Git, CI/CD pipelines, automated deployment, and DevOps practices for data engineering workloads.Familiarity with REST APIs, API gateways, Kafka, Azure Event Hubs, or event-driven integration patterns.Background in insurance, financial services, producer compensation, or distribution technology would be a strong asset.Strong communication, analytical, problem-solving skills.Experience with AI, Business Intelligence (BI), and/or Generative AI solutions.When you join our team:We’ll empower you to learn and grow the career you want.We’ll recognize and support you in a flexible environment where well-being and inclusion are more than just words.As part of our global team, we’ll support you in shaping the future you want to see.#LI-HybridThe role being advertised is an existing vacancy.About Manulife and John HancockManulife Financial Corporation is a leading international financial services provider, helping people make their decisions easier and lives better. To learn more about us, visit .Manulife is an Equal Opportunity EmployerAt 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 View email address on click.appcast.io Salary LocationToronto, OntarioWorking ArrangementHybridBase salary range is expected to be between$86,100.00 CAD - $136,100.00 CADEmployees also have the opportunity to participate in incentive programs and earn incentive compensation tied to business and individual performance. The actual base salary will vary depending on local market conditions, geography and relevant job-related factors such as knowledge, skills, qualifications, experience, and education/training. If you are applying for this role outside of the primary location, please contact View email address on click.appcast.io for the salary range for your location.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 View email address on click.appcast.io for more information about U.S.-specific paid time off provisions.We use data and analytics technologies, such as artificial intelligence (AI), and automated processing tools, to analyze and process the information you provide to us or third parties in the application process. For more information, please refer to our personal information collection statement.SummaryLocation: Toronto, Ontario; Waterloo, OntarioType: Full time

Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Full Stack Data Engineer in Waterloo, IL vacancy
  • $96.6k - $179.4k

     ...you looking to be part of an Engineering-First culture? Do you want to...  ...applications. Work with the latest tech stack including .NET, React, Java,...  ...use tools, APIs, enterprise data, or retrieval-augmented...  ...) each year, and we offer the full range of statutory leaves of absence... 
    Suggested
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    1 day ago
  • $113k - $163k

    As a Senior Full Stack Engineer, you will help shape solutions, advance strategic initiatives, strengthen our technology footprint and champion...  ..., CSS, Tailwind or SCSS, and React state management and data fetching. Integration and APIs: Microservices, REST APIs, OpenAPI... 
    Suggested
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    1 day ago
  • $86.1k - $136.1k

    As a Full Stack Engineer, you will build and maintain applications that customers and advisors rely on. Working alongside an experienced team,...  ...component or design libraries, and React state management and data fetching.Integration and APIs: REST APIs, OpenAPI and a... 
    Suggested
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    1 day ago
  • $113k - $163k

     ...isn’t an add‑on — it’s the foundation.We are seeking a Senior Full‑Stack AI Engineer to help shape how modern AI‑driven software is built,...  ...information about U.S.-specific paid time off provisions.We use data and analytics technologies, such as artificial intelligence... 
    Suggested
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    3 days ago
  • $113k - $163k

    As a Senior AI Engineer, you will be responsible for Full-Stack Software Development i.e.building modern, cloud-based, and AI-enabled applications that help...  ...guardrails, and human-in-the-loop workflows for text-heavy and data-intensive enterprise use cases.Full-Stack Engineering... 
    Suggested
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    13 hours ago
  • $86.1k - $136.1k

     ...applications as a member of a team, working across Full-Stack through the entire software development...  ...:5+ years Full Stack Software Engineer experienceSolid hands-on experience in React...  ...paid time off provisions.We use data and analytics technologies, such as artificial... 
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    3 days ago
  • $113.26k - $210.34k

    As a Lead Full Stack Engineer, you will shape the technical direction for your area, lead complex engineering programs across multiple teams,...  ...SQL. Back-end frameworks: Spring Boot, Spring Security, Spring Data JPA/Hibernate, and NestJS or Express.js. Front-end... 
    Full time
    Temporary work
    Local area
    Immediate start
    Flexible hours

    John Hancock

    Waterloo, IL
    1 day ago
  • $86.1k - $136.1k

    Full Stack Software EngineerBuild technology that makes a difference.Manulife is a leading...  ...meaningful digital experiences, solve complex engineering challenges, and work alongside talented...  ...paid time off provisions.We use data and analytics technologies, such as artificial... 
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    3 days ago
  •  ...OntarioOnsiteFull Time$140k - $165kLocated in Waterloo, this full-time Senior Data Scientist opportunity is with an innovative technology...  ...Breakdown75% Python/Machine Learning/Statistical Modeling 25% Data Engineering, MLOps, and Production SupportDaily Responsibilities80%... 
    Full time

    Motion Recruitment

    Waterloo, IL
    3 days ago
  •  ...focused on strengthening the security of Client data. Sun Life’s Information Security organization is enhancing its data engineering, platform, analytics, and insights...  ...ServicesPosting End Date:03/11/2026SummaryLocation: Toronto, Ontario; Waterloo, OntarioType: Full time
    Full time
    Work at office
    Work from home

    Sun Life Financial

    Waterloo, IL
    3 days ago
  • $73.73k - $122.88k

     ...includes holidays, vacation, personal, and sick days, and we offer the full range of statutory leaves of absence. If you are applying for...  ...information about U.S.-specific paid time off provisions. We use data and analytics technologies, such as artificial intelligence (AI),... 
    Full time
    Temporary work
    Local area
    Flexible hours

    John Hancock

    Waterloo, IL
    5 days ago
  • $107.9k - $195.05k

     ...design and deliver modern user interfaces that enable mission users to interact with sophisticated systems and data more effectively. As a Sr. UI/IX Engineer, you will play a critical role at the intersection of user experience, interface engineering, design, and... 
    Contract work
    Local area
    Immediate start

    Leidos

    Columbia, IL
    5 days ago
  • $110.96k - $160.96k

     ....Your Impact:As a Senior AI Developer, you will bring software engineering experience and a working knowledge of AI to OpenText products....  ...or abandon.Thinking across system boundaries. You consider how data, models, application services and users interact, and recognize... 
    Local area

    OpenText

    Waterloo, IL
    4 days ago
  •  ...world.Job Description:The Director of AI Engineering, Corporate IT leads the engineering of artificial...  ...collaboration platforms and enterprise data services.· Govern build-versus-buy...  ...End Date:19/11/2026SummaryLocation: Toronto, Ontario; Waterloo, OntarioType: Full time
    Full time
    Work experience placement
    Work at office
    Flexible hours

    Sun Life Financial

    Waterloo, IL
    4 days ago
  •  ...insights, and unlock greater value from their enterprise content and data.Your ImpactWe are seeking a visionary and technically strong...  ...successful execution through thoughtful planning, strong engineering practices, and effective collaboration.As a hands-on technical... 
    Work at office

    OpenText

    Waterloo, IL
    1 day ago
  •  ...appropriate, and continuously improves engineering practices.Your Impact:We are seeking a highly...  ...the role offers:As a Lead UX Focused, Full Stack Developer, you will:Possess 6-10 years...  ...development, privacy, accessibility, and data-handling standards throughout the... 

    OpenText

    Waterloo, IL
    3 days ago
  •  ...Fullstack), you will independently deliver full-stack and platform capabilities for OpenText's...  ...appropriate, and continuously improves engineering practices.What the role offers:Design,...  ...development, privacy, accessibility, and data-handling standards throughout the... 

    OpenText

    Waterloo, IL
    1 day ago
  •  ...technical leadership and mentorship to junior and intermediate engineers, including code reviews, troubleshooting assistance, solution design...  ...Job Category:IT - Technology ServicesPosting End Date:26/10/2026SummaryLocation: Toronto, Ontario; Waterloo, OntarioType: Full time
    Full time
    Work at office
    Work from home

    Sun Life Financial

    Waterloo, IL
    13 hours ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Full Stack Data Engineer. Be the first to apply!