Lead Data Integration Engineer

We are seeking aLead Data Integration Engineer to lead analytics engineering and data modeling that turns raw interaction and telemetry data into trusted, consistent account datasets for decision-making and AI-enabled workflows. You will partner with cross-functional teams to deliver governed, self-service data products in Snowflake and dbt.

Responsibilities

• Lead analytics engineering delivery for integrated account-level datasets across interaction and telemetry sources
• Design dimensional models and semantic definitions that standardize account health, engagement, and intent metrics
• Build dbt models in Snowflake that transform structured and unstructured inputs into consistent dimensions and facts
• Establish naming conventions, modeling patterns, and shared metric logic to prevent conflicting calculations
• Create datasets optimized for retrieval and reasoning to support AI agent workflows and search use cases
• Develop feature tables and context stores that enable automated meeting preparation and account research
• Implement dbt tests, schema validations, and freshness monitoring to improve reliability and trust
• Define governance controls including RBAC and auditability for sensitive pipeline and interaction data
• Coordinate documentation, lineage, and ownership with operations and governance partners
• Deliver self-service models and clear docs so analysts and product teams can query independently
• Contribute to sprint planning, design reviews, and technical standards to ensure consistent execution
• Use AI-assisted development tools to accelerate modeling, testing, and documentation work

Requirements

• 5+ years analytics engineering or data engineering experience
• Data modeling experience for BI analytics and dimensional schemas
• Strong leadership skills to define modeling standards and guide reviews
• Strong project delivery skills in agile sprint cadences and backlog planning
• Advanced SQL skills with CTEs, window functions, complex joins, and performance tuning
• Strong dbt skills with modular projects, Jinja macros, custom tests, incremental models, and snapshots
• Strong Snowflake skills including warehouse sizing, query profiling, clustering, Time Travel, and access control
• Hands-on Git skills with branching, code reviews, and CI test runs
• Strong stakeholder collaboration skills with analytics and operations partners
• Upper-Intermediate English proficiency (B2)

Nice to have

• Snowflake Cortex experience with search, LLM functions, or embeddings
• RAG applications development knowledge including chunking and retrieval strategies
• Python for data analytics skills such as Pandas and automation scripting
• Data governance tooling familiarity for metadata, lineage, and cataloging
• BI analytics and visualization experience designing models for Tableau, Looker, or Power BI