Data Analyst

Role Responsibilities: Regional Analytics Support

• Serve as a responsive and reliable analytical partner to stakeholders across the organization, completing ad hoc data analysis requests accurately and within established turnaround times.
• Design and develop analysis reports and dashboards that translate complex data into clear, actionable insights for diverse audiences including school leaders, HR, finance, and operations teams.
• Contribute to the prioritization and planning of short and long-term analytics needs across stakeholders, helping ensure the team's analytical capacity is directed toward the highest-impact work.
• Document all data analysis processes and methodologies thoroughly, creating transparency between data producers and end users and building organizational knowledge that reduces dependency on any single team member.

Role Responsibilities: Dashboard Development & Data Visualization (Tableau)

• Build, maintain, and continuously improve Tableau dashboards that surface meaningful insights from student information, assessment, HR, and survey data for a variety of stakeholder audiences.
• Translate complex analytical findings and technical concepts into clear, accessible visualizations and narratives that empower non-technical stakeholders to understand and act on data confidently.
• Maintain and update existing dashboards to ensure accuracy, relevance, and alignment with evolving organizational needs and data structures.
• Embed and maintain Tableau dashboards on the organizational website, ensuring pages are accurate, current, and accessible to all stakeholders who rely on them.

Role Responsibilities: Data Querying & Transformation (SQL & Google BigQuery)

• Write efficient, well-documented SQL queries to support ad hoc analysis requests, dashboard development, and reporting needs across the organization.
• Create and maintain views and connected Google Sheets within Google BigQuery that are accessible, reliable, and reusable by other data team members.
• Build and update tables in BigQuery as needed, ensuring data is structured, accurate, and aligned with established data standards and governance protocols.
• Manage Google Secrets responsibly, including creating, updating, and deprecating usernames and passwords in accordance with organizational security standards.

Role Responsibilities: Data Modeling (dbt)

• Develop and maintain dbt models that generate clean, well-structured master tables serving as the foundation for dashboards and reports across the organization.
• Write and maintain dbt tests that enforce data quality standards, ensuring that models produce accurate, consistent, and trustworthy outputs.
• Monitor and resolve dbt test warnings proactively, addressing data quality issues before they surface in downstream dashboards or reports.

Role Responsibilities: Version Control & Collaboration (Git)

• Manage personal Git branches with discipline and consistency, following established branching conventions and keeping work organized and well-documented.
• Submit clear, well-described pull requests for all updates to the main branch, providing sufficient context for reviewers to evaluate changes efficiently.
• Participate in pull request reviews, providing constructive and technically sound feedback that upholds the team's standards for code quality and data model integrity.

Role Responsibilities: Scripting & Automation (Python)

• Apply foundational Python skills to support analytical workflows, including minor code modifications, debugging, and scripting tasks that increase efficiency and reduce manual effort.
• Collaborate with analytics engineers and data engineers to identify opportunities where Python can be leveraged to automate or streamline analytical processes.

Role Responsibilities: Research & Statistical Analysis

• Apply statistical methods and analytical frameworks to project data outcomes, model trends, and support evidence-based planning across academic and operational functions.
• Document all research projects thoroughly including methodology, assumptions, findings, and limitations, and communicate results to stakeholders in a clear, accessible, and actionable format.
• Partner with school and organizational leaders to frame research questions, interpret findings in context, and translate insights into concrete recommendations that drive organizational planning and decision-making.

Role Responsibilities: Organizational Website Support (WordPress)

• Create and maintain organizational website pages with embedded Tableau dashboards, ensuring pages are accurate, up to date, and accessible to all stakeholders.
• Support team members and end users in navigating and troubleshooting the site through helpdesk tickets, responding promptly and resolving issues with care and clarity.
• Monitor and respond to comments on Tableau dashboard pages, addressing questions and feedback in a timely and helpful manner.

Qualifications

• Education:
• Bachelor's degree required in Data Science, Statistics, Mathematics, Computer Science, Information Systems, or a related field
• Experience:
• Experience in a data analyst, business intelligence, or related analytical role
• Experience working with large, complex datasets across multiple source systems
• Experience building and maintaining dashboards and data visualizations for diverse stakeholder audiences
• Experience in an educational or nonprofit organization preferred but not required
• Experience working within a collaborative, cross-functional data team preferred

• Technical Skills:

• Proficient in SQL with demonstrated ability to write efficient, well-documented queries against large datasets
• Proficient in Tableau or a comparable data visualization platform with experience building and maintaining dashboards for non-technical audiences
• Experience with Google BigQuery or a comparable cloud data warehouse
• Familiarity with dbt or a comparable data modeling tool, with the ability to build, test, and maintain data models
• Working knowledge of Git and version control practices including branching, pull requests, and code review
• Basic proficiency in Python with experience in minor code modifications, debugging, and scripting
• Familiarity with Google Workspace tools including Google Sheets and connected data sources
• Experience with WordPress or a comparable content management system preferred but not required

Compensation & Benefits

• KIPP SoCal Public Schools offers a competitive salary commensurate with experience in a similar position. The salary range for this position is $69,076 to $93,252.New hires are typically brought into the organization at a salary between the range minimum and the salary range midpoint of $81,164 depending on qualifications, internal equity, and the budget allocated for this role.
• 100% of healthcare premium costs covered by employer, dependents added at 50% of the cost
• Employer-paid KIPP SoCal life insurance
• 401(k) plan with up to 6% match by KIPP SoCal
• Voluntary Benefits (Pet Insurance, Supplemental Life, Accident, Short Term Disability, etc.)
• Generous time off program includes 22 holidays, sick leave and vacation
• Other great benefits (Flexible spending account, EAP, etc.)