Data Engineer

System One delivers outsourced services and workforce solutions across North America. The company is seeking a Data Engineer to build and support a modern Microsoft SQL Server data platform, developing layered pipelines, conformed star schemas, historical tracking, performance optimizations, and data governance standards.

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)

Preferred

• Experience with hybrid sources (flat files, APIs, SQL databases)
• Familiarity with Git/version control for database scripts
• Exposure to Azure SQL Database
• Flat Files
• APIs
• SQL Databases
• Git
• Version Control
• Database Scripting
• Azure SQL Database

Benefits

• Eligible employees have health and welfare benefits coverage options including medical, dental, vision, spending accounts, life insurance, and voluntary plans.
• Eligible employees may participate in a 401(k) plan.

Company

• Specialized technical staffing, recruiting, and outsourced workforce solutions.
• Pittsburgh, Pennsylvania, USA
• http://www.systemoneservices.com/
• Founded in 2008
• 5001-10000 employees

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)
• Experience with hybrid sources (flat files, APIs, SQL databases)
• Familiarity with Git/version control for database scripts
• Exposure to Azure SQL Database

Required skills

• Microsoft SQL Server, T-SQL, Kimball Dimensional Modeling, Star Schema Design, Medallion-Style Layered Data Architecture, Slowly Changing Dimension (SCD) Type 2, SSIS, Azure Data Factory, ETL/Orchestration, Git, Azure SQL Database

Preferred skills

• Familiarity with Git/version control for database scripts, Exposure to Azure SQL Database

Experience

• 2+ years