Senior Data Engineer - Snowflake/dbt Expert (Remote)

Eliassen Group; Santa Fe (NM); A distancia; USD 101.000 - 162.000; Jornada completa

Descripción de la vacante

Eliassen Group is seeking a Senior Data Engineer to own the governed data transformation layer end-to-end. You will design Snowflake transformations, migrate legacy SQL views to versioned dbt models, and define conformed dimensions across multi-ERP environments.

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

Formación

• 7+ years in data or analytics engineering.
• Experience with cloud data warehouses, preferably Snowflake.
• Hands-on dbt development with macros, tests, snapshots, and incremental loads.
• Production experience with at least one ingestion tool (Fivetran, Airbyte, Informatica, or Matillion) and one orchestrator (dbt Cloud, Airflow, Dagster, or Azure Data Factory).
• Hands-on Git and CI/CD for data using modern CI/CD tools.
• Proficient Python for data tooling and automation.
• Experience modeling data from at least one ERP (Oracle, SAP S/4HANA, SAP ECC, or Microsoft Dynamics).
• Strong written communication for standards, runbooks, and documentation.

Responsabilidades

• 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, 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.
• Collaborate with AI/analytics teams on feature-table patterns and data foundations for agentic apps.

Conocimientos

SQL

Python

dbt

Snowflake

Dimensional modeling

Git & CI/CD

ERP systems knowledge

Educación

Bachelor’s degree in Computer Science or related field

Herramientas

Fivetran

Airbyte

Informatica

Matillion

dbt Cloud

Airflow

Dagster

Azure Data Factory

GitHub Actions

Azure DevOps Pipelines

GitLab CI

Power BI

Descripción del empleo

Eliassen Group is seeking a Senior Data Engineer to own the governed data transformation layer end-to-end. You will design Snowflake transformations, migrate legacy SQL views to versioned dbt models, and define conformed dimensions across multi-ERP environments.

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