Junior Data Analyst: Education Reporting & Dashboards

Pitt State; Washington (District of Columbia); On-site; USD 45,000 - 75,000; Full time

Job summary

Community College Preparatory Academy in Washington, DC is seeking a Junior Data Analyst to support accurate reporting and data-driven decisions across information systems.

You will maintain dashboards, clean and validate data, and prepare clear tables and visuals for diverse audiences while protecting confidentiality.

This role emphasizes collaboration, data governance, and continuous improvement through structured processes and senior review.

Qualifications

• Bachelor's degree or an equivalent combination of education and directly related experience.
• Three years of relevant professional experience.
• Strong judgment, written and verbal communication, attention to detail, and ability to protect confidential information.

Responsibilities

• Clean, join, validate, and document data for recurring and ad hoc reporting.
• Maintain dashboards, trackers, data dictionaries, and quality-control checklists.
• Investigate discrepancies and coordinate corrections with system owners.
• Prepare clear tables, visualizations, and summaries for varied audiences.
• Protect confidential data and follow approved access and file-handling practices.
• Build technical skill through review, feedback, and progressively complex assignments.
• Prepare and validate linked learner assessment and support data for authorized progress reviews, following approved definitions and analytical methods.
• Maintain baseline and follow-up measures, intervention records, and quality checks; flag missing, inconsistent, or non-comparable results before reporting.
• Produce accessible summaries of engagement and learning evidence under senior review; protect confidentiality and avoid treating participation as proof of growth.
• Prepare disaggregated, privacy-protected information that helps authorized staff identify disparities, barriers, and learner needs; flag possible bias or inequity for senior review.
• Support collaborative data routines and reliable structures used for continuous improvement and learner-informed resource decisions.
• Prepare, validate, and document extracts from Canvas, EAB Navigate, enrollment and student-information systems, Qlik, SLED, SurveyMonkey, and other approved sources using established definitions, access controls, reconciliation steps, and senior review.

Skills

Spreadsheet skills

Data cleaning

Data analysis

Data visualization

Written and verbal communication

Attention to detail

Education

Bachelor's degree or equivalent

Professional certification or advanced training

Tools

SQL exposure

Power BI

Tableau

Python

R

Job description

Community College Preparatory Academy in Washington, DC is seeking a Junior Data Analyst to support accurate reporting and data-driven decisions across information systems.

You will maintain dashboards, clean and validate data, and prepare clear tables and visuals for diverse audiences while protecting confidentiality.

This role emphasizes collaboration, data governance, and continuous improvement through structured processes and senior review.