America Votes is a leading organization that collaborates with numerous state and national partners to promote progressive policies and protect voting rights. They are seeking a full-time Data Engineer to build and maintain data pipelines and infrastructure that support data work across the progressive movement, utilizing skills in SQL and Python to transform data for various stakeholders.
Responsibilities:
- Write and maintain SQL and dbt models that transform data in our warehouse, adding new models, refactoring existing code, writing tests, and improving documentation
- Make additions to GCP pipelines that load data into our BigQuery warehouse and send data out of BigQuery to other platforms
- Collaborate with national and state data staff to build tables, pipelines, and tools that help our team do their jobs more effectively
- Contribute to data strategy conversations, including the adoption of new tools, shared data standards, and engineering best practices
- Other duties as assigned
Requirements:
- Strong SQL skills: comfortable writing queries and scripts to clean, transform, and analyze data. Committed to writing clean, readable, well-documented code
- Experience working in a cloud data warehouse (BigQuery, Redshift, Snowflake) or other cloud infrastructure
- Working experience with Python or a similar object-oriented language, especially for data transformation, scripting, or working with APIs
- Experience using Git and other command line tools
- Previous experience working on a political campaign or similar environment, especially in a data role, or other settings that required ramping up and delivering under time pressure
- A self-starter mindset: able to onboard quickly, ask the right questions, and jump into ambiguous problems without waiting for a perfect spec
- A service-oriented approach to data work that prioritizes collaboration, supporting staff and partners, and building products that center and advance racial equity
- Strong interpersonal skills and a professional approach to communicating with team members, partners, and vendors
- Experience using dbt to transform data, including using dbt Cloud
- Experience working with APIs to move data between systems
- Experience with the suite of GCP tooling – we mainly use Cloud Build Jobs, Workflows, and Virtual Machines
- Understanding of unit testing, CI/CD, containerization, and other software engineering best practices
- Familiarity with voter file or voter contact data from tools like NGP/VAN