Analytics Engineer – Data Platform

Posted 6hrs ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Analytics Engineer building Snowflake and dbt models for Aline’s senior-living resident lifecycle platform. Creating governed data foundations for BI reporting and AI-driven care outcomes.

Responsibilities:

  • Own and extend dbt models on Snowflake using medallion architecture (bronze/silver/gold) patterns
  • Manage CDC-based ingestion pipelines using Fivetran and similar tools from transactional systems into Snowflake
  • Evolve Snowflake and dbt models into a governed semantic layer for reporting and analytics
  • Build reliable, well-tested gold-layer datasets for BI reporting and downstream AI/agentic workloads
  • Apply star schemas and SCDs to support multi-tenant SaaS reporting
  • Collaborate with data operations, platform engineering, product teams, and others
  • Write dbt tests and documentation
  • Monitor pipeline health and data freshness and build alerting
  • Monitor Snowflake warehouse usage and query performance and tune models and warehouses
  • Work with Product, Sales, and Customer Success stakeholders to translate reporting requests into well-modeled data
  • Support row-level security and data access design for multi-tenant customer data isolation

Requirements:

  • Strong SQL fundamentals and hands-on Snowflake experience
  • Production experience with dbt; building, testing, and maintaining models at scale
  • Experience with CDC pipelines and ELT tools like Fivetran
  • Familiarity with Power BI, ideally including semantic model / measures work
  • Understanding of medallion architecture and how gold-layer data supports both BI and AI use cases
  • Experience working in a multi-tenant SaaS environment strongly preferred
  • Comfortable with git-based version control and CI/CD for analytics code (dbt/SQL changes reviewed and deployed like software)
  • Working knowledge of an orchestration tool (dbt Cloud, Airflow, Dagster, or similar) for scheduling and monitoring pipelines
  • Python for scripting and automation around data workflows
  • Strong communicator who can translate technical modeling decisions for non-technical stakeholders
  • Comfortable in a lean team environment where you may own a problem end-to-end rather than a narrow slice of it
  • Exposure to data ontology/semantic modeling for AI/agentic workloads (bonus)
  • Familiarity with healthcare data privacy considerations, such as HIPAA (bonus)