Education Policy Analyst

Education Policy Analyst executes 20 practical tasks that represent the most common duties and outcomes. Entries highlight when to rely on IBM SPSS Statistics, when to consult peers, and what to record. Each one shows where we found it, and comes with an AI prompt you can copy and use straight away.

20evidenced tasks
20ready prompts
6tools of the trade
15-2041.00O*NET-SOC code
29,030hold this job (US, BLS 2025)
$105,650median pay/yr (US)
Open Education Policy Analyst in the interactive atlas →

What it pays

Government survey numbers — not estimates, not ads.

Half of all Statisticians in the U.S. earn more than $105,650 a year — the middle 80% land between $64,000 and $174,050. About 29,030 people in the U.S. do this work. Figures are for the U.S. occupation group “Statisticians”. (U.S. Bureau of Labor Statistics survey, published 2025.) In India, Professionals earn about ₹38,298 a month on average — around ₹4.6 lakh a year (government PLFS survey via ILOSTAT, occupation-family figure).
$105,650typical pay / year
29,030people in this work
$174,050+top 10% earn
₹4.6 lakha year in India (family avg)
Think you get this job?Six quick questions on how it really works — with a hint and the reason behind every answer.
Test yourself →

The work, task by task

These are the real jobs-to-be-done, not a wish list. Each task shows where we found it, and the prompt underneath is written for that exact task.

Analysing6

Collect data

+
Pull statewide assessment, enrollment, and attendance extracts for 2019–2025, reconcile student IDs against…
Pull statewide assessment, enrollment, and attendance extracts for 2019–2025, reconcile student IDs against the district master list, flag missing demographics, and deliver one cleaned CSV ready for analysis by Wednesday noon.
The tools that do the workIBM DB2ESCOjob descriptionsWikipedia

Produce statistical reports and visualizations

+
Generate quarterly statistical summaries and create district comparison charts showing proficiency rates,…
Generate quarterly statistical summaries and create district comparison charts showing proficiency rates, chronic absenteeism, and subgroup gaps, then export a PDF briefing with figure captions for Friday's board packet.
The tools that do the workIBM SPSS StatisticsMicrosoft Exceljob descriptionsO*NETWikipedia

Collect and organize data for analysis

+
Combine the enrollment roster, course records, and intervention logs into one harmonized table, standardize…
Combine the enrollment roster, course records, and intervention logs into one harmonized table, standardize variable names and codes, document transformation rules in a data dictionary, and save as an analysis-ready file.
The tools that do the workMicrosoft Accessjob descriptionsO*NETWikipedia

Develop and apply statistical principles

+
Design the statistical protocol for the literacy intervention: define outcome measures, specify covariates…
Design the statistical protocol for the literacy intervention: define outcome measures, specify covariates and missing-data strategy, list hypothesis tests with alpha adjustments, and produce a reproducible script and methods appendix.
The tools that do the workIBM SPSS Statisticsjob descriptionsO*NET

Apply statistical methods to data

+
Clean and merge the district enrolment and assessment datasets, run descriptive summaries and regression…
Clean and merge the district enrolment and assessment datasets, run descriptive summaries and regression models to estimate program effects, produce tables of coefficients with 95% confidence intervals, and prepare charts for the policy brief.
The tools that do the workIBM SPSS StatisticsESCOjob descriptionsO*NETWikipedia

Analyze data to identify trends

+
Aggregate three years of school performance and labor-market placement data, create trend lines and cohort…
Aggregate three years of school performance and labor-market placement data, create trend lines and cohort comparisons, identify significant shifts by subgroup, and draft a one-page summary of implications for the next funding proposal.
The tools that do the workMicrosoft ExcelIBM SPSS Statisticsjob descriptionsO*NETWikipedia
The daily work14

Identify statistical patterns

+
Identify patterns in statewide assessment results by cleaning the score dataset, computing subgroup means and…
Identify patterns in statewide assessment results by cleaning the score dataset, computing subgroup means and growth rates, testing for significant differences across districts and socioeconomic groups, and flagging anomalies for follow-up within two working days.
The tools that do the workIBM SPSS StatisticsESCOsee the evidence ↗

Gather data

+
Assemble the last five years of enrollment, attendance, and assessment records from district extracts,…
Assemble the last five years of enrollment, attendance, and assessment records from district extracts, reconcile mismatched student IDs, create a tidy merged dataset with consistent variable names, and produce a data quality report by Wednesday.
The tools that do the workMicrosoft ExcelESCOsee the evidence ↗

Process data

+
Clean and join the district enrollment, attendance and finance tables, standardise school and LEA codes, flag…
Clean and join the district enrollment, attendance and finance tables, standardise school and LEA codes, flag missing entries, then produce a single cleaned dataset ready for analysis by Friday so we can start cohort tracking next week.
The tools that do the workMicrosoft ExcelESCOsee the evidence ↗

Think analytically

+
Test whether the 2018 policy change plausibly affected graduation rates: outline rival explanations, list…
Test whether the 2018 policy change plausibly affected graduation rates: outline rival explanations, list required variables and assumptions, and produce a short decision memo recommending the best identification strategy by Wednesday.
The tools that do the workMicrosoft OfficeESCOsee the evidence ↗

Perform data analysis

+
Run descriptive and subgroup summaries on reading scores by year, grade and free-lunch status, produce tables…
Run descriptive and subgroup summaries on reading scores by year, grade and free-lunch status, produce tables of means and counts with confidence intervals, and export the outputs for the policy team to review on Monday.
The tools that do the workIBM SPSS StatisticsESCOsee the evidence ↗

Apply statistical analysis techniques

+
Estimate the effect of class size on test scores using regression with robust standard errors, check for…
Estimate the effect of class size on test scores using regression with robust standard errors, check for nonlinearity and heteroskedasticity, and save a short appendix with diagnostics and code comments for the methodology section.
The tools that do the workIBM SPSS StatisticsESCOsee the evidence ↗

Apply scientific methods

+
Design and preregister the evaluation: state hypotheses, specify data sources and control variables, define…
Design and preregister the evaluation: state hypotheses, specify data sources and control variables, define outcome measures and power calculations, and produce a two-page protocol to circulate to partners by Friday.
The tools that do the workMicrosoft OfficeESCOsee the evidence ↗

Write work-related reports

+
Draft the quarterly policy brief summarising key findings, include a one-page executive summary, two figures…
Draft the quarterly policy brief summarising key findings, include a one-page executive summary, two figures for trends and one table of core statistics, then circulate the draft to Priya in procurement and Ben in research for comments by Thursday.
The tools that do the workMicrosoft OfficeESCOsee the evidence ↗

Assess reliability of source information

+
Assess the reliability of the student attendance dataset from the district portal: check source provenance,…
Assess the reliability of the student attendance dataset from the district portal: check source provenance, timestamp consistency, missing-data patterns, original collection method, and any conflicts with state submission records, then flag records I should exclude and explain why by Friday.
The tools that do the workIBM SPSS Statisticsjob descriptionsO*NET

Evaluate and describe data utility

+
Evaluate the utility of the statewide assessment data for analyzing grade-level learning loss: score…
Evaluate the utility of the statewide assessment data for analyzing grade-level learning loss: score completeness, alignment with standards, sample representativeness, timeliness, and what analyses are feasible or misleading given current gaps; recommend next steps.
The tools that do the workMicrosoft Exceljob descriptionsWikipedia

Use software like R, Python, SAS, SQL

+
Prepare the reproducible analysis pipeline that ingests cleaned enrollment and assessment files, documents…
Prepare the reproducible analysis pipeline that ingests cleaned enrollment and assessment files, documents each transform, runs the required regressions and diagnostic scripts, and packages the code and outputs so a colleague can re-run it without manual steps.
The tools that do the workLinuxjob descriptionsWikipedia

Build models and perform hypothesis testing

+
Build predictive and explanatory models to test whether attendance predicts end-of-year reading outcomes:…
Build predictive and explanatory models to test whether attendance predicts end-of-year reading outcomes: specify model families, pre-register hypotheses, run diagnostics and robustness checks, report p-values, effect sizes, confidence intervals, and a plain-language conclusion.
The tools that do the workIBM SPSS Statisticsjob descriptions

Liaise with management to define data needs

+
Meet with the deputy director and data services lead to capture the concrete data fields, update frequency,…
Meet with the deputy director and data services lead to capture the concrete data fields, update frequency, acceptable lag, and delivery formats we need for the new attendance dashboard; produce a one-page data specification after the meeting.
The tools that do the workMicrosoft Officejob descriptions

Create charts

+
Create clear charts that compare chronic absenteeism by school and by subgroup across the last three years:…
Create clear charts that compare chronic absenteeism by school and by subgroup across the last three years: include axis labels, source note, consistent color palette, and export PNGs sized for the policy brief.
The tools that do the workMicrosoft ExcelESCO

Says who?

These are the pages we read to build this. Open any of them and check us.

The logs, files & records this job keeps

Shared with other careers — the same record means something different in each.

Related careers

Same family of work — each with its own tasks and prompts.

The LLOS Work Atlas is the world's largest evidenced task library — a map of human work, with a ready prompt behind every task. 1,774 careers · every task named by the sources that witnessed it — O*NET, ESCO, real job descriptions, Wikipedia — and the deepest tasks by several at once. And it is honest about limits: where AI cannot help, the map says so.

The rest of the map

Same library, five ways in.

Copyright © LLOS.ai · 2026 — original pedagogy, voice, and design — all rights reserved.
Built on public evidence: O*NET®, ESCO, Wikipedia, U.S. Bureau of Labor Statistics, ILOSTAT. All sources & licenses