Senior Data Engineer, AI & Agents

Appnovation

New York (NY)

On-site

USD 150,000 - 190,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Challenging and rewarding work with ре
Direct Access to Cutting-Edge AI Plata
Diverse and Inclusive Culture
Growth opportunities
Collaborative and innovative work

Job summary

Appnovation in New York is seeking a Senior Data Engineer, AI & Agents to prepare enterprise domain data for use by AI agents and to build domain-grounded data agents over governed datasets on the enterprise data platform.

You will work across Databricks and Snowflake, perform lakehouse migrations, and generate catalogue metadata to power downstream automation and data-contract workflows with strong governance and data quality. This role requires hands-on engineering and cross-team collaboration.

Qualifications

  • Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or a related field.
  • 5+ years of professional data engineering experience with modern data warehousing and lakehouse platforms (Databricks and Snowflake preferred).
  • Strong data engineering background with hands-on Databricks and Snowflake proficiency.
  • Experience building data agents or query interfaces over governed datasets (e.g., Snowflake Cortex or Genie).
  • Advanced SQL with PySpark and experience with pipeline orchestration (dbt, Airflow, or Databricks Workflows).
  • Experience implementing data quality, observability, lineage, and governance controls.

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

Skills

Data engineering
Stakeholder management
SQL
PySpark
Data governance
Communication

Education

Bachelor's or Master's degree in Computer Science, Information Systems, Engineering, or related field

Tools

Databricks
Snowflake
SQL
dbt
Airflow
Unity Catalogue
Apache Iceberg

Job description

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


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 le

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer, AI & Agents
Senior Data Engineer, AI & Agents

Appnovation • Miami (FL)

Hybrid
USD 140,000 - 190,000
Challenging work with real impact
Direct access to cutting‑edge AI tools
Diverse and inclusive culture
+1
Senior Data Engineer, AI & Agents
Senior Data Engineer, AI & Agents

Appnovation • Dallas (TX)

On-site
USD 130,000 - 190,000
Challenging work
Cutting-edge AI platforms
Growth opportunities
+3
Senior Data Engineer, AI & Agents
Senior Data Engineer, AI & Agents

Appnovation • Austin (CO)

On-site
USD 140,000 - 190,000
Challenging work
AI platforms access
Diverse culture
+1
Senior Data Engineer, AI & Agents
Senior Data Engineer, AI & Agents

Appnovation Technologies • Miami (FL)

On-site
USD 140,000 - 190,000
Challenging work
Direct access to AI platforms
Diverse culture
+4
Senior Solutions Architect
Senior Solutions Architect

Appnovation • Miami (FL)

On-site
USD 150,000 - 230,000
Senior Solutions Architect
Senior Solutions Architect

Appnovation • Dallas (TX)

On-site
USD 180,000 - 260,000
Senior Solutions Architect
Senior Solutions Architect

Appnovation • New York (NY)

On-site
USD 140,000 - 190,000
Senior Data Engineer - AI & Agents on Lakehouse/AI Platforms
Senior Data Engineer - AI & Agents on Lakehouse/AI Platforms

Appnovation • Dallas (TX)

On-site
USD 130,000 - 190,000
Challenging work
Cutting-edge AI platforms
Growth opportunities
+3
Full-Stack AI Engineer New York
Full-Stack AI Engineer New York

Appnovation • New York (NY)

On-site
USD 120,000 - 170,000
Health Benefits Package
Mental Health Support
Personal Days Off
+2
Senior Data Engineer, AI Agents & Governed Lakehouse
Senior Data Engineer, AI Agents & Governed Lakehouse

Appnovation Technologies • Miami (FL)

On-site
USD 140,000 - 190,000
Challenging work
Direct access to AI platforms
Diverse culture
+4