About The Position

Analytics Engineers combine insurance domain expertise with full-stack data and analytics engineering capabilities to build the data foundations that power Snowflake's AI platform. The role focuses on making AI reliable through clean, well-modeled data, governed pipelines, and semantic models that expose business meaning to natural language interfaces. The engineer designs data models, builds pipelines, and constructs the semantic layer between raw data and AI agents, ensuring data is structured, trusted, and agent-ready. Deployment patterns and data-model gaps identified in the work are fed back to line-of-business teams. The position owns the full data stack, from source ingestion to semantic layer, and ensures each layer is clean, tested, production-ready, and maintainable by run teams. It involves working directly with clients, engineers, and AI specialists to help financial institutions and other clients adopt AI and achieve measurable business outcomes.

Requirements

  • At least 8 years of experience in analytics engineering, data engineering, or a related technical role, with some customer-facing or cross-functional experience.
  • Daily use of an AI coding assistant as a primary development tool.
  • Advanced SQL proficiency, including CTEs, window functions, complex joins, and incremental pipeline patterns.
  • Experience building large-scale relational data infrastructure, with strong pipeline design, quality assurance, and testing skills from ingestion through semantic layer.
  • Experience building and maintaining dbt projects, including testing, documentation, and CI/CD pipelines.
  • Modern Python skills, including writing type-hinted, readable code and understanding Python-based data pipelines and automation workflows.
  • Ability to write semantic view configurations or structured skill files that handle edge cases and encode sufficient domain knowledge for reliable model behavior.
  • Proficiency with Snowflake Cortex, including Cortex Analyst, Cortex Agents, Cortex Search, semantic views, and Dynamic Tables.
  • Ability to communicate technical work clearly to business leaders and serve as a bridge between Snowflake AI capabilities and customer needs.
  • Experience shipping production data models or pipelines relied on by non-technical business users.
  • Comfort with Git workflows, including pull requests, branches, and code review.
  • Demonstrable experience translating business requirements into technical specifications.
  • No H1B visa sponsorship is offered.

Nice To Haves

  • Experience with Airflow or other orchestration frameworks.
  • Familiarity with enterprise business systems such as ERP, CRM, or HRIS.

Responsibilities

  • Architect flexible, performant data models that help line-of-business teams establish single sources of truth across their business domains.
  • Use SQL, Python, dbt, and Snowflake to build and maintain data infrastructure for reporting, analysis, and automation.
  • Perform data quality assurance and develop automated testing procedures for Snowflake data models.
  • Provide input into data governance strategies, including permissions, data lineage, and data definitions.
  • Design data security so that models only have access to authorized data.
  • Build semantic data models that expose line-of-business data to natural-language queries via Cortex Analyst.
  • Define and validate the metrics, dimensions, and relationships AI agents need to reason correctly over line-of-business data.
  • Identify and resolve gaps in data structure, naming, and coverage that could cause an agent to fail or produce incorrect results.
  • Create documented playbooks, reusable data-model templates, and maintainable, extendable semantic-model libraries.
  • Run technical workshops to upskill team members.
  • Author semantic view configurations and skill files using YAML and Markdown so non-technical analysts can invoke them in plain English.
  • Track adoption after go-live, identify stall points, and re-engage until data products are reliable and can be handed over to run teams.
  • Translate customer requirements into prototypes, gather feedback, and iterate.
  • Distill deployment issues into actionable feedback for leaders, explaining root causes and suggesting fixes.
  • Work directly with clients, engineers, and AI specialists to turn emerging technology into measurable business outcomes.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service