Data Analyst

Remote (United States)

Job Details

Location: United States

Workplace: Remote

Employment Type: Full-Time

Experience: Minimum 2 years of relevant data analytics experience

Core Areas: SQL, BigQuery, Business Intelligence (BI), Data Quality Management, Data Validation, Data Reporting, Data Visualization, Data Analytics

Compensation: $83,000–$104,000 annually, with a potential annual performance bonus of up to 5%.

Travel: Up to 10% for in-person team meetings, retreats, and conferences.

About the Role

The Analyst, Data position focuses on data stewardship, data quality, reporting, and analytics to support strategic and operational decision-making within a nonprofit investment and grantmaking environment. This role is responsible for managing data collection processes, maintaining reliable datasets, developing performance metrics, and transforming complex quantitative and qualitative information into actionable insights that inform investment decisions and measure educational impact.

The position works closely with a Data Manager, data engineers, research and learning specialists, and investment teams. Responsibilities include SQL-based analysis, cloud data warehouse operations, BI reporting, data validation, self-service analytics, and stakeholder support. The role also contributes to research initiatives, grant reporting, and data-driven strategies related to K-12 education, schools, students, educators, and education technology.

What You'll Do

• Partner with the Data Manager, investment team leaders, and Research & Learning specialists to translate research and learning agendas into documented metrics, data structures, collection processes, and clear stakeholder communications.
• Develop and maintain processes for collecting consistent quantitative and qualitative data aligned with key performance indicators, logic models, learning agendas, and funder-facing impact reporting.
• Define, document, and maintain data metrics used to measure investment portfolio performance and educational outcomes.
• Collaborate with research teams to identify metrics and datasets that support broader research objectives and organizational learning strategies.
• Identify gaps in available data, reporting capabilities, and analytical tools that limit the ability to answer important business and research questions.
• Recommend improvements to data warehouse infrastructure, public data resources, self-service analytics tools, and research priorities.
• Maintain working knowledge of the organization's data warehouse, business intelligence platforms, and public data infrastructure to support analytical and infrastructure decisions.

• Project manage recurring annual data collection cycles, coordinating with the Data Manager, investment teams, and internal and external stakeholders.
• Support accurate roster management, survey design, survey administration, and data collection planning.
• Manage incoming data from applications, due diligence processes, grantee surveys, and internally generated datasets.
• Implement data intake validation procedures to identify incomplete, inaccurate, or inconsistent information at the source.
• Collaborate with data engineers and other analysts to validate, clean, and prepare incoming data for reporting and analysis.
• Execute automated data quality checks and monitor data integrity throughout collection and processing workflows.
• Review and update databases within assigned investment portfolios to maintain accurate, complete, and trustworthy information.
• Establish and reinforce consistent practices for recording, updating, and maintaining data across investment teams.
• Investigate data anomalies that may not be identified through automated back-end quality checks.
• Perform root cause analysis, communicate data quality issues to relevant stakeholders, and coordinate resolution activities.
• Provide stakeholder updates when data issues require additional investigation or cannot be resolved immediately.

• Serve as the primary analytics partner for assigned investment teams, developing a detailed understanding of their goals, reporting requirements, workflows, and data needs.
• Conduct ad hoc data analysis to support evidence-based investment decisions, strategic planning, and operational improvements.
• Translate analytical findings into clear written insights, recommendations, and decision-support materials.
• Prepare and respond to data analysis and reporting requests related to grants, funding partners, and investment portfolio performance.
• Use SQL, business intelligence platforms, and AI-assisted analytics tools to analyze datasets, answer business questions, and rapidly prototype analytical solutions.
• Develop custom SQL queries, reports, and datasets supporting research initiatives, learning agendas, investment strategies, Board requests, and funder reporting and prospecting.
• Create data visualizations, planning tools, and analytical frameworks that communicate performance trends and highlight promising investment portfolio outcomes.
• Incorporate historical, contextual, and comparative data into analyses to improve the accuracy and relevance of recommendations.
• Collaborate with research and investment stakeholders to ensure analytical outputs support strategic decisions and measurable impact.

• Provide organization-wide support for data questions, reporting tools, dashboards, and analytical systems.
• Help non-technical stakeholders access, interpret, and confidently use data for decision-making.
• Support the implementation and adoption of self-service analytics platforms within assigned investment teams.
• Provide onboarding, coaching, and ongoing assistance to users of dashboards, reporting tools, and analytical resources.
• Address additional data requests and reporting needs across organizational functions.

Qualifications

Required Experience

• Minimum 2 years of professional experience working with complex datasets and managing end-to-end data processes, including data collection, auditing, analysis, and interpretation.
• Experience managing data validation, data quality control, data cleaning, and database accuracy.
• Experience using business intelligence and analytics platforms to develop reports, dashboards, and self-service analytical resources for non-technical stakeholders.
• Project management experience coordinating recurring data collection processes involving multiple internal and external stakeholders.
• Experience translating analytical findings into actionable insights and recommendations for different audiences.
• Ability to manage multiple workstreams, establish priorities, and maintain effective analytical processes.

Required Skills

• Proficiency in SQL for querying, analyzing, and preparing structured datasets.
• Experience working with cloud data warehouse platforms, with BigQuery preferred.
• Experience using business intelligence and analytics tools, with Omni Analytics preferred.
• Ability to build and maintain dashboards, reports, data visualizations, and self-service analytics resources.
• Strong understanding of data validation, data integrity, data quality assurance, and data cleaning processes.
• Ability to conduct ad hoc analysis and rapid analytical prototyping using AI-assisted analytics tools.
• Ability to interpret complex quantitative and qualitative datasets and communicate findings clearly to technical and non-technical stakeholders.
• Strong analytical judgment when working with incomplete, inconsistent, or imperfect data.
• Ability to independently assess problems, recommend solutions, and determine when additional stakeholder involvement is necessary.
• Strong written and verbal communication skills, including the ability to present evidence-based recommendations and proactively raise questions or concerns.
• Ability to collaborate across data engineering, research, operations, and investment teams.
• Strong organizational and prioritization skills, with the ability to manage competing deadlines and multiple analytical responsibilities.
• Ability to identify inefficient processes, recommend continuous improvements, and adjust or discontinue approaches that are not delivering useful results.
• Ability to monitor relevant research, public data sources, and sector developments to identify emerging patterns, information gaps, and opportunities for analysis.

Preferred Qualifications

• Knowledge of the K-12 education sector, including experience working with teacher, school leader, and education technology data.
• Alternatively, knowledge of K-12 education with experience analyzing charter school, district school, or student data.
• Experience building and maintaining knowledge management structures that make portfolio data, research findings, and analytical resources reusable across teams.
• Experience supporting progress monitoring and research partnerships, including data collection planning and quality assurance.
• Experience implementing continuous improvement initiatives that increase operational efficiency and strengthen data management practices.