Remote Senior Data Engineer - Snowflake & dbt Expert

Eliassen Group; Phoenix (AZ); Remote; USD 101,000 - 162,000; Full time

Benefits offered by this job

Medical plans

Dental and vision coverage

401(k) with match

Pre-tax accounts

Life and disability insurance

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 is remote, full-time, with a competitive salary and benefits. You will work hands-on with dbt, SQL, and Python and contribute to CI/CD standards and data quality initiatives.

Qualifications

• Bachelor’s degree or equivalent professional experience.
• 7+ years in data/analytics engineering.
• 4+ years with Snowflake or cloud data warehouse.
• Strong SQL, including window functions and performance tuning.
• 3+ years of production dbt experience with macros, tests, and snapshots.
• Experience with Kimball dimensional modeling patterns.
• Proficiency in Python for data tooling and APIs.
• Experience with ERP data sources (Oracle, SAP, MS Dynamics).
• Strong communication and ability to document standards.

Responsibilities

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

Skills

Snowflake

SQL

Python

dbt

ETL

Data modeling

CI/CD

Power BI

Education

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

Tools

GitHub Actions

Azure DevOps

GitLab CI

Power BI

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 is remote, full-time, with a competitive salary and benefits. You will work hands-on with dbt, SQL, and Python and contribute to CI/CD standards and data quality initiatives.