Location
toronto
Job Type
Full-time
Posted
July 09, 2026
Job Description
Senior Data & AI Engineer
Location: Toronto, ON - Hybrid (3 days on site)
Pay Rate: $65.37/hr - $77.18/hr
Contract Length: 6 months with possibility for extension
Responsibilities
- Triage overnight pipeline failures (Airflow DAGs, ETL jobs) and resolve data quality issues
- Write and optimize complex SQL across Trino, Snowflake, and SQL Server for IAM reporting
- Build and iterate on MCP server tools / agentic AI workflows — prompt tuning, RAG testing, LLM output validation
- Develop and maintain ETL/ELT pipelines (Airflow, Spark, DBT, Iceberg) for new and existing data feeds
- Translate IAM business rules (PAM, entitlements, password compliance) into queryable data models
- Collaborate with IAM analysts and stakeholders to clarify requirements and deliver data solutions
- Maintain Snowflake semantic layer views and Cortex AI featu...