Junior Data Analyst

Community College Preparatory Academy

Junior Data Analyst

Department: Information And Infrastructure Systems

Reports to: Senior Data Analyst

Status: Full-time; nonexempt

Location: Washington, DC / campus based

Salary band: $45,000–$75,000 annually

Supervisory responsibilities: No direct reports.

Our mission

Community College Preparatory Academy (CCPrep) creates an innovative and rigorous learning environment for adults who are under-credited or have aged out of traditional K–12 pathways. We respond to each learner’s strengths and barriers while preparing students for employment, postsecondary education, industry credentials, and lifelong learning.

The opportunity

Support accurate, timely reporting and analysis by preparing, checking, documenting, and presenting data with care.

Why this role matters for students

Your work helps staff notice student needs sooner and gives leaders confidence that decisions rest on dependable information.

Cognia connections Culture of Learning, Leadership for Learning, Engagement of Learning, and Growth in Learning | Standards 1–2, 5, 7, 11, 15, 17, 24–28, 30–31. These responsibilities apply within this position’s assigned authority.

Essential 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.

What strong performance looks like

• Recurring reports are accurate, timely, and quality checked.
• Data issues are documented and resolved or escalated.
• Work products are reproducible and understandable to another analyst.
• Confidential information is handled according to approved controls.
• Specific annual targets and milestones will be established in the employee’s performance plan and aligned with the approved school operating plan.
• Progress datasets and reports are accurate, traceable, and clear about missing data and limits on comparability.
• Authorized staff receive timely, reviewed information to guide learner support and evaluate improvement actions.
• Reviewed datasets and summaries accurately surface access and well-being indicators, data limitations, and actionable needs for responsible decision-makers.
• Assigned extracts and reports match authorized source records, follow documented definitions, identify missing or conflicting data, and are reproducible by another qualified staff member.

Minimum qualifications

• Intermediate spreadsheet skills and foundational experience with data cleaning, analysis, or visualization.
• Bachelor’s degree in a relevant field or an equivalent combination of education and directly related experience.
• At least three years of relevant professional experience.
• Strong judgment, written and verbal communication, attention to detail, and ability to protect confidential information.

Preferred qualifications

• Experience with spreadsheets and at least one BI, database, LMS, SIS, case-management, survey, or education-reporting platform; Qlik or Looker Studio exposure is preferred.
• Exposure to SQL, Power BI, Tableau, Python, R, or a student-information system.
• Experience in adult education, workforce development, public charter education, or a mission-driven nonprofit.
• Relevant professional certification or advanced technical training.
• Experience improving processes through data, technology, and cross-functional collaboration.

Core ways of working

• Centers adult learners, values their backgrounds and abilities, and respects their voice and choices.
• Communicates clearly, follows through, and raises risks early.
• Uses evidence, protects confidentiality, and documents work so others can rely on it.
• Collaborates across units and uses resources responsibly.
• Uses feedback and role-appropriate evidence to test improvements, apply professional learning, and review results.

Work environment and essential capabilities

Primarily campus and office based with regular computer use and interaction with students, staff, vendors, or community partners. Some evening, weekend, or off-site work may be required. Essential duties must be performed with or without reasonable accommodation.

Application and employment conditions

To learn more and apply, visit ccprep-academy.org/careers/. Questions or accommodation requests may be directed to (202) 770-3252.

CCPrep provides equal employment opportunity without regard to any characteristic protected by federal or District of Columbia law. Qualified applicants and employees may request reasonable accommodation for the application process or to perform essential job functions. Any required background, credential, driving-record, or employment-history review will occur in accordance with applicable law and at the appropriate stage of the hiring process. Employment may be contingent on satisfactory completion of job-related screening.

This description identifies the role’s principal responsibilities and essential functions. It does not create an employment contract and may be revised to reflect lawful, mission-related organizational needs. Related duties may be assigned when consistent with the role’s purpose and qualifications.