Analyst, Data

NewSchools is a venture philanthropy organization that invests in education leaders and entrepreneurs advancing innovative K-12 solutions. The Data Analyst owns data stewardship, quality, and analytics for an assigned investment team, translating data into reliable insights and recommendations that support grantmaking and investment decisions.

Responsibilities:

• In partnership with the Data Manager, investment team leads, and the Research & Learning team, translate learning agendas into documented metric definitions, data structures, and processes and translate these into clear stakeholder communications
• In partnership with the Data Manager, develop and maintain processes that ensure the investment team collects cohesive quantitative and qualitative data specific to key metrics of success — logic model, learning agenda, and funder-facing impact
• Partner with the Research & Learning team to elevate metrics that support the broader research strategy
• Identify where business questions can't be answered with existing data or tools; develop well-reasoned recommendations for warehouse additions, public data infrastructure, self-service tool improvements, and research agenda priorities
• Maintain active working knowledge of NewSchools' full data stack — warehouse, BI tools, and public data infrastructure — to credibly advise the investment team(s) and inform infrastructure decisions
• Project manage annual data collection cycles; partner with the Data Manager and investment team leads on clean rostering, survey development, and administration
• Manage all data intake for the designated investment team(s) — applications, diligence, grantee surveys, internally generated data — including validation processes that catch errors at the source
• Partner with the data engineer and fellow analysts to validate and clean incoming data and execute automated quality control checkpoints
• Review and update databases within the designated investment team's scope, ensuring accuracy and integrity across all data sources
• Apply and reinforce best practices for capturing data updates regularly and accurately within the investment team
• Spot and report data anomalies from the stakeholder lens — quality issues automated back-end processing may miss — investigate root cause, report to relevant teammates, and manage stakeholder communications when a resolution isn't immediately possible
• Own the analytics relationship for your designated investment team(s), developing deep knowledge of its goals, workflows, and data needs to serve as a trusted, actively sought-out resource
• Lead ad hoc analyses to support data-driven decision-making and synthesize findings into written investment recommendations
• Own and respond to data reporting and analysis requests supporting grant and funder reporting
• Manage and execute ad hoc analysis and rapid prototyping using SQL, BI tools, and AI-assisted analytics to answer business questions
• Collaborate with Research & Learning and investment teams on custom queries and datasets supporting the learning agenda, team strategy, Board requests, and funder reporting and prospecting
• Develop planning tools, analysis frameworks, and visualizations that drive insight generation and identify portfolio bright spots, accounting for historical, contextual, and comparative data and perspectives
• Serve as the go-to resource for data questions across the organization, helping non-technical colleagues navigate systems and dashboards
• Support implementation and adoption of self-service analytics tools across the assigned investment team(s), including onboarding, coaching, and ongoing support
• Support ad hoc data needs across the organization

Requirements:

• Minimum 2 years of experience in roles working with complex data sets and owning end-to-end data processes (collection, auditing, analysis, meaning-making)
• Proficiency in SQL and experience with cloud data warehouse platforms
• Experience with BI/analytics tools and building self-service artifacts and reporting for non-technical users
• Experience with data validation, quality control processes, and data cleaning
• Project management experience, particularly running recurring data collection cycles that involve coordinating multiple internal and external stakeholders
• Comfort using AI-assisted analytics tools for ad hoc analysis and rapid prototyping
• authorized to work for any employer in the U.S
• unable to sponsor or take over sponsorship of an employment visa at this time
• BigQuery preferred
• Omni Analytics preferred
• Knowledge of the K-12 education sector with experience working with teacher, leader, and edtech data -or- Knowledge of the K-12 education sector with experience working with charter and district school and student data strongly preferred
• Building and maintaining knowledge management structures that make portfolio data and findings reusable across teams
• Supporting progress monitoring and research partnerships, including what gets collected and how data quality is protected
• Translating analysis into clear insights and recommendations for various stakeholders and audiences
• Implementing continuous improvement initiatives that increase efficiency
• Planning, prioritizing and managing multiple workstreams