Data Engineer

System One; Minneapolis (MN); On-site; USD 90,000 - 120,000; Full time

Job summary

System One in Minneapolis, MN is seeking a Data Engineer with 3+ years of experience to build and support a modern data platform on Microsoft SQL Server. You will transform raw data into conformed star schemas to drive BI and reporting.

The role emphasizes multi-layer data pipelines, historical tracking with SCD Type 2, and performance optimization as data volumes grow, with a strong focus on data governance and lineage.

Qualifications

• 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).
• Working knowledge of Kimball dimensional modeling (Star Schemas) and medallion-style layered architecture.
• Hands-on experience building SCD Type 2 dimensions.
• Experience with SSIS and/or Azure Data Factory (or similar ETL/orchestration tools).

Responsibilities

• Build multi-layer data pipelines moving data through Raw, Delta, Conformed and Gold layers.
• Implement historical tracking using SCD Type 2 patterns (EffectiveDate, EndDate, IsCurrent).
• Optimize performance via T-SQL tuning, indexing, and partitioning as data grows.
• Support data governance and lineage standards (audit columns, sentinel records).

Skills

SQL/T-SQL

SCD Type 2

Kimball modeling

ETL/ELT

Tools

SSIS

Azure Data Factory

Azure SQL Database

Git

Job description

Location: Minneapolis, MN
System One is seeking aData Engineer (3+ years)to join a growing team inMinneapolis, MN. In this role, you’ll help build and support a modern data platform inMicrosoft SQL Server, transforming raw and messy data intohigh-performance, conformed star schemasthat 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
• 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)

Location: Minneapolis, MN
System One is seeking aData Engineer (3+ years)to join a growing team inMinneapolis, MN. In this role, you’ll help build and support a modern data platform inMicrosoft SQL Server, transforming raw and messy data intohigh-performance, conformed star schemasthat 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)

• Required qualifications
  • 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

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.

System One is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, age, national origin, disability, family care or medical leave status, genetic information, veteran status, marital status, or any other characteristic protected by applicable federal, state, or local law.