Program Associate I - Data Analyst
Job Description
DPSCD’s Research & Data Science team drives a research agenda shaped by the District Strategic Plan, translating evidence into clearer decisions for school and District leaders. In this hybrid role in Detroit, you will support ongoing analysis and data management that help identify trends, measure progress, and surface gaps and opportunities tied to key performance and operations metrics.
Role focus
As a Program Associate I, Data Analyst, you will use data to support the District in understanding what is working and what needs to change. Your work includes analysis, management, monitoring, and reporting for District Strategic Plan metrics, as well as critical school and District-level performance and operations indicators. You will also contribute to aligned data management standards and systems across departments, supporting improved data access and reporting and strengthening districtwide data capacity through special projects connected to District goals.
Key responsibilities
- Partner with teams and senior analysts to define research questions, build analysis plans, and manage progress for analytic projects.
- Plan and conduct statistical analyses, then communicate results that help the District understand progress, gaps, and opportunities.
- Create clear reports, dashboards, and presentations for both technical and non-technical audiences.
- Design, develop, and maintain metrics, reports, and analyses that support District decision-making.
- Advance district data science capabilities by supporting tools and workflows that improve analytical efficiency.
- Manage data collection, cleaning, and preparation, including scheduling and logistics and querying large or complex datasets for analysis.
- Support the design and execution of data systems for district initiatives so the District can evaluate investment effectiveness.
- Author internal and external resources to help stakeholders access and understand insights from analytics, research, and evaluation work.
- Use established analyst support protocols, including reviewing colleagues’ code, participating in quality assessment, providing and receiving feedback, documenting code and processes, using version control, and sharing breakthroughs.
- Protect confidentiality of student and staff data in alignment with FERPA and District data privacy policies, using only District-approved tools, including for AI tools, when confidential data is involved.
- Use AI tools responsibly to support coding, documentation, and analysis, with strong discernment when reviewing outputs before sharing.
- Perform other duties as assigned by the Senior Director.
Requirements
- Bachelor’s degree in economics, education, public policy, social sciences, applied mathematics, computer science, data science, statistics, or related field (Master’s or Doctorate preferred).
- Ability to persevere through challenges and layered priorities while meeting expectations for quality, timeliness, and collaboration.
- Demonstrated success analyzing and interpreting quantitative data and disparate data sources to make recommendations based on findings.
- Exceptional attention to detail and ability to catch and resolve issues to ensure work is trusted and grounded in quality insights.
- Proficiency in SQL or evidence of ability to quickly learn SQL.
- Strong written and oral communication skills to gather and define requirements and research questions and share findings with technical and non-technical audiences.
- Understanding of student data privacy requirements (for example, FERPA) and careful handling of confidential data.
- Ability to write code to pull and analyze large and complex datasets (R and SQL are used, but Python, SAS, SPSS, or Stata experience is recognized).
- Working reproducibly, including version control (for example, Git) and clear documentation so colleagues can follow, continue, and extend work.
- Capability with fundamental statistical analyses such as correlations, linear regression, and logistic regression.
- Ability to present data clearly in charts, reports, and dashboards.
Tools and technologies
- SQL, R, Python, SAS, SPSS, Stata, Git
- Power BI, Tableau, Shiny
- AI tools, FERPA
- Propensity score matching, Regression discontinuity analysis
Position details
- Location: Detroit, MI (hybrid)
- Salary: USD 75,048 - 98,163 per year
- Reports to: Senior Director, Research and Data Science
- Benefits eligible: Yes
- Working schedule eligibility: Eligible for up to 40% (two (2) days per week) telecommuting
- Location address: Fisher Building, 3011 W. Grand Blvd, Detroit, MI 48202
- Bargaining unit: OSAS
Security clearance
- Internal applicants: If you are a current Detroit Public Schools Community District employee, you do not have to submit a new security clearance unless your new role requires a different type of criminal background check.
- External applicants: In alignment with Michigan law, if hired, you will be required to submit a Detroit Public Schools Community District criminal background check.
How to apply
- Apply through the online application system.
- Only online applications will be considered, and a resume is required.
- At point of offer, official transcript(s) must be submitted.
- Teaching service outside of Detroit Public Schools Community District must be verified by prior employer(s) prior to hire.
- If assistance is needed during the application process, contact the Office of Human Resources at [email protected] or (313) 873-6897.