Analyst, Data

NewSchools Venture Fund

3d•$83,000 - $104,000•Remote

About The Position

NewSchools is seeking a Data Analyst to provide strategic and operational capacity across teams in support of grantmaking. The role owns data stewardship, quality, and analytics within Operations and is assigned to a designated investment team. It reports to the Senior Director of Operations, with a dotted line to the assigned investment team. The analyst executes within centrally designed data frameworks and standards and serves as a trusted analytics partner to the investment team. The analyst owns the data and metrics used to demonstrate impact, ensures data entering organizational systems is accurate and trustworthy, and turns data into insights and recommendations that inform investment decisions. The role also helps colleagues across NewSchools find, trust, and use data through guidance, self-service analytics implementation, and support. The position is fully remote and may be based anywhere in the United States, with up to 10% travel for in-person team meetings, retreats, and conferences.

Requirements

At least 2 years of experience in roles involving complex datasets and ownership of end-to-end data processes, including collection, auditing, analysis, and meaning-making.
Proficiency in SQL.
Experience with cloud data warehouse platforms.
Experience with BI or analytics tools and building self-service artifacts and reports for non-technical users.
Experience with data validation, quality-control processes, and data cleaning.
Project management experience, particularly coordinating recurring data collection cycles involving multiple internal and external stakeholders.
Comfort using AI-assisted analytics tools for ad hoc analysis and rapid prototyping.
Ability to travel up to 10% for in-person team meetings, retreats, and conferences.
Authorization to work for any employer in the United States; the organization is unable to sponsor or take over sponsorship of an employment visa.
Ability to ground decisions and actions in the organization's mission and commitment to equity; communicate proactively; collaborate across teams; prioritize competing demands; work effectively with imperfect or incomplete data; exercise sound judgment; and stay informed about the field and market.

Nice To Haves

Experience with BigQuery.
Experience with Omni Analytics.
Knowledge of the K-12 education sector and experience working with teacher, leader, and edtech data, or with charter and district school and student data; strongly preferred.
Experience building knowledge-management structures that make portfolio data and findings reusable across teams.
Experience supporting progress monitoring and research partnerships, including decisions about data collection and protecting data quality.
Experience translating analysis into clear insights and recommendations for varied stakeholders and audiences.
Experience implementing continuous-improvement initiatives that increase efficiency.
Experience planning, prioritizing, and managing multiple workstreams.

Responsibilities

Own the data and metrics that demonstrate impact for a designated investment team.
Translate learning agendas into documented metric definitions, data structures, processes, and stakeholder communications in partnership with the Data Manager, investment team leads, and Research & Learning.
Develop and maintain processes for collecting cohesive quantitative and qualitative data related to success metrics, logic models, learning agendas, and funder-facing impact.
Partner with Research & Learning to elevate metrics that support the broader research strategy.
Identify business questions that cannot be answered with existing data or tools and recommend additions or improvements to the data warehouse, public data infrastructure, self-service tools, and research priorities.
Maintain working knowledge of the organization's data stack, including its warehouse, BI tools, and public data infrastructure.
Project manage annual data collection cycles, including clean rostering, survey development, and administration.
Manage data intake for assigned investment teams, including applications, diligence, grantee surveys, and internally generated data, and establish validation processes that catch errors at the source.
Partner with the Data Manager, data engineer, and fellow analysts to validate and clean incoming data and carry out automated quality-control checkpoints.
Review and update databases within the assigned team's scope to maintain accuracy and integrity across data sources.
Reinforce best practices for recording data updates accurately and regularly.
Identify data anomalies from the stakeholder perspective, investigate root causes, report issues to relevant colleagues, and manage stakeholder communications when resolution is delayed.
Own the analytics relationship for assigned investment teams, developing knowledge of their goals, workflows, and data needs.
Lead ad hoc analyses, synthesize findings, and develop written investment recommendations.
Respond to data reporting and analysis requests supporting grant and funder reporting.
Use SQL, BI tools, and AI-assisted analytics to conduct ad hoc analyses and rapid prototyping.
Collaborate with Research & Learning and investment teams on custom queries and datasets for learning agendas, team strategy, Board requests, and funder reporting and prospecting.
Develop planning tools, analysis frameworks, and visualizations to generate insights and identify portfolio bright spots using historical, contextual, and comparative data and perspectives.
Help non-technical colleagues navigate data systems and dashboards as an organizational resource for data questions.
Support implementation and adoption of self-service analytics tools through onboarding, coaching, and ongoing assistance.
Support ad hoc data needs across the organization.