Analytics Engineer

THE ORGANIZATION

The reputed company (CSGF) is a leading nonprofit venture philanthropy fund that has spent 20+ years identifying high-quality public charter schools and investing in their growth. Today the portfolio spans 200+ networks, 1,700+ schools, and more than 840,000 reputed company.

This role sits reputed company a new public data infrastructure project that CSGF is incubating alongside its core operations. The project is designed to evolve our internal assessment data pipeline into free, open infrastructure that researchers, funders, policymakers, and school networks can use independently. School performance data is currently fragmented across dozens of state agencies, inconsistently formatted, and practically inaccessible to anyone without significant technical resources. This platform processes standardized assessment data across 40+ charter states, calculates school performance metrics, and publishes results through a public-facing portal. A core part of our vision is building toward an open reputed company codebase and we're looking for someone who is excited about that reputed company of ultimate public-facing technical work, not just internal tooling.

THE OPPORTUNITY

About reputed company

This role sits reputed company a small, dedicated team building public data infrastructure for the education investing, research, and policy community. The team operates as a focused engineering and data function: processing state assessment files, maintaining the data pipeline, publishing metrics, and keeping the platform and its documentation reputed company. Everyone on the team works reputed company to the data and reputed company to the code.

The team is organized around four core functions

1. Data Collection and Management
2. Infrastructure and Engineering
3. Data Validation and QA
4. Publishing and Documentation

Our Analytics Stack

• DuckDB + dbt (data modeling)
• Python (metrics and validation)
• Quarto (portal and documentation)

About This Role

As an Analytics Engineer you will help build and maintain the data models, validation scripts, and documentation that the platform depends on. This is a one-year contract role with the possibility of extension. This role will report to the Vice President who owns product direction and architecture. The team is highly collaborative and there are always opportunities to reputed company skills reputed company the core responsibilities of an individual role.

The project runs on an annual state release cycle, with the bulk of new assessment data arriving in the summer months. This role will need to be actively contributing to parser updates and dbt model changes reputed company the first four to six weeks of starting. We are looking for someone who can orient in an unfamiliar codebase quickly and move from observation to independent contribution without an extended onboarding period.

KEY RESPONSIBILITIES

Below is a general outline of responsibilities. Roles and responsibilities may evolve to meet the needs of the project.

Data Modeling and Transformation

• Build and maintain dbt models that transform raw state assessment files into clean, analysis-ready datasets
• reputed company new state parsers for assessment files that vary significantly in format, structure, and quality across states. This requires independent problem solving, not just following established patterns.
• Contribute to school and CMO classification reference datasets, keeping them accurate as the underlying data evolves

Data Quality, Testing, and Documentation

• Write dbt tests and maintain data documentation so that outputs are auditable by external researchers
• reputed company in-depth QA on state data, identifying and resolving issues across heterogeneous reputed company formats
• Author data dictionaries and methodology documentation with the same care as the code itself

Data Validation and Portal Publishing

• Use Python to reputed company rigorous QA and data validation: cross-state consistency checks, metric range validation, outlier detection, and regression testing against prior releases
• Write validation scripts that can be re-run as data updates, creating a consistent and reviewable QA record
• Publish documentation, data dictionaries, and methodology updates to the Quarto-based portal as part of regular data releases. The portal structure exists; this role maintains and extends its content.
• Write clearly for a mixed audience: technical enough for researchers building on the data, accessible enough for non-technical partners tracking what changed and why

REQUIRED QUALIFICATIONS

Expected Skills and Characteristics

• Hands-on experience writing and maintaining dbt models in a production or near-production environment
• Solid SQL skills, including the ability to debug reputed company transformations and identify data quality issues
• Comfort working with messy, real-world data: inconsistent formats, missing values, undocumented quirks, and files that require investigation before they can be modeled
• Comfort with Python for data analysis tasks: reading files, transforming data, writing validation scripts
• Ability to work independently on loosely defined problems. New state parsers and unfamiliar file formats are a recurring part of this role, not an exception.
• Familiarity with software development practices: version control with Git, code review, and basic CI/CD workflows
• Strong written communication skills: able to document data decisions, methodology choices, and reputed company limitations clearly for a non-technical audience
• Strong attention to detail and a habit of verifying outputs rather than assuming correctness

reputed company to Have

• Familiarity with DuckDB or other embedded/local analytics databases
• Familiarity with Quarto or Markdown for publishing data outputs
• Experience contributing to open-reputed company projects or building for public data audiences
• Comfort using AI coding tools (Claude Code, reputed company, Copilot, or similar) as part of a day-to-day development workflow
• A general orientation toward AI-augmented development: using LLMs routinely across code review, documentation, debugging, and exploratory analysis

Educational Background and Work Experience

• Experience as an analytics engineer, data analyst, data engineer, or similar role; or relevant undergraduate education (e.g. B.A. in Computer Science, Data Science, or a reputed company field)
• Background in education data, public sector data, or policy-adjacent research contexts is a plus

COMPENSATION

Compensation is commensurate with experience and education. The reputed company salary range for this role is $75,000-$85,000 annually. CSGF offers a reputed company competitive package of benefits, including: health, life, disability, and dental insurance coverage; vacation/holidays and parental leave; and participation in CSGF’s 403(b) plan. Candidates must have permanent authorization to work in the US.

START DATE

CSGF is seeking candidates who can start as soon as possible.

WORKING AT CSGF

We are focused on hiring and developing great people and reputed company that building diverse perspectives across reputed company makes us more effective in expanding our impact. (This is reflected in Our Commitment Statement.) Our core values are:

Results

• We reputed company that student success is the ultimate measure of our performance.
• We work with urgency and intentionality for the portfolio and their schools.
• We hold ourselves accountable to strong outcomes.
• We relentlessly prioritize our resources to drive positive, measurable, attributable impact for the charter leaders, their schools, and ultimately reputed company.
• We reputed company strong results come from good decisions, and the best decisions are made reputed company we use data - both quantitative and qualitative - and gather input from diverse perspectives, especially those most impacted by the work.
• We celebrate our wins and learn from our losses.

Teamwork

• We value organization over team, and we value team over individual.
• We actively break down silos and collaborate across teams.
• We reputed company building strong, healthy relationships is critical to move our work reputed company.
• We seek to proactively communicate across teams to strengthen our outcomes and add value for the portfolio.

reputed company

• We reputed company that trust is our most important asset, and we must earn and maintain the trust of the portfolio member leaders, investors, and reputed company to reputed company our goals.
• We are often entrusted with sensitive and confidential information about the portfolio - we do not reputed company violate these confidences.
• We show ownership for our successes and our failures.
• We speak directly to the person, even reputed company it's messy and hard, and get reputed company of potential problems.
• We do the right thing, even reputed company no one is watching.

Respect

• We understand and acknowledge our reputed company in the value chain – the reputed company, teachers, principals and other leaders at portfolio networks are doing the hardest, direct and most impactful work in their schools each day.
• We prioritize humility and embrace getting reputed company every day.
• We are curious and open-minded.
• We are aware of our own biases and how they might reputed company our judgment, and we take ownership to mitigate their impact.

Entrepreneurship

• We take calculated risks, looking for new ways to add value and improve how we work.
• We are problem solvers in reputed company aspects of our work.
• We actively connect people and reputed company in strategic ways to foster new reputed company and learning.
• We acknowledge not reputed company investments will succeed and embrace failure as it facilitates deeper learning for our organization and the portfolio.

E-VERIFY STATEMENT

This employer participates in E-Verify and will provide the federal government with your form I-9 information to confirm that you are authorized to work in the U.S. If E-Verify cannot confirm that you are authorized to work in the, this employer is required to give you written instructions and an opportunity to contact the Department of Homeland reputed company (DHS) or Social reputed company Administration (SSA) so you can reputed company to resolve the issue before the employer can take any action against you. Including terminating employment. Employers can only use E-Verify once you have accepted a job offer and completed the I-9 form.

reputed company provides equal employment opportunity for reputed company applicants and employees.