Data Architect

Summary

Join MoveOn's tech team as a Data Engineer and play a pivotal role in shaping our data infrastructure and voter engagement strategies. You will manage target lists for elections, build data pipelines, and support data warehousing. This position requires strong SQL skills and experience with large relational databases. The role involves close collaboration with various teams, including fundraisers and organizers. The position offers a competitive salary, excellent benefits, and the flexibility to work remotely from anywhere in the contiguous U.S. MoveOn is committed to equity in compensation and offers a comprehensive benefits package.

Requirements

• Have a strong attention to detail and be a curious, fearless learner and problem solver who can independently manage several tasks/projects concurrently and prioritize work effectively
• Be comfortable with digital technology, including learning to administer the voter contact tools used by MoveOn, as well as using internal communication tools like Slack
• Have experience working directly with non-technical stakeholders and carefully listening to and translating request details from non-technical staff
• Work closely with the tech and analytics teams to communicate organizing team needs and plan and build data pipelines and queries
• Be comfortable proactively reaching out to and thought-partnering with stakeholders across the broader organization, with the ability to be effective in an organization whose staff all work remotely in various time zones
• Adopt a digital security mindset to protect member data privacy and craft data management systems that are resilient to data breaches
• High level of proficiency with SQL querying including query optimization
• At least 3 years of experience working with large relational data systems
• Experience with dbt or other similar tools for data ETL
• Strong knowledge of data warehousing and data schema best practices for design and implementation
• In-depth experience with integrating data from different sources and establishing data collection and management frameworks
• Experience using git for version control

Responsibilities

• List management and query support (50%)
• Target list management for election persuasion and voter mobilization programs. Ensure contact data is normalized and matched across organizing tools, creating a centralized, high-confidence view of outreach and outcome statuses
• Writing ad-hoc, as-requested queries to create target lists for outreach tactics or to provide staff with data and reports to support their work. Identify and document requests and processes that can be turned into time-saving automations, coordinating with engineering staff to implement as needed
• Design, implement, and manage MoveOn’s data infrastructure (30%)
• Standardize survey questions, responses and tags across different scripts and tools
• Build data load and data capture integrations to efficiently move data between Redshift and our outreach tools
• Continue the design, development, and management of our custom global data schema used to standardize and consolidate data across multiple data sources
• Support data ingestion, transformation, and syncing between tools (20%) No prior experience required
• Support building and managing data warehouse ingestion and transformation pipelines from vendor APIs or SQL mirrors using Python scripts and/or Fivetran
• Support building and managing integration automations that synchronize transformed warehouse data to outreach tools

Preferred Qualifications

• Campaigning and organizing software (e.g. ThruTalk/Scale to Win, Spoke, ActionKit, ActionNetwork, Mobilize America, Upland Mobile Commons)
• Voter file data from TargetSmart or Catalyst
• Building and maintaining data pipelines

Benefits

• Strong medical, dental, and vision benefits, which are free to employees and children of employees (spouses or domestic partners can be added at a subsidized rate)
• Employer-paid premiums for life insurance
• Four weeks accrued paid vacation time per year, prorated for the period that you work
• 18 weeks of paid parental leave (birth, adoption, foster care placement of a child)
• 10 days accrued paid sick time prorated for the period that you work
• Paid family medical leave
• 8 staff holidays and 6 floating holidays
• Contribute 5% to your 401(k) after six months of employment
• $1000 in professional development budget each year for each staff member
• Monthly home office subsidy
• Internet and phone subsidy of $2,100 annually
• Health and wellness subsidy of $900 annually