Analytics Engineer

The Working Families Party is seeking an Analytics Engineer to build the analytics infrastructure needed to fuel the Working Families Party’s mission to build the political home for the many, not the few. The Analytics Engineer will make the Working Families Party’s data accessible, reliable, and useful to staff and partners so we can better use it to win elections and build up our membership base.

We are seeking a passionate, data-driven individual who is eager to dive deep into messy data and uncover insight that will empower WFP’s electoral and member organizing. The Analytics Engineer should be someone that is adept at communicating with non-technical staff to understand their analytics needs, wrangling messy data in SQL, and collaborating with key stakeholders to use the tables you create in downstream queries and reports. The Analytics Engineer will be responsible for maintaining a broad array of reporting and dashboarding base tables, ensuring that there is consistency and accuracy across data reporting so we can monitor performance, surface strategic insights, and answer important management questions.

This is a deeply collaborative role that will report to the Data Director and work with the Data Engineer and Data Analyst.

Essential Duties and Responsibilities

Lead work to improve the dbt project we use to transform data in our warehouse. This includes designing the DAG for the project, staging new sources, building new intermediate models, refactoring existing code, adding tests to make code more reliable, and writing lots of clear, useful documentation.
Collaborate with national and state organizing staff to understand their analytics needs.
Build systems and testing infrastructure to identify and fix problems before consumers of the data notice, and communicate widely when bugs are identified.
Collaborate with members of the Data Team and Organizing staff to design and build business intelligence applications (such as dashboards or reports) to deliver insight into our electoral and member based organizing, as needed. This includes electoral dashboards for key races, coordinated campaigns, fundraising, our ladder of engagement, and volunteers.
Work closely with WFP organizers to identify data needs and be responsive to incoming data requests through the Data Team’s ticketing system.
Serve as a utility player who can pitch in on analytics projects when needed.
Other technical duties as directed by the Data Director.

Skills and Qualifications

At least three years of professional experience; 1+ years of experience with dbt.
Intermediate to Advanced SQL, including an intuition for modeling data and an understanding of query performance.
Experience using git and other command line tools.
At least one full political cycle working in a data analysis role for a campaign or advocacy group.

Our tech stack includes:

CRMs including EveryAction, Action Network, AV VAN, and PDI.
Our own voter contact database, Votivate.
Digital tools like Scale to Win, Reach, and Mobilize.
Redshift data warehousing.
Business intelligence tools like Looker Studio and Hex.
Prefect for orchestration.

Nice to haves:

Prior experience with systems like NGP/VAN, calling & texting tools, and data tools commonly used in the progressive movement is helpful.
An understanding of voter file and voter contact data.
Experience using Python or another scripting language for data transformation and analysis.
Familiarity with Prefect or another non-Civis orchestration tool.
Understanding of unit testing, CI/CD, and other software engineering best practices.

The salary range for this position is $70,000 to $105,000

‌