Data Engineer

Detroit Pistons•Detroit, MI

About The Position

The Data Engineer is a key member of the Detroit Pistons Business Strategy & Analytics department, responsible for developing, maintaining, and optimizing data infrastructure that supports business reporting, analytics, fan engagement, revenue generation, and operational decision-making across the organization. The role supports the existing Microsoft SQL Server data warehouse while helping advance the organization’s transition to a modern data Lakehouse methodology using Microsoft Fabric. The Data Engineer works closely with the Senior Director of Data Strategy & Reporting on the department’s data architecture, governance, reporting, and integration roadmap.

Requirements

At least 4 years of professional experience in data engineering, database development, business intelligence, data warehousing, or a related data role.
Experience working in a Microsoft data environment.
Strong proficiency with Microsoft SQL Server and MS SQL data warehouse environments.
Advanced T-SQL skills, including stored procedures, views, joins, indexing, query optimization, and data modeling.
Experience building ETL/ELT pipelines from multiple structured and semi-structured data sources.
Strong understanding of data warehouse concepts, dimensional modeling, star schemas, data marts, and modern lakehouse methodologies.
Ability to translate business needs into scalable data engineering solutions.
Ability to manage multiple priorities and deliver high-quality work in a fast-paced environment.

Nice To Haves

A bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field is preferred.
Familiarity with Microsoft Fabric, Azure Data Factory, Power BI, Azure SQL, Azure Data Lake, Synapse, or related Microsoft data tools.
Experience with Python, PySpark, Spark SQL, or other modern data engineering languages and frameworks.
Familiarity with preparing data for AI applications, including data quality, metadata, and secure access.

Responsibilities

Develop, maintain, and optimize data pipelines, data models, database objects, and integration processes within a Microsoft-based data environment.
Assist in transitioning from a traditional data warehouse structure to a modern data lakehouse methodology using Microsoft Fabric.
Build scalable ETL/ELT processes to ingest, transform, validate, and deliver data for reporting, analytics, and business intelligence.
Support the design and implementation of Microsoft Fabric components, including OneLake, Lakehouse, Warehouse, Data Factory pipelines, Dataflows Gen2, notebooks, and Power BI integration.
Support implementation of data governance standards, data quality processes, and enterprise data best practices.
Develop and maintain data validation rules, reconciliation processes, and data quality checks across critical business datasets.
Ensure data accuracy, consistency, integrity, privacy, and reliability across source systems, data warehouse objects, lakehouse assets, and reporting outputs.
Prepare reliable, documented, and governed data assets for reporting, analytics, automation, and AI applications.
Support Power BI datasets, semantic models, dataflows, and reporting infrastructure as needed.
Partner with analysts and business stakeholders to ensure data models meet business requirements, reporting standards, and performance expectations.
Integrate data from multiple internal and external systems into the organization’s data warehouse, data lakehouse, and analytics environment.
Work with APIs, flat files, relational databases, SaaS platforms, and cloud-based systems to ensure reliable data ingestion and availability.
Monitor pipeline health, investigate failures, and implement long-term solutions to improve reliability and reduce operational risk.
Maintain technical documentation for integrations, refresh schedules, dependencies, data transformations, and business logic.