Bachelor's degree with 3-5 years of experience in data architecture and engineering, preferably in a nonprofit organization.
Proficiency in SQL; experience with dbt, Amazon Redshift, and Salesforce is preferred.
Strong organizational, analytical, and problem-solving skills.
Ability to work collaboratively in a team and independently when necessary.
Understanding of data warehouse methodologies and engineering principles.
Commitment to diversity, equity, and inclusion, particularly regarding race equity.
Excellent oral and written communication skills.
Responsibilities
Create a scalable data framework to enhance fundraising efforts.
Review and advise on data integration and engineering processes.
Define methodologies for analyzing issues related to data architecture.
Maintain technology platforms including the data lakehouse and project management tools.
Develop logical and physical data models for the enterprise data lakehouse.
Engage stakeholders to provide training on data services design and delivery.
Communicate project status to ensure clarity and continuity in data management.
Benefits
Commitment to a workplace culture that fosters belonging and promotes learning.
Opportunities for professional development and training.
Engagement in meaningful work that supports sexual and reproductive health.
Collaborative work environment with a focus on diversity and inclusion.
Full Job Description
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.
About Planned Parenthood
Planned Parenthood is a non-profit organization that provides reproductive health care in the United States and globally. It is the largest provider of reproductive health services in the United States, with over 600 health centers nationwide. Planned Parenthood offers a range of services, including birth control, cancer screenings, STI testing and treatment, and abortion services. The organization was founded in 1916 and is headquartered in New York City.
