Remote Snowflake Data Engineer - DBT & AI Readiness

Eliassen Group; Frankfort (KY); Remote; USD 101,000 - 162,000; Full time

Benefits offered by this job

Medical plan

Dental plan

Vision plan

401(k) with match

Sick time

Job summary

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

Establish modeling, testing, naming, documentation, and CI/CD standards; work hands-on with dbt, SQL, and Python. The role is full-time and remote, offering 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 performance tuning
• 3+ years production dbt experience with tests, snapshots, and docs
• Hands-on Kimball dimensional modeling (star schemas, SCD 1/2)
• Experience with data ingestion tools (Fivetran, Airbyte, Informatica, Matillion)
• Experience with orchestration tools (dbt Cloud, Airflow, Dagster, Azure Data Factory)
• Git and CI/CD for data (GitHub Actions, Azure DevOps, GitLab)
• Proficient Python for data tooling and automation
• ERP experience (Oracle, SAP S/4HANA, SAP ECC, Microsoft Dynamics)
• Strong written communication and documentation
• Self-starter in fast-paced multi-ERP environments
• Experience supporting AI/ML, RAG, or agentic workloads

Responsibilities

• Design and build the Snowflake transformation layer (raw to staging to conformed to 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, CI/CD, and releases
• Collaborate with report owners to validate semantic equivalence during BI cutovers
• Define and own semantic layer across Snowflake, dbt, and Power BI for consistent metrics
• Implement data quality testing, observability, and lineage with dbt tests
• Design models for AI/ML and agent readiness with stable keys and metadata
• Collaborate with AI/analytics teams on feature patterns and golden-record exposure

Skills

SQL

Snowflake

dbt

Dimensional modeling

Python

Git & CI/CD

ETL tools

ERP systems

Power BI

Technical writing

Education

Bachelor's degree in Computer Science or related

Tools

dbt Cloud

Airflow

Dagster

Azure Data Factory

GitHub Actions

Azure DevOps Pipelines

GitLab CI

Job description

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

Establish modeling, testing, naming, documentation, and CI/CD standards; work hands-on with dbt, SQL, and Python. The role is full-time and remote, offering a competitive salary and comprehensive benefits.