Data Engineer
Analytics
Automation Developer
Azure
Azure Data Engineer
Azure Data Factory
Azure Data Platform
Business Analytics
Business Intelligence
Business Intelligence Tools
Cloud
Cloud Data Engineering
Cloud Data Platform
Cloud Engineer
Cloud Platform
Cloud Platforms
Cloud Platforms Cloud Platforms
Data
Data Analysis
Data Analytics
Data Analytics Tools
Data Architecture
Data Engineer
Data Engineering
Data Factory
Data Factory Azure
Data Integration
Data Integration Tools
Data Pipeline
Data Platform
Data Processing
Data Visualization
Data Warehouse
Database
Databases
Design
Digital Marketing
Engineer
ETL
Hr Technology
Informatica
Information Technology (IT)
Integration
Lakehouse
Microsoft
Microsoft Azure
Microsoft Office
Microsoft Power Platform
Office Tools
Power BI
Power Platform
Product Management
Programming
Programming Language
Programming Languages
Reporting and Analytics
Software Development
SQL
Visual Design
Job Description
As a Data Engineer for the Detroit Pistons Business Strategy & Analytics department, you will build and optimize a Microsoft-based data platform while supporting a move toward a lakehouse approach with Microsoft Fabric.
Responsibilities
- Develop, maintain, and optimize data pipelines, data models, database objects, and integration processes in a Microsoft-based data environment
- Support the transition from a traditional SQL Server data warehouse structure to a modern lakehouse methodology using Microsoft Fabric
- Build scalable ETL/ELT processes to ingest, transform, validate, and deliver data for reporting, analytics, and business intelligence
- Assist in the design and implementation of Microsoft Fabric components, including OneLake, Lakehouse, Warehouse, Data Factory pipelines, Dataflows Gen2, notebooks, and Power BI integration
- Partner with the Senior Director of Data Strategy & Reporting to implement data governance standards, data quality processes, and enterprise data best practices
- Create and maintain data validation rules, reconciliation processes, and data quality checks for critical business datasets
- Ensure data accuracy, consistency, integrity, privacy, and reliability across source systems, warehouse objects, lakehouse assets, and reporting outputs
- Prepare reliable, well-documented, and governed data assets to support reporting, analytics, automation, and AI applications
- Support Power BI datasets, semantic models, dataflows, and reporting infrastructure as needed
- Collaborate 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 clear technical documentation covering integrations, refresh schedules, dependencies, data transformations, and business logic
Requirements
- Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or a related field (preferred)
- Minimum 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 (required)
- 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, including dimensional modeling, star schemas, data marts, and modern lakehouse methodologies
- 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
- 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
Location
- Detroit, MI (onsite)
Technologies
- Microsoft SQL Server
- MS SQL data warehouse
- T-SQL
- ETL/ELT
- Microsoft Fabric
- OneLake
- Lakehouse
- Warehouse
- Data Factory pipelines
- Dataflows Gen2
- Notebooks
- Power BI
- Power BI datasets
- Semantic models
- Dataflows
- APIs
- Flat files
- Relational databases
- SaaS platforms
- Azure Data Factory
- Azure SQL
- Azure Data Lake
- Synapse
- Python
- PySpark
- Spark SQL