Data Engineer

Planned Parenthood Federation of America is the nation’s leading provider and advocate of high-quality, affordable sexual and reproductive health care. The Data Engineer will construct and optimize data systems to support campaign services and the Development organization, ensuring data engineering efforts align with departmental and divisional goals.

Responsibilities:

• 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
• 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

Requirements:

• 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
• 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
• Understanding of dbt, Redshift