Data Engineer
Data Engineer
Company: Detroit Public Schools Community District
Location: Detroit, MI
*** Mention DataYoshi when applying ***
Job Title
Position Title: Data Engineer
Location: Data Assessment and Accountability
Salary: $85,000 - $110,000
Reports to: Deputy Executive Director of Data Services
Benefits Eligible: Yes
Position Summary:
As a member of the Data Services department, the Data Engineer will develop and maintain pipelines for the data of our District representing over 50,000 students. The Data Engineer will collaborate closely with the data architect, BI developer, and analysts, managing scalable data integrations and developing an analytical infrastructure that will support various applications, including business intelligence tools, software applications, and analysis to produce meaningful insights. This is a unique opportunity to join a growing team that is quickly increasing its capacity to build long-term data infrastructure using a modern technology stack.
Minimum Qualifications:
- Bachelor’s or master’s degree in Computer Science or a related technical field, and/or equivalent experience
- More than 3 years’ experience transforming raw data into useful data systems/platforms
- Experience building and operating distributed systems of data extraction, ingestion, and processing of large data sets from multiple sources
- Expert command of SQL with experience building database tables
- Expert command of Python or similar analytical programming languages
- Experience compiling and maintaining technical documentation
- Experience communicating business requirements and project plans with internal clients
- Experience working in an urban public-school district a plus
- Experience optimizing queries and utilization of server resources for performance and efficiency
- Experience ingesting and combining raw and unstructured data of various types
- Have Microsoft Azure Data Engineer certification or be willing to enroll through the District
Essential Functions:
- Contribute to the development of a modern data infrastructure that drives decision-making at all levels of the organization.
- Develop and maintain scalable data pipelines and build out new integrations to support the increasing data volume and complexity.
- Extract, transform, and load data from raw unstructured data to consumable structured data using SSIS.
- Collaborate with analysts, data architect, and BI developer to improve data models that feed business intelligence tools, increasing data accessibility and fostering data-driven decision making across the organization.
- Implement processes and systems to monitor data quality, ensuring production data is always accurate and available for key stakeholders and business processes that depend on it.
- Write and curate documentation internally and externally around business rules for metrics.
- Collaborate with other members of the Data Services team around a long-term data strategy plan that scales for the district’s decision-making and analytics.
- Develop project plans and engage in the project timeline estimation process.
- Perform ad hoc data investigation and analysis duties as assigned by manager.
- Perform other duties as assigned by the Deputy Executive Director of Data Services.
Security Clearance:
Internal Applicants
If you are a current Detroit Public Schools Community District employee, you do not have to submit to a new security clearance, unless your new role requires a different type of criminal background check.
External Applicants
In alignment with Michigan law, if you are hired to fill a position, you will be required to submit to a Detroit Public Schools Community District criminal background check. Information regarding required background checks will be shared at point of hire.
Method of Application:
Applicants must apply through the online application system. Only applications submitted through the online application system will be considered for any posted position and all applications require a resume to be considered.
Successful candidates are required to submit official transcript(s) at point of offer to hire. Teaching service outside of the Detroit Public Schools Community District must be verified by the applicant's prior employer(s) prior to hire. It is the applicant's responsibility to provide all documentation (including copies) as requested.
Applicants requesting assistance during the application process should contact the Office of Human Resources via email at [email protected] or phone at (313) 873-6897.
DPSCD does not discriminate on the basis of race, color, national origin, sex, sexual orientation, transgender identity, disability, age, religion, height, weight, citizenship, marital or family status, military status, ancestry, genetic information, or any other legally protected category, in its educational programs and activities, including employment and admissions opportunities. Contact the Civil Rights Coordinator for more information at (313) 240-4377
*** Mention DataYoshi when applying ***
Offers you may like...
The Upside Travel Company, LLC
PPL Corporation
Artemis Consulting Inc
Illuminate Education