Senior Data Engineer
Healthcare of Ontario Pension Plan2 months ago
Toronto, CanadaSenior
Responsibilities
- Build data foundations that transform structured and unstructured content into trusted assets for AI models, search, and retrieval.
- Develop production analytics and AI solutions in collaboration with data scientists, AI engineers, and business partners.
- Use Snowflake, including Cortex AI and related capabilities, as a core data warehouse and AI platform.
- Architect scalable AWS pipelines and shape the Amazon S3 lakehouse using open table formats, data models, and metadata.
- Set engineering standards through design reviews, code reviews, mentorship, and technical guidance.
- Implement automated testing, infrastructure-as-code, CI/CD, data quality, lineage, and observability for reliable data workloads.
Requirements
- 7+ years of data engineering experience and 3+ years building production data solutions on AWS.
- Hands-on experience with AWS data services including S3, Glue, Lambda, Athena, Step Functions, and EventBridge.
- Hands-on Snowflake experience, including Cortex AI, Snowpark, and vector search capabilities.
- Strong SQL and Python skills, with distributed data processing experience; Spark is preferred.
- Experience working with unstructured data such as documents, text, images, or audio for AI or machine learning use cases.
- Experience with embeddings, vector stores, retrieval-augmented generation, lakehouse architectures, open table formats, and dimensional modeling.
- Working knowledge of Terraform or CloudFormation, Git, and CI/CD for data workloads.
- Strong communication, judgment, ambiguity navigation, practical problem-solving, and mentoring skills.
- Post-secondary education in computer science, engineering, or a related field; AWS Data Engineer or Solutions Architect certification is an asset.
Benefits
- Competitive annual base salary range of $103,000–$153,000 CAD, plus eligibility for discretionary incentive plans.
- 100% company-paid extended health and dental benefits for permanent employees, including mental health, fertility, gender affirmation, drug treatment, psychological support, parental leave top-up, and a health spending account.
- Membership in HOOPP’s defined benefit pension plan and optional post-retirement health and dental benefits subsidized at 50%.
- Learning and development opportunities including workshops, Speaker Series events, and LinkedIn Learning.
- Wellness programs including yoga, meditation workshops, nutritional consultations, and wellness seminars.
About Healthcare of Ontario Pension Plan
Healthcare of Ontario Pension Plan (HOOPP) administers a multi-employer defined benefit pension for Ontario’s hospital and community healthcare sector, investing contributions to deliver lifetime retirement income. Its plan is funded by employer and employee contributions and investment returns, and serves over 460,000 members across more than 670 employers. Established in 1960 and headquartered in Toronto, it operates as a nonprofit with in-house investment management and pension administration.