The Charter School Growth Fund (CSGF) is a leading nonprofit venture philanthropy fund dedicated to identifying the nation’s best public charter schools, investing in their expansion, and helping to increase their impact. Our “portfolio” includes 200+ charter school networks that operate 1,700+ schools and serve more than 725,000 students. We are committed to expanding the impact of schools that are closing achievement and opportunity gaps. CSGF operates with the same strategies, discipline, and focus as a venture capital firm by awarding multi-year grants and loans to talented education entrepreneurs building networks of high-quality charter schools that enroll traditionally underserved students. Ultimately, we think the portfolio can grow to serve ~1,000,000 students within a decade.

This is an exciting time to join the Charter School Growth Fund. We are midway through a philanthropic fund building on our 15-year track record of success. CSGF’s five-year “Fund IV” is larger in size and scope than previous funds, with a goal to continue to fuel charter sector growth, accelerate innovation, and strengthen long-term outcomes for students, particularly students of color and those from low-income backgrounds. Our new fund will continue to prioritize investments in leaders of color as our current portfolio is led by more than 50% leaders of color and more than 50% female leaders. We believe it is vital for the networks we support to be proximate to the lived experiences of the students and communities they serve.

THE OPPORTUNITY

About Our Team

With the launch of the next philanthropic fund, the Analytics team is expanding and evolving to meet the growing needs of an ever increasingly data driven organization. The Analytics team sits at the intersection of our investment, impact, innovation, policy, finance, and talent teams which all have data needs to drive their goals. The Analytics team also serves the need to progress monitor CSGF’s key performance indicators that measure our impact across the network. These insights are shared internally as well as with our many funders. In addition, we seek to expand the role of analytics to provide direct analysis support to our growing portfolio of charter school networks. To accomplish this, we leverage nationally collected data sets from a variety of sources and provide flexible and timely analysis to our many stakeholders and partners.

The team is made up of four core functions:

1. Data Collection & Management
2. Infrastructure & Engineering
3. Self-serve Analytics
4. Data Science

Our Analytics Stack

1. Google Cloud (backbone architecture)
2. BigQuery (data warehouse)
3. dbt Cloud (data modeling/monitoring)
4. Tableau (data visualization)

About This Role

As a Junior Analytics Engineer you will help build the analytical models our analysts depend on to meet the needs of our stakeholders. This is a one-year contract role with the possibility of extension. This role will report to our Analytics Engineer. This role is great for an engineer looking to break into the field and will have ample opportunities for professional development. Our team is highly collaborative and there are always opportunities to develop skills outside the core responsibilities of an individual role. We aspire for full-stack data analytics professionals across our team.

Within the first 30 days of taking on this role you will get to know the team and start working with all parts of our data stack and tooling. You will engage in pair programming to orient with our existing codebase and begin contributing towards documentation and testing. By the end of your first 60 days, you will be actively engaged in our QA process and contributing to the codebase with bug fixes and updates to models. At the end of your first 90 days, you will be contributing towards large scale refactors of existing models. We’ll also ask you to provide feedback on the team’s onboarding processes based on your experience.

KEY RESPONSIBILITIES

Below is a general outline of responsibilities. CSGF is a fast-moving organization, roles and responsibilities may change to meet the needs of the organization and the charter networks we support.

Data Transformation and Modeling

1. Provide clean, transformed analysis-ready data sets to analysts and stakeholders, modeling data in a way that empowers end users to answer their own questions
2. Submit solutions for peer code review as well as provide feedback to peers on their solutions.

Data Quality, Testing, and Documentation

1. Create documentation and testing to ensure that our data sources are accurate and easily understood
2. Perform in-depth QA by diving in to various data sources to identify and resolve issues
3. Troubleshoot bugs in the existing codebase and provide timely solutions

REQUIRED QUALIFICATIONS

Expected Skills and Characteristics

1. Experience using SQL to transform raw data into actionable insights
2. Familiarity with dbt for data modeling and transformation
3. Familiarity with software development best practices and their applications to analytics (version control, testing, CI/CD, automation).
4. Familiarity with cloud data warehouse solutions (ex: Redshift, BigQuery, Snowflake)
5. Strong attention to detail and focus on accuracy
6. Capacity to quickly learn new skills, seek honest feedback from peers and mentors, and know when to ask for help

Educational Background and Work Experience

1. 1+ years of full-time work experience as an analytics engineer, data analyst, BI analyst, data engineer or similar undergraduate education (ex. B.A. in Computer Science)
2. Experience in education/non-profit field is a plus

COMPENSATION

Compensation is commensurate with experience and education. The target salary range for this role is $75,000-$85,000 annually. CSGF offers a very 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; flexible for the ideal candidate.

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, this employer is required to give you written instructions and an opportunity to contact the Department of Homeland Security (DHS) or Social Security Administration (SSA) so you can begin 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.

Charter School Growth Fund provides equal employment opportunity for all applicants and employees.

Are you looking for remote jobs near your area? At Yulys, thousands of employers are looking for exceptional talent like yours. Find a perfect job now.