Senior Data Engineer: Snowflake + dbt (Remote)

Eliassen Group; City of Albany (NY); Remote; USD 101,000 - 162,000; Full time

Benefits offered by this job

medical plans

dental

vision

401(k) with match

life and disability insurance

sick time

Job summary

Eliassen Group is seeking a Senior Data Engineer to own the governed transformation layer end-to-end, building Snowflake pipelines and versioned dbt models with full lineage. You will define conformed dimensions and operational facts to unify multi-ERP environments, while establishing modeling standards and CI/CD practices.

The role involves working hands-on with dbt, SQL, and Python to support BI cutovers, data quality, and AI/ML readiness.

Qualifications

• 7+ years in data or analytics engineering.

Responsibilities

• Design and build the Snowflake transformation layer from raw to staging to conformed to marts as the governed foundation for reporting and AI/ML.
• Migrate existing SQL views to versioned, tested dbt models with full lineage.
• Define conformed dimensions and operational facts across multi-ERP environments using Kimball principles.
• Set standards for modeling, testing, naming, documentation, CI/CD, Git workflows, code review, dbt project structure, model contracts, and release management.
• Partner with report owners to validate semantic equivalence and minimize disruption during BI cutovers.
• Define and own the semantic layer across Snowflake, dbt, and Power BI to ensure consistent metrics.
• Implement data quality testing, observability, and lineage with dbt tests and equivalent tools, partnering with IT Audit on SOX controls.
• Design models for AI/ML and agent readiness with stable keys, clear semantics, and metadata for LLM retrieval and tool use.
• Collaborate with AI/analytics teams on feature-table patterns and data foundations for agentic applications.

Skills

SQL

Python

dbt

Data modeling

Git & CI/CD

Data quality

Communication

Self-starter

AI/ML readiness

Snowflake

Education

Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field

Tools

Snowflake

dbt

Power BI

GitHub Actions

Azure DevOps Pipelines

GitLab CI

Fivetran

Airbyte

Informatica

Matillion

Airflow

Dagster

Azure Data Factory

Job description

Eliassen Group is seeking a Senior Data Engineer to own the governed transformation layer end-to-end, building Snowflake pipelines and versioned dbt models with full lineage. You will define conformed dimensions and operational facts to unify multi-ERP environments, while establishing modeling standards and CI/CD practices.

The role involves working hands-on with dbt, SQL, and Python to support BI cutovers, data quality, and AI/ML readiness.