Remote Senior Data Engineer - Snowflake & dbt Expert

Eliassen Group; Augusta (ME); 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. You will design and build Snowflake transformation layers, migrate legacy SQL views, and define conformed dimensions to unify multi-ERP environments.

This full-time, remote role offers a competitive salary and comprehensive benefits. The position emphasizes hands-on work with dbt, SQL, and Python, shaping modeling standards, CI/CD, and data quality across the analytics stack.

Qualifications

• 7+ years in data or analytics engineering with 4+ years on a cloud data warehouse.
• Expert SQL with window functions and performance tuning.
• 3+ years of production dbt experience with tests/snapshots and documentation.
• Hands-on Kimball dimensional modeling with star schemas and SCD concepts.

Responsibilities

• Design and build the Snowflake transformation layer from raw to staging to conformed to marts.
• Migrate existing 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, and code review.
• Partner with report owners to validate semantic equivalence during BI cutovers.
• Define semantic layer across Snowflake, dbt, and Power BI.

Skills

Advanced SQL

dbt expertise

Kimball dimensional modeling

Cloud data warehouse (Snowflake)

ETL tools (Fivetran/Airbyte)

Git & CI/CD for data

Python for data tooling

ERP data modeling

Written communication

Self-starter / fast-paced

Education

Bachelor's degree in CS/IS/Data Eng

Tools

Snowflake

dbt

Power BI

GitHub Actions

Azure DevOps

Airflow

Dagster

dbt Cloud

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, and define conformed dimensions to unify multi-ERP environments.

This full-time, remote role offers a competitive salary and comprehensive benefits. The position emphasizes hands-on work with dbt, SQL, and Python, shaping modeling standards, CI/CD, and data quality across the analytics stack.