← Back to jobsJob ID col-cmwpb8jch09amd8happrp7936

Eliassen GroupPosted 1 day ago

Senior Data EngineerNew

Full-time
Remote
7+ years
$101K – $162K/yr
Posted 1 day ago

Eliassen Group is recruiting for an unnamed client seeking a Senior Data Engineer. The role owns the governed transformation layer, building Snowflake and dbt models, establishing data modeling and delivery standards, and supporting reporting, AI/ML, and agentic applications.

Posted
1 day ago
Source
linkedin.com
Sector
Information Technology & AI

Opens the employer's application page in a new tab

Responsibilities

  • 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 including star schemas, surrogate keys, fact grain, and SCD Type 1 and Type 2
  • Set standards for modeling, testing, naming, documentation, CI/CD, Git workflows, code review, dbt project structure, model contracts, and release management
  • Partner with report owners to validate semantic equivalence and minimize disruption during BI cutovers
  • Define and own the semantic layer across Snowflake, dbt, and Power BI to ensure consistent metrics
  • Implement data quality testing, observability, and lineage with dbt tests and equivalent tools, partnering with IT Audit on SOX-relevant controls
  • Design models for AI/ML and agent readiness with stable keys, clear semantics, and metadata for LLM retrieval and tool use
  • Collaborate with AI/analytics teams on feature-table patterns, golden-record exposure, and data foundations for agentic applications

Qualifications

  • Qualified applicants must be willing and able to work on a w2 basis
  • 7+ years in data or analytics engineering with 4+ years on a cloud data warehouse, preferably Snowflake
  • Expert SQL including window functions, performance tuning, and incremental load patterns
  • 3+ years of production dbt experience, including macros, tests, snapshots, incremental strategies, exposures, and documentation
  • Experience designing and maintaining a dbt project from scratch
  • Hands-on Kimball dimensional modeling with star schemas, conformed dimensions, surrogate keys, and SCD Type 1 and Type 2
  • Production experience with at least one ingestion tool such as Fivetran, Airbyte, Informatica, or Matillion and one orchestrator such as dbt Cloud, Airflow, Dagster, or Azure Data Factory
  • Hands-on Git and CI/CD for data using GitHub Actions, Azure DevOps Pipelines, or GitLab CI with code review and release practices
  • Proficient Python for data tooling including dbt macros, automation, data quality frameworks, and lightweight APIs
  • Experience modeling data from at least one enterprise ERP such as Oracle, SAP S/4HANA, SAP ECC, or Microsoft Dynamics
  • Strong written communication for standards, runbooks, and documentation
  • Self-starter effective in a fast-paced multi-ERP environment with minimal supervision
  • Experience supporting AI/ML, RAG, or agentic workloads from a warehouse layer
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field. Equivalent professional experience considered

Preferred

  • Preferred: Table-level experience with SAP ECC or S/4HANA finance and logistics tables, Power BI semantic models and DAX, regulated industry background, SOX ITGC familiarity, and exposure to MDM tooling
  • Power BI Semantic Models
  • Regulated Industry Experience

Required skills

DAXGit and CI/CDKimball Dimensional ModelingPower BIPythonSQLSnowflakedbt

Full job description

Eliassen Group is recruiting for an unnamed client seeking a Senior Data Engineer. The role owns the governed transformation layer, building Snowflake and dbt models, establishing data modeling and delivery standards, and supporting reporting, AI/ML, and agentic applications.

Responsibilities

  • 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 including star schemas, surrogate keys, fact grain, and SCD Type 1 and Type 2
  • Set standards for modeling, testing, naming, documentation, CI/CD, Git workflows, code review, dbt project structure, model contracts, and release management
  • Partner with report owners to validate semantic equivalence and minimize disruption during BI cutovers
  • Define and own the semantic layer across Snowflake, dbt, and Power BI to ensure consistent metrics
  • Implement data quality testing, observability, and lineage with dbt tests and equivalent tools, partnering with IT Audit on SOX-relevant controls
  • Design models for AI/ML and agent readiness with stable keys, clear semantics, and metadata for LLM retrieval and tool use
  • Collaborate with AI/analytics teams on feature-table patterns, golden-record exposure, and data foundations for agentic applications

Preferred

  • Preferred: Table-level experience with SAP ECC or S/4HANA finance and logistics tables, Power BI semantic models and DAX, regulated industry background, SOX ITGC familiarity, and exposure to MDM tooling
  • SAP ECC Tables
  • S/4HANA Finance Tables
  • S/4HANA Logistics Tables
  • Power BI Semantic Models
  • DAX
  • Regulated Industry Experience
  • SOX ITGC
  • MDM Tooling

Benefits

  • Remote

Company

  • Strategic consulting in technology, business advisory, and life sciences.
  • North Reading, Massachusetts, USA
  • http://www.eliassen.com/
  • Founded in 1989
  • 1001-5000 employees

Qualifications

  • Qualified applicants must be willing and able to work on a w2 basis
  • 7+ years in data or analytics engineering with 4+ years on a cloud data warehouse, preferably Snowflake
  • Expert SQL including window functions, performance tuning, and incremental load patterns
  • 3+ years of production dbt experience, including macros, tests, snapshots, incremental strategies, exposures, and documentation
  • Experience designing and maintaining a dbt project from scratch
  • Hands-on Kimball dimensional modeling with star schemas, conformed dimensions, surrogate keys, and SCD Type 1 and Type 2
  • Production experience with at least one ingestion tool such as Fivetran, Airbyte, Informatica, or Matillion and one orchestrator such as dbt Cloud, Airflow, Dagster, or Azure Data Factory
  • Hands-on Git and CI/CD for data using GitHub Actions, Azure DevOps Pipelines, or GitLab CI with code review and release practices
  • Proficient Python for data tooling including dbt macros, automation, data quality frameworks, and lightweight APIs
  • Experience modeling data from at least one enterprise ERP such as Oracle, SAP S/4HANA, SAP ECC, or Microsoft Dynamics
  • Strong written communication for standards, runbooks, and documentation
  • Self-starter effective in a fast-paced multi-ERP environment with minimal supervision
  • Experience supporting AI/ML, RAG, or agentic workloads from a warehouse layer
  • Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related quantitative field. Equivalent professional experience considered
  • Preferred: Table-level experience with SAP ECC or S/4HANA finance and logistics tables, Power BI semantic models and DAX, regulated industry background, SOX ITGC familiarity, and exposure to MDM tooling
  • 3+ years of production dbt experience, including macros, tests, snapshots, incremental strategies, exposures, and documentation.

Required skills

  • AI/ML, RAG, and agentic workloads, DAX, Fivetran, Airbyte, Informatica, or Matillion, Git and CI/CD, Git and CI/CD Azure DevOps Pipelines, Git and CI/CD GitHub Actions, Git and CI/CD GitLab CI, Kimball Dimensional Modeling, Oracle, SAP S/4HANA, SAP ECC, or Microsoft Dynamics, Power BI, Python, SQL, Snowflake, dbt, dbt Cloud, Airflow, Dagster, or Azure Data Factory

Experience

  • 7+ years

Job details

Employment type

Full-time

Seniority level

7+ years

Date posted

Nov 20, 2026

Work mode

Remote

Job source

linkedin.com

Company

Eliassen Group

Information Technology & AI

Strategic consulting in technology, business advisory, and life sciences.

See all 36 jobs from Eliassen Group →
  • North Reading, Massachusetts, USA
  • Information Technology & AI
  • 1001-5000 employees
  • Founded 1989
  • eliassen.com

Similar jobs

Matched on role, skills and location · live jobs only

See more Data Engineer jobs

First Citizens Bank

1d ago

New

Senior Data Engineer - ETL/ELT (Remote - NC, AZ, TX, FL)

Full-timeRemoteUnited StatesCompetitive

First Citizens Bank is hiring a Senior Data Engineer to implement, enhance, and support data pipelines and platform capabilities within established architectural patterns.

Why similarSame rolePythonSQL

Coinbase

1d ago

New

Senior Software Engineer, Data Engineering Platform

Full-timeRemoteUnited States$186K – $219K/yr

Coinbase is hiring a Senior Software Engineer for its Data Platform team. The role builds and maintains SDKs, self-service applications, reusable abstractions, and security and observability tooling that help internal teams create, manage, and use data…

Why similarSame rolePythonSQL

Spring Health

1d ago

New

Senior GTM Data Engineer

Full-timeRemoteUnited States$159K – $175K/yr

Spring Health is hiring a Senior GTM Data Engineer to build and maintain the integrated data infrastructure supporting go-to-market analytics, automation, and AI agents.

Why similarSame roleSQLSnowflake

Get new Data Engineer jobs by email

Create job alert

Senior Data Engineer

Eliassen Group · $101K – $162K/yr

Apply on company site