Manager, Data Architecture

Planned Parenthood; New York (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

Planned Parenthood Federation of America seeks a conscientious Manager, Data Architect to design and govern enterprise data architecture supporting fundraising goals. This role will model data, support the data lakehouse, and advise on integration and engineering practices across the organization.

You will collaborate with stakeholders, maintain platforms, and train teams while aligning with PPFA’s mission and DEI commitments. Travel is minimal, and the impact spans nationwide.

Qualifications

• Bachelor’s degree in a related field with 3–5 years in data architecture/engineering.
• Strong analytical and problem-solving abilities with professional discretion.
• Experience with data warehouse concepts and methodologies.
• Proficiency in SQL and data modeling.
• Familiarity with CRM platforms (Salesforce) and cloud data platforms.

Responsibilities

• Create a scalable data framework to support fundraising goals.
• Review data integration/engineering to deepen a data-driven culture.
• Oversee data lakehouse delivery and identify improvements for outcomes.
• Define methodology with focus on issue analysis.
• Maintain data platforms, wiki, shared drive, and PM tools.
• Develop logical/physical data models for the enterprise data lakehouse.
• Lead cross-team projects to ensure timely delivery.

Skills

Data architecture

Data engineering

SQL

Analytical skills

Communication

Teamwork

Education

Bachelor’s degree in related field

Tools

dbt

Amazon Redshift

Salesforce

Job 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 Architect. 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 Architect designs and implements the enterprise data architecture for the Development organizational unit. They identify key data requirements for design and execution in the data lakehouse which lead to successful fundraising. They construct data models that highlight anticipated outcomes and demonstrate campaign performance and prescriptive insights. They organize provision of services in support of key organizational data strategy.

Delivery:

• Create a scalable data framework to support organizational needs to advance fundraising achievements.
• Review and advise on the organization of data integration and engineering to further refinements to expand and deepen understanding of a data-driven culture.
• Review and advise on processes for delivery of the data lakehouse for identifying possible improvements to enhance outcomes.
• Define methodology/approach with particular attention to the analysis of issues.
• Maintain technology platforms such as the data lakehouse, team wiki, shared drive, and project management tools.
• Develop logical and physical data models to support the enterprise data lakehouse and manage projects within and across teams to ensure timely delivery.
• Perform other duties as assigned.

Engagement:

• Advise on optimal organization/delivery of service data architecture, identifying issues which affect capacity to meet stakeholder needs.
• Advise on optimal approach to data architecture and engineering best practices.
• Independently engage stakeholders across all levels of PPFA National office to engage around key initiatives and provide training on design and delivery of services.
• Collaborate with stakeholders and partners to provide technical support and training on design and delivery of data services.
• Communicate project/service process and status for the data lakehouse to ensure data continuity and clarity in expectations.
• Train new team members on departmental processes and projects.

Knowledge, Skills and Abilities (KSAs):

• Bachelor’s degree with 3-5 years of related work experience in data architecture and engineering for an enterprise data warehouse required, preferably in a nonprofit organization.
• Ability to recognize and respond to problems with potential solutions in a highly professional, confidential, and sensitive manner.
• Strong organizational, analytical, and problem-solving skills
• Proven ability to work collaboratively in a team environment as well as independently when required.
• Understanding of data warehouse methodologies, data 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
• Excellent analytical skills with sharp attention to detail and the ability to meet critical deadlines.
• Strong oral and written communication skills
• 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

Travel: 0-5% domestic travel

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.