Associate Director, Data Engineering and Reporting

Planned Parenthood Federation of America • Washington, DC

8d • $110,000 - $115,000

About The Position

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 (Action Fund)seek a dynamic and collaborative Associate Director of Data Engineering and Reporting. This job reports to the Senior Director of Data, Analytics, and Research in the Research and Policy department. The Research & Insights team provides strategic, data-driven guidance to the External Affairs division and supports the critical work of the national and local Planned Parenthood organizations to conduct equitable, efficient, and effective campaigns.

Purpose:
The Associate Director contributes to Planned Parenthood’s mission by planning, designing, and producing actionable reports, integrating data from new tools into our existing ecosystem, and managing our supporter database. As a member of PPFA’s Research & Insights team, the Associate Director manages a portfolio of reports through the development of data products/systems. The Associate Director will be responsible for the full reporting lifecycle from design, development, testing, documentation, and maintenance. They will establish strong relationships with partners and provide exemplary customer service by understanding stakeholder needs and developing targeted, sustainable data solutions, including support for programmatic targeting, audience segmentation, and analysis for campaigns, programs, and elections.

Requirements

• At least 5-7 years of experience in political data analysis/management, statistics, or related area required
• At least 2 cycles of experience with electoral, advocacy, or nonprofit data and targeting experience
• Technical proficiency using SQL to develop complex reports required, including experience with:
• Developing database objects (tables, views, and stored procedures)
• Microsoft SQL Server, Management Studio, and Microsoft SQL Server Reporting Services (SSRS)
• High technical proficiency with Tableau Desktop required, including at least 1 cycle of direct experience with:
• Designing, developing, testing, and creating complex reports, dashboards, and data visualizations
• Developing and publishing Tableau data sources using different data connectors
• Comprehensive knowledge of organizing and electoral data management systems, including VAN and Catalist
• Advanced Microsoft Excel proficiency required
• Proficiency with G-Suite and the Microsoft Office suite required
• Strong written, verbal, and interpersonal communication skills with keen attention to detail and required
• Experience communicating technical and analytics concepts to nontechnical audiences
• Knowledge of and sensitivity to different racial/ethnic and socioeconomic backgrounds, and people with different gender identities, cultural differences, and disabilities
• Bachelor’s degree required; a combination of professional experience and skills may be considered in lieu of formal/traditional education

Nice To Haves

• Experience with GIS (Esri ArcGIS) or other mapping software preferred
• Experience in disaggregating data and considering the impacts on multiple communities, including communities of color, in technical analysis preferred

Responsibilities

• Strategize with PPFA national office departments on data collection, management, and hygiene, analysis, and reporting to inform programs; provide subject matter expertise and technical assistance to create and improve data practices, analyses, and tools
• Consult regularly with end-users at the PPFA National Office and Planned Parenthood affiliates to develop targeted data solutions that inform operational and strategic decision-making
• Provide and communicate sophisticated data analysis through oral and written reports, creative visualization, and tracking documents, including communicating technical and mathematical concepts to non-technical stakeholders, including board members, senior leadership, and PCA leadership
• Provide training as needed to local Planned Parenthood program staff on best practices for use of data and field tools
• Collaborate with vendors and consultants to implement field programs in an organized fashion, including pulling counts and lists, developing experiments, and developing summary materials to explain outcomes and lessons learned
• Demonstrate a commitment to diversity, equity, and inclusion, and ensure all work products consider the impacts of the work on multiple communities, including communities of color, young people, and individuals with diverse gender identities and socioeconomic backgrounds
• Design, develop, and maintain reports and data visualizations using analytical tools such as Tableau Desktop. Build and maintain overall reporting infrastructure to support supporter engagement, electoral, advocacy, and organizing program reporting utilizing centralized data systems
• Manipulate and analyze voter, membership, volunteer, and other person-level data
• Oversee and integrate new organizing tools and current databases with our existing data ecosystem and ensure pipelines are delivering reliable, accurate data
• Maintain and document integration pipelines and oversee integration strategy
• Draft and deliver reports/presentations on organizing, elections, and advocacy programs to Planned Parenthood national office leadership
• Support ad-hoc reporting and analysis requests from colleagues across the Federation
• Oversee quality assurance (QA) processes to ensure data products are of high quality
• Assess program goals and impacts, and provide data, targeting, and technological guidance on issues and electoral campaigns
• Demonstrate a commitment to diversity, equity, and inclusion, and ensure all work products consider the impacts of the work on multiple communities, including communities of color, young people, and individuals with diverse gender identities and socioeconomic backgrounds
• Performs other duties as assigned.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level