Staff Data Engineer

Stack

Responsibilities

• ▹Design, build, and own high-impact data pipelines and platform primitives across ingestion, storage, transformation, and consumption, with Snowflake as the core platform
• ▹Build and evolve the medallion architecture across Bronze, Silver, Gold, and Semantic layers, implementing standards for schema design, object naming, access patterns, and layer boundaries in production
• ▹Ship semantic models representing key business entities, metrics, and KPIs in Snowflake, exposed cleanly to BI tools
• ▹Lead engineering execution across the modern data stack: ingestion through Fivetran, transformation through Coalesce, and BI delivery through Tableau
• ▹Identify and resolve performance, scalability, and cost issues in Snowflake (query optimization, clustering strategy, warehouse sizing, storage management)
• ▹Build platform capabilities that make data AI-ready, including metadata enrichment, contextual retrieval patterns, and curated data products for LLM, RAG, and AI agent use cases
• ▹Implement and enforce data governance in production: naming conventions, data contracts, PII handling, access controls, lineage, and documentation
• ▹Build the data observability practice end to end: freshness monitoring, anomaly detection, pipeline reliability, SLA tracking, incident response

Requirements

• ▹Deep Snowflake expertise
• ▹Strong systems judgment and a track record of shipping production data infrastructure at scale
• ▹Comfortable making pragmatic build-versus-buy calls, writing production dbt or Coalesce transformations, and tuning Snowflake warehouses
• ▹Experience mentoring senior engineers through design reviews

Soft skills

About the company

Apptegy is an education-focused SaaS company building the platform that helps schools communicate, and is building a high-growth data platform under its VP of Data & Analytics.