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...