Lead Data Integration Engineer

We are seeking a Lead Data Integration Engineer to deliver production dbt and Snowflake models powering GTM analytics and AI agents. You will create trusted semantic layers, unify Salesforce and Gong-style interaction data, and prepare datasets for Snowflake Cortex and Snowflake Intelligence.

Responsibilities

• Design and maintain production data models in dbt and Snowflake to measure account health, engagement velocity, and customer intent signals
• Integrate structured records with unstructured interaction data (Gong call transcripts, emails, Salesforce CRM objects, and product usage telemetry) into reliable account-level dimensions
• Define consistent modeling patterns, naming conventions, and metric definitions across GTM datasets
• Implement and operate an enterprise semantic layer (such as the dbt Semantic Layer or MetricFlow) to prevent conflicting metric calculations across business tools
• Prepare clean, context-rich datasets optimized for retrieval, search, and reasoning in Snowflake Cortex, Snowflake Intelligence, and internal AI agents
• Create feature tables and context stores that enable LLM agents for automated meeting prep, competitive intelligence, and account research
• Administer metadata and data enrichment patterns so AI agents correctly interpret account stages, customer sentiment, and relationship history
• Develop automated tests, schema validations, and freshness monitors in dbt for both structured metrics and unstructured data transformations
• Enforce data governance, role-based access controls (RBAC), and audit trails across sensitive sales pipeline and customer interaction data
• Collaborate with Revenue Operations and governance teams to document data lineage and maintain clear dataset ownership
• Contribute within an agile sprint cadence, supporting backlog planning, design reviews, and technical standards
• Deliver self-service data models and documentation so analysts and product teams can query data independently

Requirements

• Proven track record with 5+ years of commercial experience in analytics engineering, data engineering, or data architecture roles
• Expert-level proficiency in advanced SQL, including window functions, CTEs, complex joins, analytical queries, and execution plan optimization
• Extensive hands-on experience with 5+ years of production dbt work, including modular project structure, Jinja macros, custom tests, incremental models, and snapshots
• Solid practical experience with Snowflake, including virtual warehouse sizing, query profile analysis, clustering keys, Time Travel, zero-copy cloning, and access control
• Demonstrated experience modeling B2B SaaS revenue and interaction data (Salesforce CRM, Gong, Marketo, or subscription billing data)
• Deep understanding of Kimball dimensional modeling (star schemas, slowly changing dimensions SCD 1/2/4, conformed dimensions) and semantic layer design
• Daily comfort with Git workflows, branching strategies, code reviews, and automated CI test runs
• Willingness to use AI-assisted development tools (GitHub Copilot, Cursor, Claude Code) to accelerate modeling work, test coverage, and documentation
• English proficiency at B2 (Upper-Intermediate) level or higher

Nice to have

• Working familiarity with Snowflake Cortex AI functions (Cortex Search, LLM functions, embeddings)
• Understanding of vector embeddings, chunking strategies, and retrieval-augmented generation (RAG) for conversational text
• Working knowledge of Python for data manipulation (Pandas), API extraction, or pipeline automation
• Experience with metadata and lineage tools such as Alation, Collibra, DataHub, or dbt Docs
• Background designing self-service data models for Tableau, Looker, or Power BI