Skip to content

Analytics Engineer

DonorsChoose LogoDonorsChoose
View Organization

Salary

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.

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: (1) data transformation systems (we use dbt); (2) using SQL for data analysis and data modeling; (3) BI reporting tools such as Looker, Tableau, PowerBI (we use Looker); (4) cloud data pipelines such as Fivetran, Stitch, Airbyte (we use Fivetran); (5) 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.

‌