Data Systems Engineer
San Francisco, CA / Cambridge, MA
The Center for Effective Philanthropy (CEP) seeks an experienced, full-time engineer. As the go-to technical expert in the room, the Data Systems Engineer will be instrumental in projects that improve the organization’s use of data, identify and drive efficiencies in our processes, and work closely with staff to maintain and upgrade our online reporting system – a secure online portal that allows users the opportunity to interact with and analyze data CEP collects. To that end, the Data Systems Engineer will build and develop cloud-based data pipelines and architecture while maintaining and improving back-end Python applications for this system, which is used to develop and deliver CEP’s assessment tools to foundation leaders and YouthTruth’s student survey reports to schools, districts, and networks nation-wide. This position is available in either our San Francisco, CA or Cambridge, MA office. In this role, you will lead and execute a variety of tasks, including:
- Leading and implementing the majority of the core code infrastructure
- Designing and improving existing cloud-based data pipeline using Fivetran, DBT, RDMS
- Creating, monitoring, and maintaining a cloud-based architecture (AWS)
- Maintaining (debugging, deploying, improving, and testing) legacy code written in Python
- Serving as a thought partner with colleagues and internal stakeholders about the feasibility and time intensiveness of proposed projects
- Testing and successfully deploying new features to CEP’s proprietary web-based application
- Mentoring junior/novice staff in their programming skills
Your time will be spent on CEP- and YouthTruth-related projects, as both teams use the same platforms.
The Ideal Candidate:
- You exhibit excellent judgment and have the ability to work independently and with minimal direction to support your data and client analyst colleagues in a fast-paced environment while being thorough and results-oriented
- You take pride in your work and employ the necessary steps to ensure the production of succinct and high-quality code
- You have exceptional communication skills; someone who is collaborative and excited to work cross functionally while building relationships and generating influence across the company
- You have the desire to continue to evolve our cloud-focused data ingestion and translation architecture, while helping to define and build new capabilities upon it to better serve our customers
- You can proactively generate new ideas about the evolution of our systems
Your Background, Experience, and Interests:
- Experience with the following data tools and programming languages: Python, SQL, DBT, and Fivetran
- At least 5 years’ experience as a software engineer, programmer, data analyst, engineer, or similar, in a full-time role
- Experience using Python with data sets
- Experience with SQL language and tools to help build data transformation models
- Understanding of cloud architectures and their applications within a data driven environment
- Experience with code management and review such as Github
- A degree (or related practical experience) in computer programming, or related field
What makes you stand out:
- An aptitude for continuous improvement within processes and disciplines, helping to evolve from current state into leveraging new mindsets and approaches
- Experience with AWS, data modeling and implementation, and/or Ruby on Rails a plus but not necessary
Our nonprofit model is central to our identity: our bottom line is impact, not profit. Yet even as a nonprofit, we successfully compete for top talent across both the public and private sectors and offer competitive compensation and benefits, including:
- A commitment to pay parity and salary equity. The annual base salary for this position is $118,000 (Cambridge)/ $129,000 (SF). In addition, this role is eligible for a competitive Performance Based Incentive Compensation.
- Comprehensive health and dental insurance plans.
- Generous paid time off plan, including up to 15 holidays, three weeks of accrued vacation, and two personal days per year.
- 401(k) plan with a 1:1 Employer Match up to 5% of total compensation.
- Generous annual personal professional development allowance.
- Flexible spending and dependent care tax free savings plans.
- Life insurance covered 100% by the organization.
We believe diversity and inclusion are key drivers of creativity and innovation, and we actively seek out candidates from many types of diverse backgrounds to apply for this exciting role.
We have offices in Cambridge, Massachusetts and San Francisco, California, where the YouthTruth team resides alongside staff in other departments at The Center for Effective Philanthropy (CEP), YouthTruth’s parent nonprofit. This role will be based in our San Francisco or Cambridge, MA office.
We strive to balance in-person time with flexibility and the needs of each person, their team, and the larger organization. We believe culture, communication, trust, training, and certain kinds of creative work benefit from in-office interactions – and we believe that the flexibility of remote work also has many advantages. We are currently experimenting with a minimum of one day per week in the office through November 2022 and may move to additional days per week from there. Everyone will enjoy the option to work fully remotely from anywhere four weeks per year.
For 21 years, CEP has led the movement to improve philanthropy through a powerful combination of dispassionate analysis and a passionate commitment to improving lives. Today, over 350 foundations around the world have used CEP’s assessment tools to gather honest feedback from their stakeholders in an effort to learn how to be even more effective. CEOs and trustees have come to rely on our research for insights into foundation effectiveness on a wide range of topics, from assessing performance to developing strategy to managing stakeholder relationships. Our highly regarded programming—including our biennial conference—gives foundation leaders an exclusive and unprecedented opportunity to connect with their peers.
We believe, and research shows, that student and stakeholder feedback matters for school improvement and student success. That’s why, in 2008, we created YouthTruth – to help educators harness student and stakeholder feedback to accelerate improvements. We’ve heard from over two million students as well as hundreds of thousands of family and staff members across 39 states. When you join YouthTruth, you join a small and collaborative team that has a big impact on schools across the U.S. and the education sector.
Strengths of CEP’s work culture are entrepreneurialism, accountability, teamwork, collegiality, diversity, and mutual respect.
Please fill out our application for employment and attach a resume and thoughtful cover letter, outlining how your skills and experience meet the qualifications of the position.
If you have any questions, please contact Leaha Wynn, Senior Manager, People and Culture; Diversity and Inclusion Strategist at jobs [at] cep[dot] org. Applications will be reviewed on a rolling basis.
We believe that a diversity of thoughts, experiences, backgrounds, personalities, and identities helps us think bigger and better, and enables us to reach our goals more effectively. We are committed to building a diverse staff and encourage individuals from all backgrounds to apply.
Once a candidate begins our process, we discourage outreach to our staff for interviews or conversations that are outside our standard interview process. We have worked hard to design a process that is fair and rigorous and achieves a good match between candidates and CEP/YouthTruth.
We evaluate candidates based on their merits. We strongly discourage unsolicited references. We will ask for references if and when a candidate reaches a finalist stage.