20 tasks, each one witnessed by the sources that watched the job — and behind every one, a prompt you can use tonight.
You spend much of the day with data: collecting state or district datasets, cleaning them in Excel or SQL, and running tests in R, Python, or SPSS. Expect meetings with program staff or managers in the morning to define the questions and the data needed.
Afternoons often mean building charts or tables for reports, writing the methods and findings, and checking sources. Some days are fieldwork—requesting data from districts or reviewing administrative rules—so the schedule can jump between coding and writing.
Start with Excel and SQL. Excel handles quick cleaning and charts; SQL (used with IBM DB2 or other databases) pulls and joins large administrative files. These two let you work with real education data immediately.
Next learn R or Python for statistical tests, models, and reproducible scripts. SPSS is OK if your office already uses IBM SPSS Statistics, but R/Python give more flexibility for visualization and advanced analysis.
Use AI for drafting report language, summarizing methods, or generating code snippets, but never for final answers. Always verify any code or statistical result AI provides by running it yourself and checking assumptions, tests, and outputs.
Never paste identifiable student data into public AI tools. Treat AI outputs as a first draft: check facts, cite original sources, and document every analytic step for reproducibility.
You will apply statistical principles daily: descriptive statistics, trend analysis, regressions, and hypothesis tests like t-tests or chi-square for group differences. You also build models to estimate program effects or predict enrollment.
Tasks include assessing data reliability, running diagnostics for model fit, and producing visualizations that show trends over time. Software choices are R, Python, SAS, or SPSS depending on your office.
According to the U.S. Bureau of Labor Statistics (BLS), this occupation (SOC 15-2041.00) had 29,030 employed and a median annual wage of $105,650. The lowest 10% earned about $64,000 and the top 10% about $174,050, per BLS 2025 data.
Use those ranges to set expectations: local government or nonprofits often sit near the median, while federal roles or specialized research centers can reach the top end.
Compared with a data scientist: you focus specifically on education policy questions, program evaluation, data quality, and policy writing. You use statistics and models, but less often machine learning production pipelines or big data engineering.
Compared with a teacher: you rarely deliver instruction or manage classrooms. You analyze administrative and survey data to inform decisions that affect schools, rather than directly teaching students.
Learn to collect and clean data, run basic statistical analyses, and make clear charts. Practically: practice SQL queries on linked student files, clean messy spreadsheets in Excel, and run regressions in R or SPSS.
Also practice writing two-page briefs and creating one-page visuals that explain findings to managers. Employers look for demonstrated analytic work and the ability to explain methods and limitations clearly.