Senior Data Engineer

Hoopp-; Toronto; On-site; CAD 103,000 - 153,000; Full time

Benefits offered by this job

100% company-paid extended health and 

dental benefits

Defined benefit pension plan

Learning & development programs

Parental leave top-up

Health spending account

Job summary

HOOPP is seeking a Senior Data Engineer in Toronto to design data foundations and AI-ready assets powering analytics and AI use cases. You will build scalable AWS pipelines, use Snowflake as a core data platform, and shape the lakehouse with metadata-driven models for trusted data.

You will collaborate with data scientists, AI engineers, and business partners, applying best practices in testing, IaC, and CI/CD to deliver measurable business impact.

Qualifications

• 7+ years of data engineering experience, with 3+ years building production data solutions on AWS.
• Hands-on depth with the AWS data stack — S3, Glue, Lambda, Athena, Step Functions, EventBridge.
• Strong SQL and Python, with experience building distributed data processing at scale (Spark).

Responsibilities

• Build data foundations transforming structured and unstructured data into AI-ready assets.
• Architect cloud-native pipelines on AWS for scalable data movement.
• Set engineering standards, perform reviews, and mentor engineers.
• Ensure automated testing, IaC, and CI/CD for reliable releases.
• Build observability and data lineage into pipelines from day one.

Skills

Data engineering

SQL

Python

Spark

AWS

Snowflake

ETL

CI/CD

Education

Post-secondary education in computer science or engineering

AWS Data Engineer or Solutions Architect certification

Tools

Snowflake

Cortex AI

Snowpark

Vector search

Terraform

Git

CI/CD

Job description

Why you’ll love working here:high-performance, people-focused cultureour commitment that equity, diversity, and inclusion are fundamental to our work environment and business success, which helps employees feel valued and empowered to be their authentic selveslearning and development initiatives, including workshops, Speaker Series events and access to LinkedIn Learning, that support employees’ career growthmembership in HOOPP’s world class defined benefit pension plan, which can serve as an important part of your retirement securitycompetitive, 100% company-paid extended health and dental benefits for permanent employees, including coverage supporting our team's diversity and mental health (e.g., gender affirmation, fertility and drug treatment, psychological support benefits of $2,500 per year, parental leave top-up, and a health spending account).optional post-retirement health and dental benefits subsidized at 50%yoga classes, meditation workshops, nutritional consultations, and wellness seminarsthe opportunity to make a difference and help take care of those who care for us, by providing a financially secure retirement for Ontario healthcare workersJob SummaryHOOPP's Information Technology teams deliver innovative technology solutions to help build a stronger financial future for the healthcare community. As a Senior Data Engineer, you will design and build the data foundations (spanning structured and unstructured data on AWS) that turn raw information into trusted insight and AI-ready assets to support our teams in delivering on the pension promise.Our Enterprise Data Platform team builds and operates the cloud data platform that powers analytics, reporting, and AI across HOOPP. As a Senior Data Engineer, reporting to the Senior Director, Enterprise Data Platform, you will build scalable pipelines on AWS across both structured and unstructured data, stand up the ingestion and retrieval patterns behind our emerging AI use cases, and set the engineering standards the broader data team builds on.We cultivate a culture that emphasizes innovation, collaboration, practicality, and the courage to challenge the status quo. This role is well suited to someone who combines technical depth with curiosity, sound judgment, product thinking, systems thinking, and a willingness to test new ideas. You will look beyond immediate symptoms, identify underlying needs, and develop solutions that are secure, sustainable, and valuable in delivering the pension promise. Success in this role requires the ability to navigate ambiguity, ask thoughtful questions, and turn emerging technologies into practical solutions that deliver measurable business impact.What you will do:Build the data foundations that power HOOPP’s AI ambitions by transforming structured data, documents, text, and other unstructured content into trusted, accessible assets that fuel AI models, search, and retrieval capabilities.Take AI and analytics ideas from whiteboard to production with data scientists, AI engineers, and the business. We prototype fast, prove what works, and retire what doesn't.Use Snowflake as a core data warehouse and AI platform, applying capabilities such as Cortex AI to support scalable analytics and emerging AI use cases.Architect cloud-native pipelines on AWS that move structured and unstructured data at scale.Shape our lakehouse on Amazon S3 by using open table formats, thoughtful data models, and metadata that makes the platform genuinely easy for others to build on.Set the engineering standards the broader data team builds on, and raise the bar through design reviews, code reviews, and mentorship.Bring engineering rigor to data through automated testing, infrastructure-as-code, and CI/CD that make releases boring and reliable.Build quality, lineage, and observability into every pipeline from day one, so trust in the data is the default.What you will bring:7+ years of data engineering experience, combined with 3+ years building production data solutions on AWS.Hands-on depth with the AWS data stack — for example S3, Glue, Lambda, Athena, Step Functions, and EventBridge.Hands-on experience with Snowflake, including its AI and generative AI capabilities (such as Cortex AI, Snowpark, and vector search).Strong SQL and Python, with experience building distributed data processing at scale (Spark preferred).Demonstrated experience working with unstructured data (documents, text, images, or audio) in support of AI or machine learning use cases.Exposure to AI and generative AI data patterns such as embeddings, vector stores, and retrieval-augmented generation.Experience with lakehouse architectures and open table formats (Iceberg, Delta, or Hudi), as well as dimensional modelling for analytics.Working knowledge of infrastructure-as-code (Terraform or CloudFormation), Git, and CI/CD for data workloads.Ability to navigate ambiguity, ask thoughtful questions, and turn emerging technologies into practical, measurable outcomes.Strong communication skills, with the ability to explain technical trade-offs to non-technical partners and mentor other engineers.Post-secondary education in computer science, engineering, or a related field; AWS Data Engineer or Solutions Architect certification is an assetThe expected annual base salary range for this role is: $103,000 - $153,000 CADThe actual base salary offered to the successful candidate may vary based on multiple factors including, but not limited to, individual's expertise and level of experience applicable to the role they are being offered.This role is eligible to participate in discretionary incentive plan(s), subject to the terms and conditions of the applicable incentive plan text.This job is for an existing vacancy.HOOPP may use artificial intelligence tools to assist in screening, assessing and selecting applicants for this position. These tools support our recruitment process but do not replace human judgment and decision-making.