Senior Data Engineer

Planned Parenthood is the nation’s leading provider and advocate of high-quality, affordable sexual and reproductive health care for all people, as well as the nation’s largest provider of sex education. With more than 600 health centers across the country, Planned Parenthood organizations serve all patients with care and compassion, with respect, and without judgment, striving to create equitable access to health care. Through health centers, programs in schools and communities, and online resources, Planned Parenthood is a trusted source of reliable education and information that allows people to make informed health decisions. We do all this because we care passionately about helping people lead healthier lives.

Planned Parenthood Federation of America (PPFA) is a 501(c)(3) charitable organization that supports the independently incorporated Planned Parenthood affiliates operating health centers across the U.S. Planned Parenthood Action Fund is an independent, nonpartisan, not-for-profit membership organization formed as the advocacy and political arm of Planned Parenthood Federation of America. The Action Fund engages in educational, advocacy, and electoral activity, including grassroots organizing, legislative advocacy, and voter education. Planned Parenthood values the experience of employees, and our cultural ethos is “In This Together” which aims to support a workplace culture that centers on belonging, learning, and individual recognition.

Planned Parenthood Federation of America (PPFA) and Planned Parenthood Action Fund (PPAF) seek an innovative and detail-oriented Senior Data Engineer. This job reports to the Associate Director, Data Architecture in the Data Strategy and Analytics (DSA) division of PPFA. The DSA division provides critical data infrastructure and analytics solutions to support fundraising and supporter engagement programs essential to achieving the organization’s mission through advocacy, education, and access to equitable care.

Purpose:

The Manager, Data Engineering constructs and optimizes data systems to support campaign services and the Development organization. This role explores innovative solutions, highlights opportunities for improvement in data processes, and specifies strategies that ensure the reliability and scalability of data infrastructure to drive organizational success. This role ensures data engineering efforts align with departmental and divisional goals, supporting overall organizational objectives.

Delivery:

• Assess and implement data engineering frameworks that support campaign services and the Development organization, ensuring scalability and efficiency.
• Deliver platform-agnostic data solutions, including the design and development of data warehouses and lakes, to enhance reporting and analytics capabilities.
• Organize and manage defect analysis and troubleshooting processes to quickly resolve issues and maintain operational continuity.
• Complete data pipeline optimization tasks to support campaign execution and ensure the accuracy and availability of data for strategic decision-making.
• Set rigorous standards for data quality, integrity, and security, aligning with organizational objectives and compliance requirements.
• Establish technical workflows and performance metrics to measure the success and reliability of all deliverables.
• Other duties as assigned

Engagement:

• Works with cross-functional teams to analyze data requirements for campaign services and development initiatives, ensuring alignment with organizational priorities.
• Advise stakeholders on innovative data strategies, engineering solutions, and design improvements to optimize campaign delivery and support strategic development goals.
• Communicate progress, insights, and challenges related to data solutions and campaign service integration, emphasizing opportunities for streamlining processes and improving outcomes.
• Build internal partnerships to align data engineering efforts with the evolving needs of campaign services and the Development organization, ensuring strategic initiatives are fully supported.
• Make teams and partners aware of industry best practices in data engineering, emphasizing streamlined code, efficient workflows, and improved reliability.
• Engage with external technical partners to resolve critical issues, integrate advanced solutions, and drive strategic engineering initiatives that enhance campaign and development outcomes.

Knowledge, Skills, and Abilities (KSAs):

• 5 years of related work experience
• Advanced expertise in data engineering, including data pipeline design, warehouse and lake development, and ETL frameworks.
• Proficiency in troubleshooting, defect analysis, and the resolution of technical issues in support of campaign and development initiatives.
• Strong ability to develop platform-agnostic solutions that align with organizational needs and drive campaign success.
• Experience with metrics-driven quality assurance practices and the implementation of data integrity standards.
• Advanced knowledge of SQL, Python
• Understanding of DBT, Redshift preferred
• Proven skills in collaborating with diverse teams and advising on technical frameworks to meet organizational goals.
• Strong analytical and communication skills to ensure alignment across stakeholders and initiatives.
• Self-directed and can work alone or in a team.
• Commitment to PPFA’s mission and diversity, equity, and inclusion, particularly surrounding race equity
• A deep commitment to Planned Parenthood’s mission of promoting Sexual and Reproductive Health

Travel:

5-10% Domestic

Total offer package to include generous vacation + sick leave + paid holidays, individual/family provided medical, dental and vision benefits effective day 1, life insurance, short/long term disability, paid family leave and 401k. We also offer voluntary opt-in for Flexible Spending Account (FSA) and Transportation/Commuter accounts.

We value a truly diverse workforce and a culture of inclusivity and belonging. Our goal is to attract qualified candidates and encourage applications from all individuals without regard to race, color, religion, sex, national origin, age, disability, veteran status, marital status, sexual orientation, gender identity, or any other characteristic protected by applicable law. We're committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation.

PPFA participates in the E-Verify program and is an Equal Opportunity Employer.

#LI-SY1

PDN-HR

Roles that are denoted as NYC, DC, or both will work a hybrid schedule and are expected to work in their assigned PPFA office a minimum 2 days per week unless the role is denoted as onsite, which requires working onsite full time or 5 days per week.