Remote Senior Data Engineer — Snowflake/dbt AI Layer

Eliassen Group; Boise (ID); Remote; USD 101,000 - 162,000; Full time

Benefits offered by this job

Medical plans

Dental

Vision

401(k) with match

Paid time off

Job summary

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

This is a full-time, permanent role offering a competitive salary and benefits. Remote work is supported, and candidates must be eligible to work on a W2 basis.

Qualifications

• 7+ years in data or analytics engineering.
• 4+ years on a cloud data warehouse, preferably Snowflake.
• Proficient SQL including window functions and performance tuning.
• 3+ years of production dbt experience with tests and snapshots.
• Experience with ERP data modeling (e.g., SAP/Oracle) is a plus.

Responsibilities

• Design and build Snowflake transformation layer from raw to conformed data.
• Migrate SQL views to versioned dbt models with full lineage.
• Define conformed dimensions and operational facts across multi-ERP environments.
• Set modeling, testing, naming, documentation, and CI/CD standards.
• Partner with report owners to validate semantic equivalence during BI cutovers.
• Define semantic layer across Snowflake, dbt, and Power BI.
• Implement data quality tests and lineage, aligning with SOX controls.

Skills

SQL expertise

Python scripting

Data modeling

Self-starter

Education

Bachelor’s degree in Computer Science, Information Systems, Data Engineering

Tools

Snowflake

dbt

GitHub Actions

Job description

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

This is a full-time, permanent role offering a competitive salary and benefits. Remote work is supported, and candidates must be eligible to work on a W2 basis.