Analytics Data Engineer

About the position

The Analytics Data Engineer is a member of the Data Operations team and is responsible for working with the DCCC Analytics department to ingest and structure data from various vendors and public sources into high-quality datasets to facilitate departmental reporting, targeting, modeling, and polling needs. They will work closely with the Analytics Product Manager to support Analytics products, reporting, and workflow automations. The ideal candidate will have experience with both political data and data engineering.

Responsibilities

• Centralize data from various DCCC vendors and public sources, building and maintaining ELT workflows to deliver data into our Google BigQuery data warehouse, including (but not limited to) voter file data, scores and models, polling data, geographic and census data, and media data.
• Collaborate with the Analytics department, the Analytics Product Manager, and other key stakeholders to design and maintain data products, reports, and automated workflows in alignment with the strategic needs of the Analytics department.
• Become a subject-matter expert on the national voter file, working closely with the DNC and other vendors to follow updates to source data and maintain voter file ingestion pipelines.
• Structure and document key datasets for analytics and reporting needs.
• Automate common workflows to facilitate the core work of DCCC analysts.
• Perform other duties as necessary to ensure the success of the Data Operations and Analytics teams.

Requirements

• 1-3 years of data engineering or analytics experience in politics or technology.
• Strong SQL and analytics database experience — preference for BigQuery.
• Experience with dbt or other workflow orchestration tools.
• Experience with Tableau or other business intelligence and data visualization tools.
• Experience using R or Python for data processing or visualization.
• Familiarity with database architecture and modern data workflows, particularly as they relate to campaign data.
• Familiarity with voter file tools (such as VAN, PDI, Catalist), Census data, and the DNC ecosystem (Phoenix and Portal).
• Proactively fosters an inclusive atmosphere and commitment to equal employment opportunities.
• Ability to demonstrate multicultural competence – the awareness, knowledge and skills needed to work with others who are culturally different from self in meaningful, relevant and productive ways.
• Personal and professional commitment to promoting and investing in cross-cultural skills and awareness related to individuals from broad backgrounds, races, ethnicities, religions, gender, sexual orientation, gender identity and disability.
• Proven interpersonal, communication, and collaboration skills with the ability to build relationships with staff at all levels.

Benefits

• Medical, dental, and vision plans with premiums fully paid for by DCCC.
• Accidental Death and Dismemberment (AD&D) and Life Insurance fully paid for by DCCC.
• More than 25 days of paid time off (which includes federal holidays, time off around the holidays, vacation, and sick days).
• Paid parental leave.
• Fertility and growing family support with $10,000 subsidiary paid by DCCC.
• Pet Insurance Discount.
• Up to 6% retirement employer match contribution.
• Long-term Disability fully paid for by DCCC.
• Monthly mobile phone stipend.
• Monthly metro benefits (for employees located in the DC metro area only).
• Gym Access (for employees located in the DC metro area only).
• Capital Bikeshare Discount (for employees located in the DC metro area only).
• Employee Assistance Program.
• Employee Resource Groups.