Senior Data Engineer, AI & Agents

Posted Yesterday
Be an Early Applicant
Toronto, ON, CAN
In-Office
Senior level
Information Technology • Consulting
The Role
Build and register domain-grounded data agents over governed Databricks and Snowflake datasets. Perform lakehouse migrations to open formats such as Apache Iceberg, curate catalogue metadata, and support data-contract workflows. Partner with business stakeholders and subject-matter experts to validate data assets. Implement advanced SQL and PySpark pipelines, orchestration, data quality, observability, lineage, masking, and row- and column-level security. The role also supports vector search, embeddings, cloud data onboarding, and regulated-domain use cases.
Summary Generated by Built In

About us

Appnovation is a global, full-service digital partner that combines Strategy, Experience & Design, Engineering and Managed Services. We build digital solutions that deliver real impact today and serve as foundations for future growth.  Bold ambition. Practical action. Endless possibilities.

As a Senior Data Engineer, AI & Agents, you will prepare enterprise domain data for consumption by AI agents, partnering directly with business stakeholders and subject-matter experts. The role centers on building and registering domain-grounded data agents over governed datasets, performing lakehouse migrations, and onboarding new data domains — including commercial, finance, research and development, and real-world data — onto the enterprise data platform. You will operate across Databricks and Snowflake, converting source tables to open formats and generating the catalogue metadata that powers downstream automation and data-contract workflows, all while ensuring high data quality, governed access, and reliable agent-based access to trusted data. The ideal candidate brings deep, hands-on data engineering expertise, strong governance instincts, and excellent stakeholder-facing skills.

Key Responsibilities
  • Build and register domain data agents at scale over governed tables across Databricks and Snowflake.
  • Perform lakehouse migrations, including converting source tables to open formats (e.g., Apache Iceberg) to enable agent-based access.
  • Generate and curate catalogue metadata that feeds downstream automation and data-contract workflows.
  • Partner with business stakeholders and subject-matter experts through iterative build, test, and validation cycles.
Qualifications
  • Bachelor’s or Master’s degree in Computer Science, Information Systems, Engineering, or a related field.
  • 5+ years of professional experience in data engineering, with significant hands-on experience across modern data warehousing and lakehouse platforms (Databricks and Snowflake preferred).
  • Strong data engineering background with genuine, hands-on fluency across both Databricks and Snowflake.
  • Demonstrated experience building data agents or query interfaces over governed datasets (e.g., Snowflake Cortex or Genie).
  • Advanced SQL together with Spark / PySpark, and experience with pipeline orchestration (dbt, Apache Airflow, or Databricks Workflows).
  • Experience implementing data quality, observability, and lineage, and applying governance controls such as masking and row- and column-level security.
  • Excellent stakeholder-facing skills, with a track record of translating business requirements into delivered data assets.
Preferred Skills
  • Familiarity with MCP-based data exposure and with embeddings or vector search for retrieval-augmented use cases.
  • Experience with AWS and S3, in anticipation of onboarding native cloud data sources.
  • Experience with regulated life-sciences data domains (clinical, commercial, or real-world data).
Technical Experience
  • Data platforms: Databricks, Snowflake (Cortex, Genie); AWS and S3.
  • Pipelines and modelling: SQL, PySpark, dbt, Airflow / Databricks Workflows.
  • Governance and catalogue: Unity Catalogue, Horizon, Collibra.
  • AI and agents: MCP; vector databases and embeddings.
  • Foundations: Python; YAML data contracts; Apache Iceberg; Git and CI/CD.
Who you are
  • Agent-Oriented Builder: You enjoy turning governed datasets into reliable, domain-grounded agents that business users can query with confidence.
  • Quality-Focused: You are rigorous about data accuracy, lineage, and observability, ensuring high standards through validation before data reaches agents or the business.
  • Collaborative Partner: You thrive working directly with stakeholders and subject-matter experts through iterative build, test, and validation cycles.
  • Governance-Minded: You understand the critical nature of data security in regulated domains and proactively apply masking and row- and column-level controls.
  • Forward-Thinking: You are interested in the “big picture” of lakehouse architecture and open formats, eager to advance agent-based access patterns and best practices.
What Appnovation Offers
  • Challenging and rewarding work with real impact
  • Direct Access to Cutting-Edge AI Platforms
  • Diverse and Inclusive Culture
  • Growth opportunities for personal and professional development
  • A collaborative and innovative work environment where your ideas are valued
  • Exposure to exciting projects and high-profile clients
  • Supportive work environment with access to company leaders
  • Hybrid working model
 
Thank you for your interest in a career with Appnovation Technologies! Please note that only those selected for an interview will be contacted.
 
At Appnovation, we recognize that diverse teams are the strongest teams. Diversity, Equity & Inclusion is not only something that we embrace - we celebrate it! We are proud to be an Equal Opportunity Employer and we encourage applicants from all backgrounds, lived experiences and industries to apply. Come join us at Appnovation, and learn more about how we stay true to our company values as we build better lives through better digital.

Accommodations are available upon request throughout the recruitment process.

Skills Required

  • Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field
  • 5+ years of professional experience in data engineering
  • Hands-on experience with modern data warehousing and lakehouse platforms, especially Databricks and Snowflake
  • Experience building data agents or query interfaces over governed datasets, such as Snowflake Cortex or Genie
  • Advanced SQL and Spark or PySpark experience
  • Experience with pipeline orchestration using dbt, Apache Airflow, or Databricks Workflows
  • Experience implementing data quality, observability, and lineage
  • Experience applying masking and row- and column-level security controls
  • Excellent stakeholder-facing skills and ability to translate business requirements into delivered data assets
  • Familiarity with MCP-based data exposure, embeddings, or vector search
  • Experience with AWS and S3
  • Experience with regulated life-sciences data domains
Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Vancouver
372 Employees
Year Founded: 2007

What We Do

Inspiring Possibility Appnovation is a full service digital consultancy with experience and capacity to meet the needs of even the largest most complex of organizations in the world. Our services portfolio enables us to offer clients the best of experiences when working with our teams so as to make sure we keep the focus on their needs, customers and delivering tangible value to the business. End to end services; endless ideas.

Similar Jobs

BuildOps Logo BuildOps

Senior Engineering Manager

Cloud • Mobile • Software
Easy Apply
Hybrid
Toronto, ON, CAN
500 Employees
172K-229K Annually

Block Logo Block

Software Engineer

Blockchain • eCommerce • Fintech • Payments • Software • Financial Services • Cryptocurrency
In-Office or Remote
8 Locations
12000 Employees
153K-270K Annually

Magna International Logo Magna International

Network Administrator

Automotive • Hardware • Robotics • Software • Transportation • Manufacturing
Hybrid
Newmarket, ON, CAN
171000 Employees
65K-80K Annually

MongoDB Logo MongoDB

Product Manager

Big Data • Cloud • Software • Database
Easy Apply
Hybrid
Toronto, ON, CAN
5550 Employees

Similar Companies Hiring

Standard Template Labs Thumbnail
Artificial Intelligence • Information Technology • Software
New York, NY
25 Employees
NODA AI Thumbnail
Artificial Intelligence • Information Technology • Software • Cybersecurity
Sydney, AU
54 Employees
Golden Pet Brands Thumbnail
Digital Media • eCommerce • Information Technology • Marketing Tech • Pet • Retail • Social Media
El Segundo, California
178 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account