Rockefeller Philanthropy Advisors is hiring a Data Architect to design and maintain robust data infrastructure supporting voter engagement, campaign strategy, and organizational outreach for our mission-driven work. In this remote role, you will collaborate cross-functionally to build efficient pipelines, optimize data architecture, and empower non-technical teams with reliable insights.
What You'll Do
- Lead list management and support voter engagement campaigns by creating clean, normalized contact data and custom queries.
- Design and manage data infrastructure, including global schema standardization, survey data integration, and ETL pipelines.
- Collaborate with software engineers to maintain data ingestion and synchronization between Redshift and third-party platforms.
- Write ad-hoc SQL queries for internal stakeholders and identify automation opportunities for recurring tasks.
- Ensure data quality and integrity across various tools and outreach platforms.
- Contribute to the maintenance and optimization of integrations between internal systems and external APIs.
What We're Looking For
- 3+ years of experience with large relational data systems and strong SQL skills, including performance optimization.
- Proficient in data architecture best practices, schema design, and ETL workflows (especially with dbt or similar tools).
- Experience with Git for version control and integrating data from diverse sources.
- Strong communication skills with an ability to collaborate effectively with non-technical stakeholders.
- Organized, detail-oriented, and comfortable managing multiple projects in a fully remote environment.
- A proactive mindset with an emphasis on privacy, security, and data resilience.
Nice to Have
- Experience with campaigning tools (e.g., ActionKit, Mobilize, Spoke), voter file data (e.g., TargetSmart), or building custom data pipelines.
Technical Stack
- SQL, Redshift, dbt, Git, ETL
Benefits & Compensation
- Compensation: $131,819.10 (non-negotiable, equity-based compensation model).
- Remote work from anywhere in the contiguous U.S., with occasional travel.
- Monthly home office subsidy.
- Annual stipends for internet/phone ($2,100) and wellness ($900).
- Comprehensive medical, dental, and vision insurance (free for employees and their children; subsidized for partners).
- 401(k) with 5% employer contribution after 6 months.
- Generous time off: 4 weeks vacation, 10 sick days, 18 weeks parental leave, and 14 total holidays.
- $1,000 annual professional development budget.
Work Mode
This is a fully remote position open to candidates residing anywhere in the contiguous United States.
Rockefeller Philanthropy Advisors is an equal opportunity employer committed to leveraging digital innovation and progressive values to drive social impact at scale.
