Data Analyst

This is a fully remote position, open to applicants in United States.

📋 Description

• Take ownership of data stewardship, quality assurance, analytics, and impact metrics for a specific investment team.

• Convert learning agendas into metric definitions, data structures, processes, and communications for stakeholders.

• Create and uphold both quantitative and qualitative data collection processes.

• Identify gaps in data and tools, and propose enhancements for warehouse, infrastructure, self-service, and research capabilities.

• Maintain a solid understanding of the data warehouse, business intelligence tools, and public data infrastructure.

• Oversee the project management of annual data collection cycles, which includes rostering, survey development, and administration.

• Manage data intake, validation, cleaning, quality control checkpoints, and updates to the database.

• Examine data anomalies, identify their root causes, and manage communications with stakeholders.

• Act as the analytics partner and reliable data resource for designated investment teams.

• Lead ad hoc analyses and consolidate findings into investment recommendations.

• Address reporting and analysis requests for grant and funder documentation.

• Utilize SQL, BI tools, and AI-assisted analytics for analysis and quick prototyping.

• Collaborate on custom queries and datasets for learning agendas, team strategies, Board requests, and funder reporting and prospecting.

• Develop planning tools, analysis frameworks, and visualizations to derive insights and highlight portfolio strengths.

• Assist non-technical colleagues in navigating data systems and dashboards.

• Promote the adoption of self-service analytics tools through onboarding, coaching, and ongoing support.

• Provide ad hoc data support throughout the organization.

⛳️ Requirements

• At least 2 years of experience working with complex data sets and managing end-to-end data processes, including collection, auditing, analysis, and interpretation.

• Proficient in SQL.

• Familiarity with cloud data warehouse platforms; BigQuery is preferred.

• Experience with BI/analytics tools; Omni Analytics is preferred.

• Skilled in creating self-service artifacts and reporting for non-technical users.

• Experienced in data validation, quality control processes, and data cleaning.

• Project management experience, especially with recurring data collection cycles involving various internal and external stakeholders.

• Comfortable using AI-assisted analytics tools for ad hoc analysis and rapid prototyping.

• Knowledge of the K-12 education sector, with experience working with teacher, leader, and edtech data or charter, district school, and student data is highly preferred.

• Authorized to work for any employer within the United States.

• Willing to travel up to 10% for in-person team meetings, retreats, and conferences.

🏝️ Benefits

• Performance bonus of up to 5% annually.

• Employer-funded benefits.

• Fully remote work opportunities.

• Up to 10% travel for in-person team meetings, retreats, and conferences.