Detroit Public Schools Community District · 8 hours ago
Data Engineer
Detroit, MI
Full-time
Hybrid
Mid Level
$99K/yr - $135K/yr
3+ years expDetroit Public Schools Community District is seeking a Data Engineer to modernize and expand their data infrastructure serving over 50,000 students. The role involves leading the development and maintenance of data pipelines, ensuring data quality, and collaborating with a skilled team of engineers and analysts.
Education
Responsibilities
Contribute to the redesign and migration of legacy SSIS pipelines to Python-based solutions, improving maintainability, performance, and scalability
Lead the design and developmen of scalable data pipelines that extract, transform, and load data from multiple sources into our enterprise data warehouse
Implement workflow orchestration for complex, multi-step data processes with appropriate monitoring, alerting, and error handling
Implement data validation frameworks throughout the data processing lifecycle, with particular attention to how data accuracy, timing, and availability affect downstream reporting, school operations, and end users
Develop and maintain unit testing practices for both Python and SQL codebases, ensuring reliability and preventing regressions
Monitor and optimize pipeline performance, query efficiency, and resource utilization
Collaborate with other data engineers and contract resources on shared initiatives, including coordinating handoffs, reviewing work for quality and consistency, and ensuring alignment with established architectural patterns
Create and maintain clear technical documentation for pipelines, business logic, and data transformations
Support urgent data requests and investigations as needed
Perform other duties as assigned by the Senior Data Engineer & Infrastructure Architect
Qualification
Required
Bachelor's degree in Computer Science, Data Analytics, or a related technical field, and/or equivalent experience
3-5 years of experience building and maintaining production data pipelines
Strong proficiency in Python for data engineering workflows (pandas, SQL integration, API development)
Expert command of SQL with experience in query optimization and database design in Microsoft SQL Server environments
Experience implementing data quality frameworks and validation processes
Demonstrated ability to write and maintain unit tests for both Python and SQL code
Experience with version control systems (Git) and development best practices
Strong documentation skills and ability to communicate technical approaches clearly
Preferred
Experience migrating legacy ETL processes (SSIS, stored procedures) to modern Python-based pipelines
Familiarity with educational data systems or urban public school districts
Experience with Continuous Integration / Continuous Development (CI/CD) practices for data pipelines
Knowledge of data architecture patterns (bronze/silver/gold, medallion architecture)
Experience working in hybrid cloud/on-premises environments (Azure preferred)
Demonstrated experience working in a multi-engineer agile or iterative development environment with regular sprints, stand-ups, and retrospectives with shared ownership, iterative handoffs, and production change management
Company
Detroit Public Schools Community District
Detroit Public Schools Community District educate and empower every student, in every community, every day, to build a stronger Detroit.
5001-10000 employees
Funding
Current Stage
Late StageLeadership Team
Joseph Flint
DEPUTY EXECUTIVE DIRECTOR, TITLE I SCHOOL REFORM SPECIALIST
Recent News
Morningstar.com
2025-09-30
DBusiness Magazine
2025-08-27
Company data provided by crunchbase