Company Description
KIPP Public Schools is a national network of public charter schools that prepares students with the skills and confidence to create the future they want for themselves, their communities, and us all. We are a network of 280 schools, nearly 15,000 educators, and more than 175,000 students and alumni.
Our mission: 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 vision: Every child grows up free to create the future they want for themselves and their communities.
The KIPP Foundation is a nonprofit organization that supports KIPP schools across the country. The KIPP Foundation trains and develops outstanding educators to lead KIPP public schools; provides tools, resources and training for excellent teaching and learning; promotes innovation; and facilitates the exchange of insights and ideas across KIPP and other public schools and organization.
Job Description
About The Position
KIPP’s Data & Analytics (D&A) team conducts collection, analysis, and reporting of high-quality data on KIPP schools, staff, students, and alumni. The Senior Manager, Data Systems & Collection will support our team’s efforts to collect and process data from KIPP regions and external partners, which enables us to track progress to mission-aligned goals and share actionable insights with key stakeholders to drive network improvement. The Senior Manager, Data Systems & Collection will play a critical role in streamlining existing collection and loading processes and develop new, automated data pipelines that ensure data flows seamlessly between regional and national data systems.
The Senior Manager, Data Systems & Collection will report to the Senior Manager, Data & Analytics and work collaboratively with teammates within D&A and across the KIPP Foundation and network.
Responsibilities
Lead loading of KIPP region and third-party vendor data into national high school and alumni data systems
Clean, match, load, and verify files received from vendors and regional teams
Develop dashboards that allow end users to check the completeness and quality of submitted data
Forecast potential data quality issues and ensure adequate consideration is given to these issues during process development
Answer support tickets related to data quality in national data systems
Support ongoing data quality assurance and monitoring in national high school and alumni systems
Work in partnership with program teams to ensure collection of high-quality data for all data streams including counseling, high school and college enrollments, applications, and college and career paths
Collaborate with program teams and engineers to improve existing requirements, ensuring data quality monitoring is embedded in our ETL processes
Ensure data collection is as low-burden as possible to regional teams, by continually reevaluating our collection processes
Support improvements to legacy systems
Develop and implement MVP pipelines to improve current data collection and loading processes
Work with program teams and engineers to translate learnings from pilots and legacy systems into business requirements, ensuring that data quality is an automated and embedded part of our end-to-end data loading processes (i.e., Salesforce, Overgrad)
Support user acceptance testing of requirements
Create dashboards that analyze disparate legacy systems to enhance data quality
Drive operational excellence in data work
Develop and support scalable, sustainable quality assurance practices to ensure high-quality and reliable data
Maintain quality assurance processes and cross-train teammates when needed
Ensure documentation of internal technical processes are maintained and updated
Qualifications
Skills & Competencies
Mission & Student Focus: Demonstrated commitment to education equity; a passion for KIPP’s mission; desire and ability to uphold KIPP’s values (Focus on Excellent Results, Courageous Action, and Resilient Solutions Focus)
Organization, Planning & Execution: Design, develop and execute project plans with attention to agility, deadlines, and stakeholders; proactively evolves plans and processes in anticipation of changing circumstances.
Achievement Orientation: Ensures clarity in goals and accountabilities while working with agility and creativity to drive toward deadlines and outcomes-focused metrics; eliminates unnecessary bureaucracy/inefficiencies in pursuit of outcomes
Cultural Competence & Commitment to Equity: A proactive cultural leader and team player who thrives on collaboration and learning; can effectively collaborate with teammates across lines of difference.
Critical Thinking & Problem Solving: Gathers information from multiple relevant sources and stakeholders when problem-solving; analyzes, reflects upon, synthesizes, and contextualizes information; weighs pros and cons of multiple options to solve complex problems; anticipates and identifies problems in a timely manner
Continuous Learning: Uses data to accurately assess areas for improvement and teaches others to do the same; values and encourages creative and innovative ideas
Experience and Qualifications
Required:
6+ years formal coursework or work experience focused on data engineering, collection, reporting, and/or analysis
SQL proficiency with ability to develop complex queries, scripts, view, and procedures
Experience using Python to support automation of data extraction, wrangling, and/or mining
Experience applying software engineering best practices to analytics code (i.e., version control, testing, CI)
Experience developing and executing on data quality assurance processes
Preferred:
Knowledge of data warehousing and data governance principles
Experience building ETL/ELT processes using tools like Airflow, FiveTran, or SQL tasks and stored procedures
Experience with the following (or similar) technologies: MSSQL, Salesforce, Jira, Zendesk, GitHub
Familiarity with data visualization and business intelligence (BI) tools (e.g., Tableau, Power BI, Looker)
Additional Information
Work Conditions
Travel requirements: May include up to 10% travel
Full Time, Exempt Position
Location
It is preferred, but not mandatory for this role to be based out of a KIPP Foundation office. This role also offers the option of working from a remote office full-time. KIPP Foundation office is in NYC, Chicago, San Francisco, and Washington DC.
Compensation and Benefits.
The salary range for this position is $100,000-$118,000, commensurate with experience.
Our comprehensive benefits package include:
26 holidays + 18 days additional flexible PTO days (flexible PTO increases to 23 days for years 3 and 4 and to 28 days for years 5+).
100% paid parental leave
100% coverage of the premium for employee and 75% for employee + family’s medical/dental/vision plans.
Wellness benefits such as fitness reimbursements, discounted tickets to theme parks/attractions, backup care support for children and adults/elders, and our employee assistance program
Finance Security benefits include such as a 401K retirement plan with 4% match, employer-sponsored legal plans, life/disability insurance, and flexible spending accounts