Data Platform Analytics Engineer — Snowflake/dbt

Aline; United States; On-site; USD 120,000 - 160,000; Full time

Job summary

Aline is building a resident lifecycle platform for senior living. We’re seeking a Data Platform Engineer to own dbt models on Snowflake, manage CDC pipelines, and expand the semantic modeling layer for BI and AI workloads across multi-tenant SaaS environments.

You’ll collaborate with cross-functional teams to ensure data reliability, governance, and scalable analytics. Expect a fast-paced, lean team focusing on impactful data foundations.

Qualifications

• Strong SQL fundamentals and Snowflake experience.
• Production dbt experience: building, testing, and maintaining models at scale.
• Hands-on with CDC pipelines and ELT tools like Fivetran.
• Familiarity with Power BI including semantic models/measures.
• Understanding medallion architecture and multi-tenant SaaS reporting needs.
• Git-based version control and CI/CD for analytics code.
• Experience with orchestration tools (dbt Cloud, Airflow, Dagster).
• Proficiency in Python for scripting data workflows.
• Ability to communicate modeling decisions to non-technical stakeholders.
• Bonus: data ontology/semantic modeling for AI workloads; HIPAA privacy considerations a plus.

Responsibilities

• Own and extend dbt models on Snowflake following medallion patterns.
• Manage CDC-based ingestion pipelines landing data into Snowflake.
• Broaden Snowflake/dbt models to serve as semantic layer for BI/AI.
• Build reliable gold-layer datasets supporting BI and AI workloads.
• Apply star schemas and SCDs for multi-tenant SaaS reporting needs.
• Collaborate with data operations, platform engineering, product, and others.
• Write dbt tests and documentation for trustworthy models.
• Monitor pipeline health, data freshness, and alerting.
• Optimize Snowflake warehouses and query performance as data grows.
• Work with Product/Sales/CS to turn reporting requests into models.
• Support row-level security and proper data isolation.

Skills

SQL fundamentals

Snowflake

dbt

CDC/ELT pipelines

Power BI

Python

Git / CI/CD

data modeling

communication

multi-tenant SaaS experience

Tools

Snowflake

dbt Cloud

Airflow

Fivetran

Power BI

Job description

Aline is building a resident lifecycle platform for senior living. We’re seeking a Data Platform Engineer to own dbt models on Snowflake, manage CDC pipelines, and expand the semantic modeling layer for BI and AI workloads across multi-tenant SaaS environments.

You’ll collaborate with cross-functional teams to ensure data reliability, governance, and scalable analytics. Expect a fast-paced, lean team focusing on impactful data foundations.