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. Planned Parenthood organizations serve all people 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, which operate non-profit health centers across the USA. PPFA also works to educate the public on and advocate for issues of sexual and reproductive health. Formed as the advocacy and political arm of Planned Parenthood Federation of America, Planned Parenthood Action Fund is a separate non-profit membership organization tax-exempt under section 501(c)(4). The Action Fund engages in educational, advocacy, and limited electoral activity, including grassroots organizing, legislative advocacy, and voter education in furtherance of the Planned Parenthood mission.

PPFA and the Action Fund seek an innovative and detail-oriented 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 Data Engineer constructs and optimizes data systems to support campaign services and the Development organization and is an individual contributor position on a lean team, and is expected to primarily code. 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.

Planned Parenthood's cultural ethos, "In This Together", reflects our commitment to building a workplace culture that fosters belonging, promotes learning throughout the employee lifecycle, and recognizes individual contributions to our mission.

Planned Parenthood Federation of America participates in the E-Verify program. Planned Parenthood Federation of America is an equal employment opportunity employer and is committed to maintaining a non-discriminatory work environment, and does not discriminate against any employee or applicant for employment on the basis of race, color, religion, sex, national origin, age, disability, veteran status, marital status, sexual orientation, gender identity, or any other characteristic protected by applicable law.  Planned Parenthood Federation of America is committed to creating a dynamic work environment that values diversity and inclusion, respect and integrity, customer focus, and innovation.

#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.