477 Data Solution Designer jobs in Canada

Amilia is transforming the recreation and activities market with its innovative, purpose-built SaaS platform. Designed for municipalities, community centers, nonprofits, businesses, and recreation organizations, Amilia SmartRec™ streamlines operations, optimizes facility management, and simplifies program and membership management. 

Since 2009, Amilia has been on a mission to revolutionize how communities connect and participate in activities. By combining cutting-edge technology with deep industry expertise, the software empowers organizations to manage registrations, memberships, facilities, and finances more efficiently while enhancing community engagement. 

Over 1,500 organizations across 6,600 locations in North America rely on Amilia to serve 4.5 million participants and process $750M in transactions annually. 

Caring is at the core of Amilia’s culture: for customers, tailored products, and colleagues alike. Driven by an entrepreneurial spirit and a passion for innovation, this mindset shapes everything we do. 

What you can expect:

As a Data Solutions Consultant, you’ll be at the heart of our client onboarding experience. You’ll lead the charge in migrating complex datasets from legacy systems to SmartRec, while also designing custom data solutions that help our clients make smarter decisions. You’ll collaborate with cross-functional teams and act as a trusted advisor, solving real-world data challenges with creativity and precision. 

This is a unique opportunity to shape a growing team, build scalable processes, and make a direct impact on our clients’ success. 

You will be responsible for:

Data Migration & Onboarding  

• Scope and propose migration strategies during the sales cycle 

• Lead end-to-end data migration efforts (users, activities, payments) 

• Document and refine repeatable migration processes 

• Partner with Implementation Consultants to ensure smooth transitions 

Customer-Centric Data Solutions  

• Solve data-related business challenges with tailored solutions 

• Build custom reports and dashboards using tools like Power BI, API connectivity, automation tools  

• Support integrations with third-party applications 

• Advise clients on SmartRec’s data structures and best practices 

Process Improvement & Collaboration  

• Identify opportunities to improve and scale migration workflows 

• Maintain internal knowledge bases and integration guides 

• Collaborate with Product and Engineering to enhance platform features 

• Contribute to new service offerings that meet evolving client needs

Job Summary: We are seeking a highly skilled Senior Data Engineer with deep expertise in cloud-native data solutions, data warehouse migration, and pipeline orchestration.

This role focuses on designing, developing, and maintaining scalable data pipelines using Snowflake, Databricks, and Apache Airflow, with a

particular emphasis on data migration from Oracle to DBT Snowflake.

The ideal candidate will have a strong foundation in ETL/ELT processes, data modeling, and cloud architecture design.

Digital Competencies: Microsoft Azure, Python, Snowflake, PL/SQL

Key Responsibilities:

·    Design, develop, and optimize robust data pipelines using Snowflake, Databricks, and Apache Airflow.

·    Lead and execute data migration initiatives from Oracle to DBT Snowflake, including schema conversion, data transfer, and validation.

·    Build and maintain ETL/ELT processes for ingesting, transforming, and loading data from diverse sources.

·    Implement and manage data quality checks and governance standards.

·    Collaborate with data architects, data scientists, and business stakeholders to gather requirements and deliver effective solutions.

·    Monitor and troubleshoot pipeline performance to ensure data integrity and availability.

·    Maintain comprehensive documentation for pipelines, models, and migration processes.

·    Stay current with emerging data technologies and industry best practices.

Required Skills & Qualifications:

·    Bachelor’s degree in Computer Science, Engineering, or related field.

·    8+ years of experience in data engineering or a similar role.

·    Proven expertise in Snowflake: data warehousing, performance tuning, and security.

·    Strong experience with Databricks: Spark SQL, PySpark, Delta Lake.

·    Extensive experience with Apache Airflow for pipeline orchestration.

·    Demonstrated success in data migration projects, especially from Oracle to SQL Server or other RDBMS.

·    Proficiency in SQL and scripting languages such as Python and Scala.

·    Experience with cloud platforms: AWS, Azure, or GCP.

·    Solid understanding of data modeling techniques (e.g., dimensional modeling, normalization).

·    Excellent problem-solving, analytical, and communication skills.

Preferred Skills:

·    Experience with additional data migration tools and techniques.

·    Knowledge of data governance frameworks and compliance standards.

·    Familiarity with CI/CD pipelines for data solutions.

·    Certifications in Snowflake, Databricks, or cloud platforms.

**SAP Data Architecture Leader**
**Location: T** **oronto, Montreal, Calgary and Vancouver**
Capgemini Canada is seeking a dynamic and experienced SAP Data Architecture Technical Leader to spearhead the design, development, and implementation of cutting-edge data solutions. In this strategic role, you will act as a key bridge between business objectives and technological innovation, harnessing emerging technologies to deliver impactful, transformative results. This position offers a balanced mix of responsibilities- **50% focused on go-to-market strategy and client engagement** , and **50% dedicated to overseeing technical delivery** . It's an ideal opportunity for a professional who excels at solving complex data challenges and thrives in a fast-paced, collaborative environment.
**Required Skills**
**Selective Data Transition (SDT) Expertise** : Hands-on experience with SDT methodologies, including data carve-outs, harmonization, and consolidation.
**Project Delivery** : Proven track record of successfully delivering at least three greenfield SAP implementations and one SDT project.
**SAP Data Strategy** : Deep experience in defining and executing SAP data migration and analytics strategies, particularly within SAP S/4HANA environments.
**Tool Proficiency** : Strong working knowledge of data migration tools such as SAP Data Services (BODS), Syniti, SNP, CBS, Natuvion, or comparable platforms.
**Analytics Tools** : Expertise in SAP Analytics Cloud (SAC), Analysis for Office (AFO), and Embedded Analytics for real-time insights and reporting.
**ETL & Data Quality** : Hands-on experience with ETL processes, data profiling, cleansing, and data quality management across complex SAP landscapes.
**Data Governance** : Familiarity with data governance and stewardship tools such as SAP Information Steward or equivalent platforms.
**Cloud & Integration** : Understanding of SAP Business Technology Platform (BTP) and experience with hybrid or cloud-based data integration scenarios (e.g., Azure, AWS).
**Data Architecture & Modeling** : Proficiency in enterprise data architecture, data modeling (e.g., CDS Views, HANA Calculation Views), and data lineage practices.
**Security & Compliance** : Awareness of data privacy, compliance (e.g., GDPR), and security best practices in SAP environments.
**Pre-Sales & Solutioning** : Experience in preparing RFP responses, designing data solutions, and contributing to pre-sales and go-to-market activities.
**Leadership & Collaboration** : Demonstrated ability to lead data teams, mentor junior architects, and drive cross-functional collaboration.
**Stakeholder Engagement** : Exceptional communication and stakeholder management skills, with the ability to present complex technical concepts to both technical and executive audiences.
**Time Management** : Strong organizational skills to effectively balance delivery responsibilities with pre-sales and strategic initiatives
**Life at Capgemini**
Capgemini supports all aspects of your well-being throughout the changing stages of your life and career. For eligible employees, we offer:
+ Collaborating with teams of creative, fun, and driven colleagues
+ Flexible work options enabling time and location-based flexibility
+ Company-provided home office equipment
+ Virtual collaboration and productivity tools to enable hybrid teams
+ Comprehensive benefits program (Health, Welfare, Retirement and Paid time off)
+ Other perks and wellness benefits like discount programs, and gym/studio access.
+ Paid Parental Leave and coaching, baby welcome gift, and family care/illness days
+ Back-up childcare/elder care, childcare discounts, and subsidized virtual tutoring
+ Tuition assistance and weekly hot skill development opportunities
+ Experiential, high-impact learning series events
+ Access to mental health resources and mindfulness programs
+ Access to join Capgemini Employee Resource Groups around communities of interest
**About Capgemini**
Capgemini is a global business and technology transformation partner, helping organizations to accelerate their dual transition to a digital and sustainable world, while creating tangible impact for enterprises and society. It is a responsible and diverse group of 340,000 team members in more than 50 countries. With its strong over 55-year heritage, Capgemini is trusted by its clients to unlock the value of technology to address the entire breadth of their business needs. It delivers end-to-end services and solutions leveraging strengths from strategy and design to engineering, all fueled by its market leading capabilities in AI, cloud and data, combined with its deep industry expertise and partner ecosystem. The Group reported 2023 global revenues of 22.5 billion.
Get The Future You Want | ( is an Equal Opportunity Employer encouraging diversity in the workplace. All qualified applicants will receive consideration for employment without regard to race, national origin, gender identity/expression, age, religion, disability, sexual orientation, genetics, veteran status, marital status or any other characteristic protected by law.
This is a general description of the Duties, Responsibilities and Qualifications required for this position. Physical, mental, sensory or environmental demands may be referenced in an attempt to communicate the manner in which this position traditionally is performed. Whenever necessary to provide individuals with disabilities an equal employment opportunity, Capgemini will consider reasonable accommodations that might involve varying job requirements and/or changing the way this job is performed, provided that such accommodations do not pose an undue hardship.
Capgemini is committed to providing reasonable accommodations during our recruitment process. If you need assistance or accommodation, please reach out to your recruiting contact.
Click the following link for more information on your rights as an Applicant be aware that Capgemini may capture your image (video or screenshot) during the interview process and that image may be used for verification, including during the hiring and onboarding process.
Applicants for employment in Canada must have valid work authorization that does not now and/or will not in the future require sponsorship of a visa for employment authorization in Canada by Capgemini.
**Job:** _Project Manager_
**Organization:** _I&D_
**Title:** _SAP Data Solutions Leader_
**Location:** _CAN-ON-Toronto_
**Requisition ID:** _ _

Job Description

Job Description

Senior Manager, Data Solutions Delivery
Toronto, Canada | Hybrid Model

Our client, ranked among the top 25% of the most engaged companies globally , is seeking a Senior Manager, Data Solutions Delivery to lead strategic data initiatives, oversee technical teams, and ensure alignment with enterprise architecture and security standards.

Key Responsibilities

• Lead end-to-end delivery of data solutions, ensuring alignment with business goals and technical standards.

• Partner with business stakeholders as a trusted advisor to define scope and outcomes.

• Oversee technical build teams to ensure quality, security, and compliance.

• Maintain technology roadmaps and manage backlog prioritization.

• Provide leadership, coaching, and support to delivery teams.

• Support application performance, incident resolution, and continuous improvement.

Qualifications

• Bachelor’s degree in Computer Science or related field (or equivalent experience).

• 7+ years in IT/data roles, including 5+ years in stakeholder-facing functions and 2+ years in project management.

• Strong experience in data management, integration, modelling, and quality practices.

• Hands-on expertise with Tableau and Informatica (required).

• Proficiency in SQL, Python, Power BI, and data warehousing technologies.

• Strong grasp of data engineering principles, pipelines, and BI solutions.

• Solid understanding of SDLC, Agile/Waterfall methodologies, and testing practices.

• Demonstrated leadership, team management, and stakeholder engagement skills.

• Strong communication, problem-solving, and organizational abilities.

Additional Details

• Must be legally eligible to work in Canada.

• Background check required.

**The Position**
At Roche, we thrive to deliver more benefits to our patients as part of our 10-year Pharma vision. An integral part of achieving this vision is to deliver new and innovative data analytics solutions to our scientists across Pharma Technical Operations (PT). To do so, we have formed a new organization called PT Digital and Operational Excellence (PTE) with the aspiration to digitally transform and become a lean organization.
PTE is the organization that catalyzes the global development and execution of PT's Digital and Operational Excellence strategy to enable PT to realize our performance promises. We build a strong cross-functional and inclusive community, put the power of data into the hands of our people, further develop the Lean and Digital skills across PT, and scale up our Digital and Advanced Analytics solutions, for the benefit of our colleagues and patients.
We aim to activate data citizenship and digital mind, revolutionize our FAIR data ecosystem and systems landscape, re-design excellent processes, and generate transformative insights. We collaborate closely with global functions to deliver impactful value to our patients.
**The Opportunity**
PTE works in partnership across major global business functions, establishing and implementing an overall Digital / Technology strategy and driving the delivery and scale of key data & digital solutions in support of our vision.
As a Data Engineer at Roche PT, you will play a pivotal role in developing and optimizing the data infrastructure that powers our pharmaceutical operations and data products. Working in multidisciplinary teams-including data scientists, subject matter experts, and fellow data engineers-you'll curate, transform, and construct features integral to our modeling approaches. You will support the delivery of data products and help establish standards to ensure consistency and quality.
**What You'll Do**
+ Design and build scalable data pipelines and storage solutions for real-time and batch processing aligned with SME needs.
+ Contribute to the creation of FAIR (Findable, Accessible, Interoperable, Reusable) data products that enhance decision-making and maintain data integrity, availability, and performance across platforms.
+ Collaborate with process experts to model data landscapes, obtain extracts, define secure exchange methods, and shape data products.
+ Acquire, ingest, and process data from diverse sources into Big Data platforms (e.g., Snowflake).
+ Develop ERDs and reusable pipelines, working with data scientists to map data to hypotheses and prepare it for advanced analytics.
+ Uphold data governance standards to ensure regulatory compliance and secure sensitive data. Address data quality issues to maintain asset accuracy and reliability.
+ Follow best practices in data engineering, including data contracts and validation, to ensure quality and integrity.
+ Contribute to a culture of continuous improvement in engineering practices (DevOps, Data Streaming, etc.).
+ Use data quality and observability tools, including Ataccama and Monte Carlo.
Additional Responsibilities
+ Ensure adherence to Information Security standards across engagements.
+ Collaborate with infrastructure teams to provide a technology stack tailored to project needs and aligned with our standards.
+ Contribute to templates and best practices for the technology stack.
+ Apply innovative techniques to deliver impact for clients and support internal R&D initiatives.
**Who you are:**
+ **Education:** Bachelor's or Master's degree in Computer Science, Data Engineering, or a related field.
+ **Experience:**
+ 3+ years in data engineering with experience in designing large-scale systems.
+ Hands-on experience with GitLab/GIT, Airflow, Talend, AWS (S3, Lambda, etc.) and dbt.
+ Familiarity with data modeling, SQL, and Python for pipeline development and transformation logic.
+ Experience collaborating in cross-functional teams and applying data governance principles.
+ Experience in client-facing or collaborative project work is beneficial.
+ Ability to clearly communicate complex solutions to audiences of varied technical levels.
+ Strong organisational and interpersonal skills to deliver results, build relationships, and optimise resources.
**Preferred Qualifications:**
+ Experience in the pharmaceutical or healthcare industry is a plus.
+ Knowledge of regulatory requirements (e.g., GMP, FDA) and Quality systems.
+ Exposure to AI-driven data solutions and machine learning pipelines is an advantage.
This role calls for a collaborative, open-minded individual who values learning from colleagues, thoughtfully challenges ideas, and prioritizes impactful work. We seek someone who thrives in a dynamic environment, has a passion for continuous learning, and can be relied upon to work in the best interest of the team.
Relocation Assistance is not available for this role.
**The expected salary range for this position based on the primary location of Oceanside, CA is $97,900 - $181,900 . Actual pay will be determined based on experience, qualifications, geographic location, and other job-related factors permitted by law. A discretionary annual bonus may be available based on individual and Company performance. This position also qualifies for the benefits detailed at the link provided below.**
**Benefits ( is an equal opportunity employer. It is our policy and practice to employ, promote, and otherwise treat any and all employees and applicants on the basis of merit, qualifications, and competence. The company's policy prohibits unlawful discrimination, including but not limited to, discrimination on the basis of Protected Veteran status, individuals with disabilities status, and consistent with all federal, state, or local laws.
If you have a disability and need an accommodation in relation to the online application process, please contact us by completing this form Accommodations for Applicants ( .

This Data Engineer role is essential for driving efficiency and innovation within our organization. By developing and maintaining automation, this position helps streamline operations and improve efficiency, contributing to our mission of delivering high-quality products and platform services. This role is integral to our goal of continuous improvement and operational excellence.
**Position Responsibilities:**
+ Design, develop, and manage data pipelines that facilitate the detailed extraction, transformation, and loading of data from diverse sources.
+ Automate infrastructure provisioning and deployment using tools such as Terraform.
+ Demonstrate a solid understanding of data privacy and compliance regulations and best-practices.
+ Collaborate with Architecture, security, and risk teams to implement the latest guidelines and Azure standard methodologies.
+ Collaborate with business collaborators to suggest data solutions that align with business goals and improve decision-making processes.
+ Stay up to date with the latest tools and technologies and see opportunities to enhance Manulife's data infrastructure.
+ Ability to learn and implement best practices of big data and cloud computing to ensure solutions are scalable, efficient, and effective.
**Required Qualifications:**
+ 3 to 4 years of relevant industry experience as Data Engineer.
+ Good working knowledge on MS azure services (SQL Queries, ADLS gen 2, ADF, Databricks, Synapse, SQL Server) to design a data ecosystem.
+ Experience in automating data pipelines and familiarity with DevOps and CICD pipelines.
+ Good knowledge of data warehousing concepts and relational data modelling.
+ Strong hands-on knowledge of Python, PySpark, and T-SQL along with experience crafting and developing scripts for ETL processes and automation in Azure Data Factory and Azure Databricks.
+ Proficiency in GIT/Jenkins/dev ops processes to maintain and resolve issues with data pipelines in production.
**_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.
**Acerca de Manulife y John Hancock**
Manulife Financial Corporation es un importante proveedor internacional de servicios financieros que ayuda a las personas a tomar decisiones de una manera más fácil y a vivir mejor. Para obtener más información acerca de nosotros, visite .
**Manulife es un empleador que ofrece igualdad de oportunidades**
En Manulife/John Hancock, valoramos nuestra diversidad. Nos esforzamos por atraer, formar y retener una fuerza laboral tan diversa como los clientes a los que prestamos servicios, y para fomentar un entorno laboral inclusivo en el que se aprovechen las fortalezas de las culturas y las personas. Estamos comprometidos con la equidad en las contrataciones, la retención de talento, el ascenso y la remuneración, y administramos todas nuestras prácticas y programas sin discriminación por motivos de raza, ascendencia, lugar de origen, color, origen étnico, ciudadanía, religión o creencias religiosas, credo, sexo (incluyendo el embarazo y las afecciones relacionadas con este), orientación sexual, características genéticas, condición de veterano, identidad de género, expresión de género, edad, estado civil, estatus familiar, discapacidad, o cualquier otro aspecto protegido por la ley vigente.
Nuestra prioridad es eliminar las barreras para garantizar la igualdad de acceso al empleo. Un representante de Recursos Humanos trabajará con los solicitantes que requieran una adaptación razonable durante el proceso de solicitud. Toda la información que se haya compartido durante el proceso de solicitud de adaptación se almacenará y utilizará de manera congruente con las leyes y las políticas de Manulife/John Hancock correspondientes. Para solicitar una adaptación razonable en el proceso de solicitud, envíenos un mensaje a .
**Referenced Salary Location**
Toronto, Ontario
**Modalidades de Trabajo**
Híbrido
**Salary range is expected to be between**
$75,880.00 CAD - $140,920.00 CAD
Si se está postulando para este puesto fuera de la ubicación principal, póngase en contacto con para conocer el rango salarial de su ubicación. El salario real variará según las condiciones locales del mercado, la geografía y los factores relacionados con el trabajo pertinentes, como conocimiento, habilidades, calificaciones, experiencia y educación/capacitación. Los empleados también tienen la oportunidad de participar en programas de incentivos y obtener una compensación de incentivos vinculada al desempeño comercial e individual.
Manulife ofrece a los empleados aptos una amplia variedad de beneficios personalizables, entre ellos, beneficios de salud, odontológicos, de salud mental, oftalmológicos, por discapacidad a corto y a largo plazo, cobertura de seguro de vida y por muerte accidental y desmembramiento, adopción/subrogación y bienestar, y planes de asistencia al empleado/familiar. También ofrecemos a los empleados admisibles varios planes de ahorro para la jubilación (incluidos planes de pensiones y un plan mundial de propiedad de acciones con contribuciones equivalentes del empleador) y recursos de asesoramiento y educación financiera. Nuestro generoso programa de tiempo libre remunerado en Canadá incluye feriados, vacaciones, días personales y días por enfermedad, y ofrecemos la gama completa de ausencia laboral reglamentaria. Si se está postulando para este puesto en los EE. UU., póngase en contacto con para obtener más información sobre las disposiciones relativas al tiempo libre remunerado específicas de EE. UU.

This Data Engineer role is essential for driving efficiency and innovation within our organization. By developing and maintaining automation, this position helps streamline operations and improve efficiency, contributing to our mission of delivering high-quality products and platform services. This role is integral to our goal of continuous improvement and operational excellence.
**Position Responsibilities:**
+ Design, develop, and manage data pipelines that facilitate the detailed extraction, transformation, and loading of data from diverse sources.
+ Automate infrastructure provisioning and deployment using tools such as Terraform.
+ Demonstrate a solid understanding of data privacy and compliance regulations and best-practices.
+ Collaborate with Architecture, security, and risk teams to implement the latest guidelines and Azure standard methodologies.
+ Collaborate with business collaborators to suggest data solutions that align with business goals and improve decision-making processes.
+ Stay up to date with the latest tools and technologies and see opportunities to enhance Manulife's data infrastructure.
+ Ability to learn and implement best practices of big data and cloud computing to ensure solutions are scalable, efficient, and effective.
**Required Qualifications:**
+ 3 to 4 years of relevant industry experience as Data Engineer.
+ Good working knowledge on MS azure services (SQL Queries, ADLS gen 2, ADF, Databricks, Synapse, SQL Server) to design a data ecosystem.
+ Experience in automating data pipelines and familiarity with DevOps and CICD pipelines.
+ Good knowledge of data warehousing concepts and relational data modelling.
+ Strong hands-on knowledge of Python, PySpark, and T-SQL along with experience crafting and developing scripts for ETL processes and automation in Azure Data Factory and Azure Databricks.
+ Proficiency in GIT/Jenkins/dev ops processes to maintain and resolve issues with data pipelines in production.
**_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.
**Acerca de Manulife y John Hancock**
Manulife Financial Corporation es un importante proveedor internacional de servicios financieros que ayuda a las personas a tomar decisiones de una manera más fácil y a vivir mejor. Para obtener más información acerca de nosotros, visite .
**Manulife es un empleador que ofrece igualdad de oportunidades**
En Manulife/John Hancock, valoramos nuestra diversidad. Nos esforzamos por atraer, formar y retener una fuerza laboral tan diversa como los clientes a los que prestamos servicios, y para fomentar un entorno laboral inclusivo en el que se aprovechen las fortalezas de las culturas y las personas. Estamos comprometidos con la equidad en las contrataciones, la retención de talento, el ascenso y la remuneración, y administramos todas nuestras prácticas y programas sin discriminación por motivos de raza, ascendencia, lugar de origen, color, origen étnico, ciudadanía, religión o creencias religiosas, credo, sexo (incluyendo el embarazo y las afecciones relacionadas con este), orientación sexual, características genéticas, condición de veterano, identidad de género, expresión de género, edad, estado civil, estatus familiar, discapacidad, o cualquier otro aspecto protegido por la ley vigente.
Nuestra prioridad es eliminar las barreras para garantizar la igualdad de acceso al empleo. Un representante de Recursos Humanos trabajará con los solicitantes que requieran una adaptación razonable durante el proceso de solicitud. Toda la información que se haya compartido durante el proceso de solicitud de adaptación se almacenará y utilizará de manera congruente con las leyes y las políticas de Manulife/John Hancock correspondientes. Para solicitar una adaptación razonable en el proceso de solicitud, envíenos un mensaje a .
**Referenced Salary Location**
Toronto, Ontario
**Modalidades de Trabajo**
Híbrido
**Salary range is expected to be between**
$75,880.00 CAD - $140,920.00 CAD
Si se está postulando para este puesto fuera de la ubicación principal, póngase en contacto con para conocer el rango salarial de su ubicación. El salario real variará según las condiciones locales del mercado, la geografía y los factores relacionados con el trabajo pertinentes, como conocimiento, habilidades, calificaciones, experiencia y educación/capacitación. Los empleados también tienen la oportunidad de participar en programas de incentivos y obtener una compensación de incentivos vinculada al desempeño comercial e individual.
Manulife ofrece a los empleados aptos una amplia variedad de beneficios personalizables, entre ellos, beneficios de salud, odontológicos, de salud mental, oftalmológicos, por discapacidad a corto y a largo plazo, cobertura de seguro de vida y por muerte accidental y desmembramiento, adopción/subrogación y bienestar, y planes de asistencia al empleado/familiar. También ofrecemos a los empleados admisibles varios planes de ahorro para la jubilación (incluidos planes de pensiones y un plan mundial de propiedad de acciones con contribuciones equivalentes del empleador) y recursos de asesoramiento y educación financiera. Nuestro generoso programa de tiempo libre remunerado en Canadá incluye feriados, vacaciones, días personales y días por enfermedad, y ofrecemos la gama completa de ausencia laboral reglamentaria. Si se está postulando para este puesto en los EE. UU., póngase en contacto con para obtener más información sobre las disposiciones relativas al tiempo libre remunerado específicas de EE. UU.

Job Description
We are seeking a highly skilled and proactive Data Engineer to join our Data Management team, with a focus on optimizing cloud-based analytics infrastructure and mentoring technical analysts. This role is critical to enabling data-driven decision-making by ensuring fast, reliable, and governed access to data across the organization. You will work within a cloud-first environment (primarily AWS) to assess and enhance existing data pipelines, reporting workflows, and architecture-especially those built during a recent ERP transition. You'll also support metadata and master data management initiatives, collaborate across technical and business teams, and help build scalable, secure, and well-governed data solutions.
- Mentor and upskill technical Data Analysts, providing guidance on cloud data engineering best practices.
- Evaluate and optimize existing analytics architecture, workflows, and pipelines-especially those supporting Power BI reporting from AWS Redshift.
- Design, develop, and maintain scalable data pipelines and ETL/ELT workflows for efficient data integration, transformation, and reporting.
- Automate data workflows including validation, monitoring, and CI/CD-based deployments.
- Ensure data quality, consistency, and integrity through validation frameworks and anomaly detection.
- Support metadata management and governance by building connectors and workflows for platforms like Collibra, Informatica, Microsoft Purview, and Ataccama.
- Integrate master data sources (e.g., SAP, Salesforce, Workforce Software) to ensure consistency and a single source of truth.
- Collaborate with architecture leads and business stakeholders to align technical solutions with organizational goals and future capabilities.
- Support migration efforts from legacy dashboards (e.g., Qlik on-prem) to cloud platforms, with a priority on Power BI.
- Contribute to RFPs and platform evaluations for metadata and governance tools.
- Monitor and optimize database performance, storage efficiency, and data processing speed.
- Implement data governance and security at the infrastructure level in compliance with enterprise policies and industry regulations.
Stay current with modern data architecture trends (e.g., Lakehouse, containerization, orchestration)
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: and Requirements
- 3-5 years of hands-on experience in cloud data engineering, with strong expertise in AWS (Redshift, Glue, Lambda, S3, IAM, Step Functions).
- Familiarity with Azure, GCP, and cloud-agnostic architectures to support POCs and evolving platform needs.
- Strong proficiency in SQL (including Spark SQL), Python (PySpark), and Scala.
- Experience with ETL/ELT tools (e.g., AWS Glue, Apache Airflow).
- Experience with big data technologies (e.g., Spark, Redshift, Kafka, Iceberg).
- Experience with NoSQL databases (e.g., DynamoDB, MongoDB).
- Experience managing infrastructure with IaC tools (e.g., Terraform, CloudFormation) and container orchestration (e.g., Docker, Kubernetes).
- Experience designing and implementing CI/CD pipelines using GitHub Actions, SonarQube, etc.
- Solid understanding of cloud monitoring and logging tools (e.g., CloudWatch).
Strong communication and collaboration skills across technical and business teams. - Experience with metadata management and governance platforms (e.g., Collibra, Atlan, Informatica MDM, Microsoft Purview).
- Comfortable providing technical guidance and mentorship to peers and stakeholders.
- Exposure to master data management practices and integration with platforms like SAP, Salesforce, and Snowflake.
- Experience working in ERP transition environments and optimizing rushed reporting setups.
Ability to work independently and make informed decisions with minimal guidance.

Join us at Manulife and be part of a team that strives for excellence, where your efforts will directly contribute to our success. Here, your work will have an important impact, and you'll be empowered to make decisions that improve our marketing strategies and customer experience.
As a Data Engineer at Manulife, you would play a critical role in the development and maintenance of the company's data systems and architecture. You would collaborate with other highly skilled data engineers, data architects and governance team in designing, developing, and deploying data pipelines, ETL processes, and other data integration solutions to extract, transform, and load data from various sources into Manulife's data warehouse.
This Data Engineer role is essential for driving efficiency and innovation within our organization. By developing and maintaining automation, this position helps streamline operations and improve efficiency, contributing to our mission of delivering high-quality products and platform services. This role is integral to our goal of continuous improvement and operational excellence.
**Position Responsibilities:**
+ Design, develop, and maintain scalable ETL/ELT pipelines using Azure Data Factory, Azure Databricks, and other relevant services
+ Develop and maintain the company's data architecture, including data models, schemas, and data dictionaries.
+ Integrate data from various sources, ensuring data quality and consistency, and prepare it for analytical and operational use
+ Follow consistency of data governance policies and processes to ensure data security, privacy, and compliance.
+ Collaborate with other data professionals, including data scientists, analysts, and business team members, to understand data requirements and develop solutions to meet those needs.
+ Stay up to date with the latest tools and technologies and see opportunities to enhance Manulife's data infrastructure.
+ Ability to learn and implement best practices of big data and cloud computing to ensure solutions are scalable, efficient, and effective.
**Required Qualifications:**
+ **4** or more years of relevant industry experience as Data Engineer
+ Experience in building and operationalizing Data pipelines in cloud MS Azure using Azure Data Factory, Azure Databricks.
+ Experience in automating data pipelines and familiarity with DevOps and CICD pipelines
+ Good working knowledge on MS azure services (SQL Queries, ADLS gen 2, ADF, Databricks, Synapse, SQL Server) to design a data ecosystem.
+ Good knowledge of data warehousing concepts and relational data modelling
+ Familiarity with programming in both compile languages (Java, Scala) and scripting languages (Python, SQL, R)
+ Understanding of Agile scrum methodologies and experience of working in an Agile team, with exposure to and working understanding of collaboration tools like Teams, JIRA, Mural
+ Experience in Data processing, performance analysis, tuning and capacity planning
**Preferred Qualifications:**
+ Excellent communication and interpersonal skills
+ Excellent analytical, problem solving and solutioning skills
+ A capacity for constant learning from both success and failure, remaining open to change and continuous improvement
+ Familiarity with production release and operational support model
**_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 distributed team, we'll support you in crafting the future you want to see!
**Acerca de Manulife y John Hancock**
Manulife Financial Corporation es un importante proveedor internacional de servicios financieros que ayuda a las personas a tomar decisiones de una manera más fácil y a vivir mejor. Para obtener más información acerca de nosotros, visite .
**Manulife es un empleador que ofrece igualdad de oportunidades**
En Manulife/John Hancock, valoramos nuestra diversidad. Nos esforzamos por atraer, formar y retener una fuerza laboral tan diversa como los clientes a los que prestamos servicios, y para fomentar un entorno laboral inclusivo en el que se aprovechen las fortalezas de las culturas y las personas. Estamos comprometidos con la equidad en las contrataciones, la retención de talento, el ascenso y la remuneración, y administramos todas nuestras prácticas y programas sin discriminación por motivos de raza, ascendencia, lugar de origen, color, origen étnico, ciudadanía, religión o creencias religiosas, credo, sexo (incluyendo el embarazo y las afecciones relacionadas con este), orientación sexual, características genéticas, condición de veterano, identidad de género, expresión de género, edad, estado civil, estatus familiar, discapacidad, o cualquier otro aspecto protegido por la ley vigente.
Nuestra prioridad es eliminar las barreras para garantizar la igualdad de acceso al empleo. Un representante de Recursos Humanos trabajará con los solicitantes que requieran una adaptación razonable durante el proceso de solicitud. Toda la información que se haya compartido durante el proceso de solicitud de adaptación se almacenará y utilizará de manera congruente con las leyes y las políticas de Manulife/John Hancock correspondientes. Para solicitar una adaptación razonable en el proceso de solicitud, envíenos un mensaje a .
**Referenced Salary Location**
CAN, Ontario, Waterloo, 500 King Street North
**Modalidades de Trabajo**
Híbrido
**Salary range is expected to be between**
$75,880.00 CAD - $140,920.00 CAD
Si se está postulando para este puesto fuera de la ubicación principal, póngase en contacto con para conocer el rango salarial de su ubicación. El salario real variará según las condiciones locales del mercado, la geografía y los factores relacionados con el trabajo pertinentes, como conocimiento, habilidades, calificaciones, experiencia y educación/capacitación. Los empleados también tienen la oportunidad de participar en programas de incentivos y obtener una compensación de incentivos vinculada al desempeño comercial e individual.
Manulife ofrece a los empleados aptos una amplia variedad de beneficios personalizables, entre ellos, beneficios de salud, odontológicos, de salud mental, oftalmológicos, por discapacidad a corto y a largo plazo, cobertura de seguro de vida y por muerte accidental y desmembramiento, adopción/subrogación y bienestar, y planes de asistencia al empleado/familiar. También ofrecemos a los empleados admisibles varios planes de ahorro para la jubilación (incluidos planes de pensiones y un plan mundial de propiedad de acciones con contribuciones equivalentes del empleador) y recursos de asesoramiento y educación financiera. Nuestro generoso programa de tiempo libre remunerado en Canadá incluye feriados, vacaciones, días personales y días por enfermedad, y ofrecemos la gama completa de ausencia laboral reglamentaria. Si se está postulando para este puesto en los EE. UU., póngase en contacto con para obtener más información sobre las disposiciones relativas al tiempo libre remunerado específicas de EE. UU.