Senior Specialist, Data Engineer
Posted Updated
Description
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 U.S. PPFA also works to educate the public on and advocate for issues of sexual and reproductive health. Formed as the advocacy 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.
Planned Parenthood Federation of America (PPFA) and Planned Parenthood Action Fund (PPAF) seek a conscientious and collaborative Manager, Data Engineer. This job reports to the Director, Data Architecture in the Data Architecture & Governance department within the Development Data, Operations & Technology (DOT) division. The Data Architecture & Governance department is responsible for designing and governing a scalable, enterprise data ecosystem that enables end-user fundraising goals and organizational strategy
Purpose:
The Data Engineer helps to build, maintain, and manage the Development Division’s data infrastructure. They work with the Director and team colleagues to monitor and troubleshoot key data pipelines and integrations between platforms.
Delivery:
The Data Engineer executes assigned tasks with utmost accuracy while meeting deadlines.
- Prepares project-specific timelines and proactively communicates status updates within the team and to stakeholders.
- Tracks and maintains projects through project management software including updating tasks and following up with stakeholders on progress.
- Identifies and reports potential process conflicts in timing or criteria.
- Produces technical diagrams and documentation.
- Monitors and troubleshoots key data pipelines and integrations between platforms.
- Optimizes SQL scripts and processes for efficiency and reliability.
- Contributes to the standardization of data products to promote ease of use and maintenance.
- Develops and executes quality control measures including creating tests in dbt.
- Performs other duties as assigned
Engagement:
Contributes to the team’s success through excellent customer service to both internal and external analysts, strategists, and coordinators.
- Communicates about task progress, outcome, and deadlines clearly and promptly
- Follows team norms, and contributed to building respectful, trusting relationships with internal data staff and outside vendors
- Utilizes careful listening to identify opportunities to improve the data staff’s services to PPFA
- Engage external partners/affiliates on identifying deliverables, timeframes, and expectations regarding service delivery.
Knowledge, Skills and Abilities (KSAs):
- Bachelor’s degree with 2+ years of experience in data engineering required, preferably in a nonprofit setting.
- Strong organizational, analytical, and problem-solving skills
- Proven ability to work collaboratively in a team environment as well as independently when required.
- Understanding of engineering principles, concepts, and methodologies.
- Experience with SQL required.
- Experience with dbt, Amazon Redshift, and CRMs such as Salesforce preferred.
- Flexibility and ability to adapt to quickly changing priorities and ambiguous situations.
- 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
Skills
As published by lever · 14 questions · 2 written answers
Basics
Kindly specify your current location., Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, Other website
Short answers (2)
- If you have worked at PPFA and/or a Planned Parenthood affiliate, please provide the name of your specific employer(s) below (e.g. PPFA, Planned Parenthood affiliate name). optional
- If you were referred, please list their name optional
Pick from a list (10)
- Are you legally eligible for employment in the US?
- Do you now or will you in the future require sponsorship to work in the US?
- Planned Parenthood Employment History: Please choose the option(s) that correctly applies to you. optional
- Were you referred by a PP employee? optional
- Conflict of Interest Disclosure: To ensure transparency and maintain the integrity of our hiring process, we ask all applicants to disclose any potential conflicts of interest. Please answer the following questions: Do you or any of your family members (e.g., spouse, domestic partner, parent, child, sibling, grandparent etc.) currently serve on the board of, or hold a leadership position within, our organization? optional
- Do you or any of your immediate family members have a history of major financial contributions to our organization? optional
- PPFA has an in-office work culture, centering employee well-being. If NOT marked as remote/telecommuter, this job would require you to report to the DC or NY office at least two days per week. Are you agreeable to this requirement?
- If this role requires being based in DC or NYC in order to report onsite to PPFA's premises at least 2 days a week. Can you confirm you meet this role requirement and are currently located in DC or NYC? optional
- If you are not currently based in DC or NYC, are you planning to relocate? optional
- Where did you hear about this job? optional
Written answers (2)
- Please list your dates of employment at PPFA and/or any Planned Parenthood affiliates. Start Date: (M/Y) - End Date: (M/Y)
- If you heard about this role on a job board not listed above, please specify here. optional