Data Engineer

SustainableHR PEO & Recruiting

Madison (WI)

Hybrid

USD 90,000 - 110,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

A Madison-based data-driven organization seeks a Data Engineer to design and build production-grade data pipelines and models for reporting and integrations. The ideal candidate has over 3 years of experience with ETL/ELT pipelines, strong skills in Apache Spark and T-SQL, and will collaborate closely with cross-functional teams. This hybrid role requires on-site work as needed, providing an opportunity to play a key role in enhancing data workflows across the organization.

Qualifications

  • 3+ years building and operating production ETL/ELT pipelines.
  • Experience with Apache Spark (Microsoft Fabric, Synapse, or Databricks).
  • Strong skills in T-SQL and Python.

Responsibilities

  • Design and evolve canonical data models and data marts.
  • Build resilient batch and streaming data pipelines.
  • Develop secure data services and APIs.

Skills

Building and operating production ETL/ELT pipelines
Apache Spark
T-SQL
Python
Azure Event Hubs or Kafka
Infrastructure as Code
API design for data services

Tools

Microsoft Fabric
Databricks
Kusto Query Language (KQL)

Job description

SustainableHR PEO & Recruiting provided pay range

This range is provided by SustainableHR PEO & Recruiting. Your actual pay will be based on your skills and experience — talk with your recruiter to learn more.

Base pay range

$90,000.00/yr - $110,000.00/yr

We’re partnering with a Madison-based organization that’s investing heavily in a modern data platform to deliver reliable, scalable, and well-governed data across analytics, applications, and integrations.

This Data Engineer will play a key role in designing and building production-grade data pipelines, models, and services that support Power BI reporting, APIs, and downstream systems. You’ll collaborate closely with Infrastructure, QA, Database Administration, and application teams to deliver automated, observable, and secure data workflows.

This is a hybrid role. Candidates must be located in the Madison, WI area and able to work on-site as needed.

What You’ll Do
  • Design and evolve canonical data models, data marts, and lake/warehouse structures
  • Establish standards for schema design, naming conventions, partitioning, and CDC
  • Build resilient batch and streaming pipelines using Microsoft Fabric Data Factory, Spark notebooks, and Lakehouse tables
  • Design and optimize Delta/Parquet tables in OneLake and Direct Lake models for Power BI
  • Create reusable ingestion and transformation frameworks focused on performance and reliability
Integrations & APIs
  • Develop secure data services and APIs supporting applications, reporting, and partner integrations
  • Define and publish data contracts (OpenAPI/Swagger) with versioning and deprecation standards
  • Partner with DBA and Infrastructure teams to enforce least-privilege access
Infrastructure as Code & DevOps
  • Author and maintain IaC modules using Bicep/ARM (and where appropriate, Terraform or Ansible)
  • Own CI/CD pipelines for data, configuration, and infrastructure changes
  • Collaborate with QA on unit, integration, and regression testing across data workflows
Observability, Reliability & Governance
  • Implement logging, lineage, metrics, and alerting for pipelines and datasets
  • Define SLAs for data freshness and quality
  • Tune Spark performance and manage cloud costs
  • Apply data quality rules, RBAC, sensitivity labeling, and audit standards
  • Work cross-functionally with Infrastructure, QA, DBA, and application teams
  • Contribute to documentation, knowledge sharing, and modern data engineering best practices
What We’re Looking For
Required Experience
  • 3+ years building and operating production ETL/ELT pipelines
  • Apache Spark experience (Microsoft Fabric, Synapse, or Databricks)
  • Strong T-SQL and Python skills
  • Streaming platforms such as Azure Event Hubs or Kafka
  • Change Data Capture (CDC) implementations
  • Infrastructure as Code and CI/CD (Azure DevOps)
  • API design for data services (REST/OpenAPI, versioning, authentication)
Preferred Experience
  • Microsoft Fabric Lakehouse architecture and Power BI Direct Lake optimization
  • Kusto Query Language (KQL), Eventstream, or Eventhouse exposure
  • Experience with data lineage, metadata, or cost governance tools
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer
Data Engineer

Northbound Executive Search • Austin (TX)

On-site
USD 80,000 - 120,000
Data Engineer
Data Engineer

Sago • United States

Remote
USD 90,000 - 140,000
5 Days working
Remote Job
Medical Insurance
Data Engineer Lead
Data Engineer Lead

VSE AVIATION INC (US) • Phoenix (AZ)

On-site
USD 140,000 - 200,000
Data Engineer
Data Engineer

Interactive Resources • United States

On-site
USD 115,000 - 120,000
Medical insurance
Vision insurance
401(k)
Associate Data Engineer
Associate Data Engineer

Baker Tilly Advisory Group, LP • Milwaukee (WI)

On-site
USD 86,000 - 163,000
Data Engineer
Data Engineer

UpRecruit • Los Angeles (CA)

Remote
USD 130,000 - 150,000
Data Engineer Lead
Data Engineer Lead

VSE AVIATION INC (US) • Florida

On-site
USD 130,000 - 190,000
Data Engineer
Data Engineer

Community Choice Credit Union • Jackson (MI)

On-site
USD 75,000 - 91,000
Data Engineer: Modern Data Platform & Pipelines (Hybrid)
Data Engineer: Modern Data Platform & Pipelines (Hybrid)

SustainableHR PEO & Recruiting • Madison (WI)

Hybrid
USD 90,000 - 110,000
Data Engineer - Fleet Operations
Data Engineer - Fleet Operations

Hireart • Foster City (CA)

On-site
USD 78,000 - 110,000
Pre‑tax commuter benefits
Healthcare benefits
FSA for healthcare costs
+2