Remote Senior Data Engineer - Snowflake & dbt Specialist

Eliassen Group; Montpelier (VT); Remote; USD 101,000 - 162,000; Full time

Benefits offered by this job

Medical benefits

Dental

Vision

401(k) match

Job summary

Eliassen Group is seeking a Senior Data Engineer to own the governed transformation layer end-to-end. You will design and build Snowflake transformation layers, migrate legacy SQL views into versioned, tested dbt models with lineage, and define conformed dimensions across multi-ERP environments.

The role emphasizes modeling standards, CI/CD, and collaboration with BI and AI teams. The position is full-time and remote, with a competitive salary and comprehensive benefits.

Qualifications

• 7+ years in data or analytics engineering
• 4+ years on a cloud data warehouse, preferably Snowflake
• Expert SQL with window functions and tuning
• 3+ years of production dbt experience including macros, tests, and snapshots
• Hands-on Kimball dimensional modeling and SCD Type 1/2
• Experience with at least one ingestion tool (Fivetran, Airbyte, Informatica, Matillion)
• Experience with Git and CI/CD for data using GitHub Actions, Azure DevOps, or GitLab CI
• Proficient Python for data tooling and APIs
• Experience modeling data from ERP systems (Oracle, SAP, MS Dynamics)
• Strong written communication and self-starter in fast-paced environments

Responsibilities

• Design and build Snowflake transformation layer from raw to conformed
• Migrate SQL views to versioned, tested dbt models with lineage
• Define conformed dimensions and operational facts across multi-ERP environments
• Set standards for modeling, testing, naming, documentation, CI/CD
• Partner with report owners to validate semantic equivalence and minimize BI cutover disruption
• Define semantic layer across Snowflake, dbt, and Power BI
• Implement data quality testing and lineage with dbt tests
• Collaborate with AI/analytics teams on feature-table patterns and data foundations
• Support AI/ML, RAG, or agentic workloads from a warehouse layer

Skills

SQL

dbt

Python

Git

CI/CD

Education

Bachelor's degree in Computer Science or related

Tools

Snowflake

Power BI

dbt

Job description

Eliassen Group is seeking a Senior Data Engineer to own the governed transformation layer end-to-end. You will design and build Snowflake transformation layers, migrate legacy SQL views into versioned, tested dbt models with lineage, and define conformed dimensions across multi-ERP environments.

The role emphasizes modeling standards, CI/CD, and collaboration with BI and AI teams. The position is full-time and remote, with a competitive salary and comprehensive benefits.