Data Associate for Accountability & Compliance
Description
Please note: a cover letter is required for this position. Please tell us about your interest in working for KIPP!
Position Summary
We are seeking a Data Associate who wants to employ both their technical data skills as well as their soft skills, like project management and collaboration abilities, to work across regional teams to help KIPP maximize public funding while giving valuable time back to school teams. Core to the role is owning the execution of our accountability and compliance reporting to State, Federal, and Local agencies through a mix of Python automated tooling (pandas and selenium libraries) and on-going development and maintenance of our centralized data quality systems, including our data warehouse and Galaxy, our internal data platform. Additionally, this role will provide input on our data quality strategy, driving the delivery of reliable data for strategic decision-making, organizational improvement, and accurate, timely reporting. The Data Associate will be tasked with a variety of projects and ongoing workflows at the intersection of public funding, data, operations, human resources and special education. Ideal candidates possess a keen attention to detail, an ability to balance multiple projects at once, an ability to collaborate with both business and technical resources across the organization, a willingness to ask questions and dig for answers, and a thirst for constant learning and improvement.
This role sits on our Data & Evaluation Team and reports to our Associate Director of Data.
Essential Functions and Responsibilities:
External Reporting - State, Federal and Authorizer (~60%)
- Own the annual processes for the California Longitudinal Pupil Achievement Data System (CALPADS), which is the state data collection and reporting engine for student demographic, staffing, course and programmatic data for 22 KIPP schools and growing. Processes include data submissions, data reconciliation, data quality, user access, training and resource support.
- Project & Stakeholder Management:
- Project manage on-time submissions to state and federal agencies, collecting required data and information from multiple teams and stakeholders to meet compliance requirements.
- Build, maintain and leverage strong collaborative relationships with teammates on Human Resources, Special Education, Operations and other state agencies to meet project and compliance goals.
- Data Automation & Management:
- Enhance, troubleshoot, and continue to build out our Python based data tooling, used to automate and ensure efficient and compliant state and federal submissions.
- Research, design, and implement procedures to audit, certify, and publish student and staff information to CALPADS and other local, state and federal agencies.
- For our more centralized data collection efforts, such as multilingual learner statuses and Free and Reduced Lunch Eligibility, partner with internal systems administrator to mass update KIPP’s student information system’s backend.
Data Quality Systems & Strategy (~30%)
- Rebuild and streamline data warehouse SQL models that support CALPADS. This is alongside the team-wide ongoing data warehouse migration process to move our infrastructure and functionality to an updated and best in class solution with BigQuery and dbtCloud.
- Maintain and refine over time, our suite of Data Quality Tools (largely Tableau and Google sheet based), used by our school and regional teams to identify critical data issues and drive timely corrective action in alignment with state and federal reporting submissions.
- Leverage Python (pandas & selenium libraries) to automate data migration processes between multiple data systems and internal facing data quality tools.
- Identify organizational needs pertaining to data quality and reporting, designing and building products to meet these needs for diverse audiences at both the school and at the regional level.
Data Analysis & Data Products (~10%)
- In partnership with the Associate Director of Data, provide analytical support in the form of analysis and data products to a portfolio of teams (Public Accountability & Compliance Team (PACT), Operations Team, and Growth Team to aid them in strategic decision-making.
- Crosswalk large data sets to identify schools at risk for oversight.
- Streamline and maintain the data analysis needs for our Local Control Accountability Planning (LCAP).
Preferred Qualifications
Experience:
- Experience analyzing large datasets, with high accuracy and attention to detail; experience with educational data a plus
- At least 1 or more years of professional experience on a team, in a data-oriented capacity such as in managing aspects of an information management system and/or acting as a resource for problem resolution that requires using, moving, or managing data.
- Demonstrated project management experience that includes collaborating and problem solving across multiple teams, and creating resources, processes, playbooks and/or policies that interact with multiple stakeholders.
Knowledge/skills required:
- Proficient in Google Sheets or Excel, including use of pivot tables.
- Experience in using Python for automation (Pandas and Selenium libraries).
- Some experience with SQL for database management.
- Some experience with data visualization tools, like Tableau, is a plus.
- Ability to think critically, manage multiple tasks independently, and complete detailed work with accuracy and accountability.
- Highly resourceful, with ability to learn new data platforms/systems quickly and independently
- Ability to analyze issues, weigh risk, and recommend an appropriate course of action .
- Proficient in Google suite (Google docs, Google drive, Google Slides, forms etc.).
Education:
- Equivalent to graduation from high school and possession of the knowledge/skills listed above
Physical, Mental and Environmental
Physical: Ability to navigate office and school campuses, and hold meetings in different spaces. Traditionally, much of the day involves sitting. Ability to access and utilize technology. Occasional lifting/carrying of equipment 1-20 lbs. Physical agility to move self in various positions in order to execute duties effectively, which may include kneeling, walking, pushing/pulling, squatting, twisting, turning, bending, stooping and reaching overhead
Mental: Stress of deadlines and normal work standards, ability to analyze problems and generate alternatives, work with interruptions, concentrate for long periods of time, read, calculate, perform routine math problems, memorize and recall objects and people.
Environmental: Office environment subject to constant interruptions and distractions. Adhere to KIPP’s health and safety guidelines as outlined by the CDC, CDE, and public health agencies’ recommendations.
Classification
This is a full-time, exempt position based on a full year calendar cycle and time off, located in our Regional Support Office with occasional travel to schools and districts.
The KIPP Regional Support Office is currently operating in a hybrid fashion. Most positions can expect to work in person 2-3 days per week and remotely the remaining days, subject to change based on the needs of the role.
About KIPP Public Schools Northern California
We are a thriving nonprofit network of 22 free, public charter schools open to all students. At KIPP, we believe all children should grow up free to create the future they want for themselves and that schools can and should be a critical factor in making that vision a reality. Together with families and communities, we create joyful, academically excellent schools that prepare students with the skills and confidence to pursue the paths they choose—college, career, and beyond—so they can lead fulfilling lives and build a more just world.
Our student community consists of over 7,000 elementary, middle, and high school students in East Palo Alto, Oakland, San Francisco, San Lorenzo, San Jose, Redwood City, and Stockton. 79% qualify for free or reduced price lunch, 23% are multilingual learners, and 10% have special needs. We strive to cultivate a representative team of teachers and leaders that reflect our students’ diversity.
Compensation
KIPP Northern California is dedicated to you and your family's well-being! We offer a competitive salary as well as a comprehensive benefits package including medical, dental, vision, and transportation benefits.
We benchmark annually against comparably-sized non-profit organizations in the regions where we operate, to offer competitive salaries. The salary range for this position is between $66,000 and $80,000. Most candidates would be compensated at $70,000.
How to Apply
Please submit a cover letter and resume by clicking apply on this page.
Please note: a cover letter is required for this position. Please tell us about your interest in working for KIPP!
KIPP Northern California Public Schools does not discriminate on the basis of age, race, ethnicity, color, national origin or ancestry, cultural background, religious creed, sex, gender identity or expression, sexual orientation, marital/registered domestic partner status, physical or mental disability, medical condition, genetic information, military or veteran status, primary language, citizenship or immigration status, or any other consideration made unlawful by federal, state, or local laws.