> Markdown version of [/jobs/ext/3995319-data-engineer](https://www.wearedevelopers.com/jobs/ext/3995319-data-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Engineer

- **Company:** System One
- **Location:** Minneapolis, MN, United States
- **Experience:** Experienced
- **Contract:** Permanent contract
- **Skills:** Application Programming Interfaces (APIs), Business Logic, Databases, Data Architecture, Information Engineering, Data Governance, Data Infrastructure, Extract Transform Load (ETL), Dimensional Modeling, Microsoft SQL Server, SQL Azure, SQL Databases, SQL Server Integration Services, Transact-SQL, Workflow Management Systems, Azure Data Factory, Database Optimization, Git, Semi-structured Data, Star Schema, Software Version Control, Data Pipelines
- **Published:** October 28, 2026
- **Apply:** https://www.thejobnetwork.com/job/1208d5ce-fe59-4858-8536-df7c0b92708f/data-engineer

## About the Role

* 2-4 years of experience in a Data Engineering / BI Developer type role
 * Strong MS SQL Server / T-SQL skills (CTEs, window functions, MERGE statements, etc.)
 * Working knowledge of Kimball dimensional modeling (Star Schemas) and medallion-style layered data architecture
 * Hands-on experience building SCD Type 2 dimensions
 * Experience with SSIS and/or Azure Data Factory (ADF) (or similar ETL/orchestration tools)

Preferred qualifications

 * Experience with hybrid sources (flat files, APIs, SQL databases)
 * Familiarity with Git/version control for database scripts
 * Exposure to Azure SQL Database

## Description

Location: Minneapolis, MN System One is seeking a Data Engineer (3+ years) to join a growing team in Minneapolis, MN. In this role, you'll help build and support a modern data platform in Microsoft SQL Server, transforming raw and messy data into high-performance, conformed star schemas that drive business intelligence and reporting Responsibilities:

 * Build multi-layer data pipelines moving data through:
 + Raw layer: ingest structured/semi-structured data from multiple sources
 + Delta layer: cleanse, deduplicate, and standardize data
 + Conformed layer: apply consistent business logic to create enterprise "sources of truth"
 + Gold layer (Star Schema): create optimized Fact and Dimension tables for reporting
 * Implement historical tracking using SCD Type 2 patterns (EffectiveDate, EndDate, IsCurrent, etc.)
 * Optimize performance (T-SQL tuning, indexing strategies, partitioning approaches) as data volume grows
 * Support data governance and lineage standards (sentinel "-1" records, audit columns like InsertDate/UpdateDate), System One, and its subsidiaries including Joulé and Mountain Ltd., are leaders in delivering outsourced services and workforce solutions across North America. We help clients get work done more efficiently and economically, without compromising quality. System One not only serves as a valued partner for our clients, but we offer eligible employees health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, voluntary plans, as well as participation in a 401(k) plan.