Senior Data Engineer, AI & Agents
- Level
- Senior
Not stated in the posting: salary, work type, visa.
Open. First seen 2 October 2026.
About the role
About us
Appnovation Technologies's standard text
Appnovation is the AI Product Company. Headquartered in Vancouver, Canada, with teams around the world, Appnovation builds AI products, delivers enterprise AI and digital solutions, and co-invests with clients to bring new AI products to market.
Open source has been the foundation of Appnovation's work since 2007, and it remains the foundation underneath every AI product the company builds today. Appnovation teams work with organizations in highly regulated industries, including global leaders such as Pfizer, Google and AstraZeneca, to help them adopt AI they can govern and own.
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
Appnovation Technologies's standard text
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.
What this role asks for
Particular to this role
Airflow · Apache Iceberg · Vector Databases
Rare in Appnovation Technologies's other 32 open postings.
Standard for data engineering roles
AWS · CI/CD · Data Warehousing · Python · SQL · Snowflake · Spark · dbt
Common in data engineering postings at any company.
74% of this description is written for the role. The rest is Appnovation Technologies's standard text, folded away below.
Compared with Appnovation Technologies's other open jobs.
The team: Pfizer - Technology HIRES STEADILY
This role is one of 13 open in Pfizer - Technology. 4 were posted in the last 30 days and the oldest in February: a team that hires all year rather than one being built.
WHAT THE TEAM WORKS WITH, ACROSS ITS POSTINGS
AWS (10 of 13), Python (8 of 13), CI/CD (6 of 13), SQL (6 of 13), Apache Iceberg (5 of 13), Databricks (5 of 13), OAuth (5 of 13)
OTHER ROLES ON THIS TEAM
- Principal Engineer, Developer Surfaces Lead posted Nov 13
- Cloud Solutions Architect posted Nov 11
- Senior Web Technical Product Manager posted Oct 22
- Senior Web Technical Product Manager posted Oct 22
- Principal Engineer posted Sep 25
- Senior Data Engineer, AI & Agents posted Sep 4
- Senior Data Engineer, AI & Agents posted Sep 4
- Senior Solutions Architect posted Sep 1
- Solutions Architect posted Sep 1
- Sr. Full-Stack Developer, AI Design-to-Dev posted Aug 13
- Sr. Full-Stack Developer, AI Design-to-Dev posted Feb 24
- Sr. Full-Stack Developer, AI Design-to-Dev posted Feb 24
From the team and dates on Appnovation Technologies's own job board.
See Data Engineer salaries in New York →
Similar jobs
- Senior Data Engineer, Ads Data (AI Native) at Life360
Shares 10 skills: Unity, Airflow, dbt… · Senior level · same country - Senior Software Engineer - Python, Data Engineering, AI at Zenoti
Shares 13 skills: Apache Iceberg, Unity, Airflow… · Senior level - Lead Data Engineer, Databricks (Remote, US) at V4C.ai
Shares 10 skills: Unity, Airflow, dbt… · same country - Engineering Manager, Enterprise Data Warehouse & Analytics at Machinify
Shares 10 skills: Unity, Airflow, dbt… · same country - Senior Data Engineer, Platform at Vanna Health
Shares 9 skills: Unity, dbt, Spark… · Senior level · same country - Principal Engineer, Developer Surfaces Lead at Appnovation Technologies
Also at this company
More jobs like this
Is this your posting? Email [email protected] to have it removed.