Remote Senior Data Engineer - Snowflake/dbt Architect

Eliassen Group; Dover (DE); Remote; USD 101,000 - 162,000; Full time

Job summary

Eliassen Group is seeking a Senior Data Engineer to own the governed transformation layer end-to-end. The role focuses on Snowflake transformations, migrating legacy SQL views into versioned dbt models with lineage, and defining conformed dimensions for multi-ERP environments.

The position will establish modeling standards, testing, documentation, and CI/CD practices. Hands-on work with dbt, SQL, and Python is required in a remote, permanent role.

Qualifications

• 7+ years in data or analytics engineering
• 4+ years on a cloud data warehouse, preferably Snowflake
• 3+ years of production dbt experience
• Hands-on Kimball dimensional modeling with star schemas
• Experience with ERP data sources (Oracle, SAP, MS Dynamics)

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, and release management.
• Partner with report owners to validate semantic equivalence and minimize BI cutover disruption.

Skills

Snowflake

dbt

SQL

Python

ETL

CI/CD

Education

Bachelor's degree in Computer Science or related field

Tools

Power BI

Git

dbt Cloud

Job description

Eliassen Group is seeking a Senior Data Engineer to own the governed transformation layer end-to-end. The role focuses on Snowflake transformations, migrating legacy SQL views into versioned dbt models with lineage, and defining conformed dimensions for multi-ERP environments.

The position will establish modeling standards, testing, documentation, and CI/CD practices. Hands-on work with dbt, SQL, and Python is required in a remote, permanent role.