Director, Data Reporting

Telecommuter /
Office of the Executive Vice President, Health Care (HCD) – Data Strategy, Analytics & Gov. /
Full Time - Non-Union
Planned Parenthood Federation of America (PPFA) is the national umbrella organization for the nation’s leading network of women’s health care providers, educators, and advocates, serving women, men, teens and families. Planned Parenthood Action Fund (PPAF) is the advocacy and political arm of PPFA. For over 100 years, Planned Parenthood has done more than any other organization in the United States to improve women’s health and safety, prevent unintended pregnancies, and advance the right and ability of individuals and families to make informed and responsible health care decisions.  

Planned Parenthood Federation of America (PPFA) and Planned Parenthood Action Fund seek a dynamic and collaborative Director, Data Reporting. This job reports to the Sr. Director, Data Strategy & Governance in the Data Strategy, Analytics, and Governance (DSAG) department at PPFA. The DSAG team enables data-driven decision making through high quality data, analysis, and tools.  

Purpose

    • The Director contributes to Planned Parenthood’s mission by producing actionable data insights and tools for Planned Parenthood’s national office and affiliate stakeholders. As a member of PPFA’s DSAG team, the Director supports a portfolio of recurring reports and surveys that collect data from stakeholders across the Federation. The Director will be responsible for the full reporting lifecycle from design, development, testing, documentation, and maintenance of complex reports and data visualizations. They will establish strong relationships with partners and provide exemplary customer service by understanding stakeholder needs and developing targeted, sustainable data solutions. As a systems thinker, the Director will be able to understand, create, and improve interdependent processes that relate to data.

Delivery

    • The Director, Data Reporting will be responsible for the following:
    • Management, oversight, and accountability for the PPFA reporting program, including data collection, QA/review, report development, publication, vendor management, communication, and stakeholder engagement
    • Management of a team of analysts supporting PPFA’s reporting program
    • Revamp the program to assess, modernize, and improve the way data is collected, organized, and used in regular reporting in alignment with the DSAG departmental work plan
    • Collaborate with the Director, Database Administration to develop, test, and implement mature data collection processes (ETL, data warehousing) to streamline data acquisition to improve efficiency and quality
    • As an active, hands-on contributor to the data reporting team, the Director will also be responsible for the following:
    • Design, develop, test, document, and maintain complex reports and data visualizations using analytical/BI tools such as Tableau Desktop/Server/Prep
    • Consult with PPFA national office departments and Planned Parenthood affiliates on data collection, analysis, and reporting to inform programs and business needs; provide subject matter expertise and technical assistance to create and improve data practices, analyses, and tools
    • Draft and deliver reports/presentations to Planned Parenthood national office departments and affiliate organizations
    • Support ad-hoc data requests from colleagues across the Federation
    • Participate in quality assurance (QA) processes to ensure data products are high quality
    • Document data products and systems: author wiki articles and internal process documents; develop user-facing guides (written and video)
    • Effectively manage program/project files (organize, archive) in alignment with DSAG’s knowledge management practices
    • Demonstrate intercultural competence and ensure all work products consider the impacts of the work on multiple communities, including communities of color and individuals with different gender identities and socioeconomic backgrounds
    • Pursue relevant proficiencies/certifications where determined by business needs
    • Perform other duties as assigned

Engagement

    • The Director supports a broad portfolio of programs/projects, and the role requires strong interpersonal skills and enthusiasm for helping others collect, leverage, and interpret data. The Director will 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. This role will also provide ongoing technical support and education on data tools and best practices.

    • This role requires a keen ability and desire to communicate, including attending and presenting at cross-divisional meetings/webinars.  Due to the consultative nature of the role, the Director must have exemplary customer service skills, a positive “can do” attitude, and a demonstrated track record directly helping people design and implement data products and systems. The Director will have familiarity and experience working with the population Planned Parenthood serves, including people of different racial, ethnic and socioeconomic backgrounds, people with different gender identities and individuals with disabilities.

Knowledge, Skills and Abilities (KSAs)

    • At least 7 years of experience in healthcare analysis/business intelligence, public health, statistics, or related area required
    • At least 7 years of experience with healthcare data, including writing complex SQL reports using electronic health records (EHR) reporting databases (NextGen, Epic Clarity/Caboodle, Athena, eCW), required
    • Technical proficiency using SQL and T-SQL to develop complex reports required, including experience with:
    • Developing database objects (tables, views, and stored procedures)
    • Microsoft SQL Server and Management Studio and Microsoft SQL Server Reporting Services (SSRS)
    • High technical proficiency with Tableau Desktop required, including at least 3-5 years of direct experience with:
    • Designing, developing, testing, and complex reports, dashboards, and data visualizations
    • Developing and publishing Tableau data sources using different data connectors
    • Troubleshooting, optimizing, and maintaining complex reports and dashboards, including those developed by others
    • At least one Tableau Desktop certification or willingness to become certified within three months of date of hire required
    • Advanced Microsoft Excel proficiency required
    • Experience developing written technical documentation required
    • Experience with GIS (Esri ArcGIS) or other mapping software preferred
    • Experience with Tableau Server (administration and governance) and Tableau Prep (data cleansing, transformation) highly preferred
    • Experience with Python or R for statistical analysis and applications preferred
    • Proficiency with G-Suite and Microsoft Office suite required; experience with Asana or similar project management tool strongly preferred
    • Experience in disaggregating data and considering the impacts on multiple communities, including communities of color, in technical analysis preferred
    • Strong written, verbal, and interpersonal communications skills with keen attention to detail and grammar (English fluency) required; ability to flex communication style to multiple cultural environments required
    • 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, Master’s degree preferred; combination of professional experience and skills may be considered in lieu of formal/traditional education

TRAVEL

    • 0-25% (domestic)
Starting Salary: 110k

*LI-KM1

Final offers for this job will be based on capabilities and will be made within the parameters of the PPFA compensation program. 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-KM1
*PDN-HR