Analytics Engineer

Analytics Engineer

This job is no longer open

DonorsChoose makes it easy for anyone to help a teacher in need, moving us closer to a nation where students in every community have the tools and experiences they need for a great education.

Since 2000, more than 5 million people and partners have contributed $1 billion to support 2 million teacher requests for classroom resources and experiences. Projects range from art supplies to build the set for a school musical, to books and puzzles that affirm students’ identities, to bird seed for an at-home science project. We proudly serve all US public schools, public charter schools, and Head Start centers, and we combat systemic inequity by driving a majority of donations to schools that have been historically underfunded due to economic and racial inequity.

DonorsChoose has been recognized as a best place to work by GOOD Magazine and the Nonprofit Times, while Fast Company named DonorsChoose one of the 50 Most Innovative Companies in the World—the first time a charity has made this list. Our dedicated team works from across the United States bring classroom dreams to life.

About the Data Science & Analytics Team

This position is a part of the Data Science & Analytics team, which is located in the Product, Engineering, and Data department. Currently, the team consists of four members: a Director, a Data Scientist, an Analytics Engineer, and a Looker Analyst. The team is distributed across EST and PST time zones. Additionally, the Data Science & Analytics team collaborates closely with a talented group of engineers who work on the transactional system.

At DonorsChoose, data is not only a critical component of our product and business strategy but also a fundamental driver of our social impact. We use data extensively across the organization, from tracking website traffic and donor behavior to measuring the impact of funded projects on student outcomes. As a result, most teams have a high level of data maturity, with a strong understanding of how data can inform decision-making and drive results.

You will work closely  with our existing Analytics Engineer and the team to handle SQL transformations for critical data sources and products. This will allow us to provide more proactive analytics user support and create more efficient machine learning models for the product.

About the Role

DonorsChoose is looking for an Analytics Engineer to join our high-performing Data Science and Analytics team. Our ELT stack includes Fivetran, Redshift, dbt, and Looker. We track our data projects in Jira, and have an engaged Data Working Group to help set priorities across the organization.

As our Analytics Engineer, you will be responsible for building and maintaining data flows integrated from a variety of source systems and continuing to push DonorsChoose as an innovator in crowdfunding and education equity. 

You'll have the opportunity to shape the architecture of our data analytics platform. Your expertise will be a central part of framing our data strategy, aligning it with our organizational goals, and driving innovation. You will collaborate closely with stakeholders and make a meaningful impact on how we utilize data.

Our Product, Engineering, & Data team fosters a casual work environment rooted in work-life balance where everyone’s input and ideas are valued. We believe that our employees are our most valuable resource and intentionally invest in their creativity and growth. If you care deeply about equity, collaboration, and using data for social good, this position is right for you.

In this role, you will:

  • Provide fresh, clean data sets to end users across the org, modeling data in a way that empowers end users to answer their own questions. 
  • Transform, test, deploy, and document data from sources such as the DonorsChoose Web System, Heap, Zendesk, Salesforce and our email and SMS marketing systems. 
  • Clearly document and communicate data issues, collaborate with others to implement resolutions.
  • Apply software engineering best practices like version control, naming conventions, and continuous integration to the analytics code base.
  • Optimize performance of the Redshift cluster, and help evaluate future platforms.
  • Help us evaluate and implement any future BI/analytics tools.
  • Helping us migrate all our existing Looker Persistent Derived Tables (PDT’s) to dbt models.

You may be perfect for this role if you have:

  • 2+ years developing and maintaining data flows using modern data stack technologies such as:
    • data transformation systems (we use dbt)
    • using SQL for data analysis and data modeling
    • BI reporting tools such as Looker, Tableau, PowerBI (we use Looker).
    • cloud data pipelines such as Fivetran, Stitch, Airbyte (we use Fivetran).
    • data warehouse environments such as Redshift, BigQuery, Snowflake (we use Redshift).
  • Experience setting up development infrastructure for continuous integration.
  • Experience with general programming languages (Python, Javascript, etc).
  • Previous experience in a software engineering or data analysis/data science role. 
  • In-depth perspectives on effective strategies for data aggregation and denormalization for analytics purposes.
  • A commitment to details and consistency that doesn’t block progress.
  • Passion for rigorous use of data as a tool for racial justice and educational equity.

Compensation and Benefits

Our compensation philosophy ensures that we are both externally competitive with tech-forward nonprofits of a similar size and internally fair in our pay practices. The following ranges represent the target offer range given the scope and experience expectations for this role.

  • The hiring salary range for this role is $95,000-$113,000
  • We have a hiring salary range of $106,000-$125,000 for specific higher cost of labor locations, which include New York City, San Francisco, Los Angeles, Seattle, Boston, and Washington, D.C.

Once employees are hired, everyone at DonorsChoose is eligible to receive annual performance-based raises as they grow in their role. We are open to a variety of experiences, and recognize that the person we hire may be less experienced or more senior than this job description as posted. If you don’t check every box listed here, or you know you’d bring additional experience to the table, we hope you’ll submit your application.

In addition, we offer full-time staff 25 paid vacation days per year and 11 paid holidays, a rich employer-paid individual and family health plan, a matching 401(k) plan (up to 5% of base salary), annual professional development stipend, and casual and flexible work environment. To learn more about what it is like to work for DonorsChoose, visit our careers page.

Hybrid Workplace and Other Details

In this role, you’ll have the option to work a flexible hybrid schedule in our NYC office, or to work fully remotely from CA, CO, CT, DC, FL, GA, IL, IN, ME, MA, MD, MI, NJ, NY, OR, PA, RI, TX, VA, WA, or WI. 

Candidates who are not in the NYC area should expect to travel to our NYC office on an as-needed basis, about 4-6 times per year.

DonorsChoose participates in E-Verify. We will provide the U.S. Social Security Administration (SSA) and, if necessary, the U.S. Department of Homeland Security (DHS) with information from each new employee’s Form I-9 to confirm work authorization.

To Apply

Please submit your resume and answer the application questions online. Since we’re trying to get to know you through our hiring process, we ask that you please refrain from using AI writing tools to craft your response to our application questions. A cover letter is optional and may be addressed to Oliver Hurst-Hiller, CTO & Head of Product.

A Final Note

The DonorsChoose team works toward a nation where students in every community have the resources needed for an excellent education. To do this we hire and support a diverse team of the best and the brightest talent available.

We are an organization increasingly representative of the varied races and ethnicities, genders and sexual orientations, religious and political beliefs, and abilities that comprise our nation. DonorsChoose focuses on attracting, retaining, and advancing diverse talent because it makes us more effective, high-performing, creative, and resilient.  

If you are passionate about our mission, highly skilled in your field, and looking for a place where you can bring all of yourself to work, we want you.

This job is no longer open
Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.