Senior Data Engineer — Remote (Snowflake, dbt, Python)

Eliassen Group; Lansing (MI); Remoto; USD 101.000 - 162.000; Tempo pieno

Vantaggi offerti da questo lavoro

Medical insurance

Dental insurance

Vision insurance

401(k) with match

Life insurance

Disability insurance

Sick time as required by law

Descrizione del lavoro

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 to unify multi-ERP environments.

The role emphasizes modeling standards, CI/CD, and collaboration with BI teams to ensure semantic consistency across Snowflake, dbt, and Power BI.

Competenze

• 7+ years in data or analytics engineering with 4+ years on a cloud data warehouse.
• Expert SQL including window functions, performance tuning, and incremental load patterns.
• 3+ years of production dbt experience, including macros, tests, and documentation.
• Hands-on Kimball dimensional modeling with star schemas and SCD Type 1/2.
• Experience with at least one ingestion tool (Fivetran, Airbyte, Informatica, or Matillion) and one orchestrator (dbt Cloud, Airflow, Dagster, or Azure Data Factory).
• Git and CI/CD for data using GitHub Actions, Azure DevOps Pipelines, or GitLab CI with code review.

Mansioni

• 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, and release management.
• Partner with report owners to validate semantic equivalence and minimize BI cutover disruption.
• Define and own the semantic layer across Snowflake, dbt, and Power BI for consistent metrics.
• Implement data quality testing, observability, and lineage with dbt tests and related tools.
• Design models for AI/ML and agent readiness with stable keys and metadata for LLM retrieval.

Conoscenze

SQL

dbt

Python

Snowflake

Data Modeling

ETL/ELT

Git & CI/CD

Power BI

Formazione

Bachelor's degree

Strumenti

Snowflake

Power BI

dbt Cloud

GitHub Actions

Azure DevOps

Descrizione del lavoro

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 to unify multi-ERP environments.

The role emphasizes modeling standards, CI/CD, and collaboration with BI teams to ensure semantic consistency across Snowflake, dbt, and Power BI.