Sql data analyst Jobs in Washington, DC

Organization Overview

America Votes works with over 400 state and national partner organizations to advance progressive policies, win elections, and protect every American's right to vote.

Since 2003, America Votes has been the common link between many of the largest and most influential issue and membership organizations in the country, serving as the coordination hub of the progressive community. America Votes' work has brought together a wide range of causes and built a unified coalition that has transformed how the progressive community works. Together, they have engaged communities across the country to take action on critical issues – from fighting for working families, defending reproductive rights, protecting the environment, and more – and mobilized millions of voters.

America Votes works year-round nationally and in more than 20 states, acting as a permanent campaign to continually advance progressive causes, modernize elections, and win elections. America Votes provides a range of services to partners, including strategic planning, advocacy and electoral campaign coordination, data tools and targeting services, and on-the-ground leadership in key states.

America Votes also works to improve election systems and fight back against efforts to suppress voters, taking the lead throughout their state network to coordinate and execute advocacy campaigns with allies to reform elections and modernize the voting process.

Racial Equity Statement

As a leader of collaborative efforts to mobilize voters, protect voting rights, and win elections, America Votes is committed to advancing racial equity within our organization and across our coalition. We acknowledge the systematic racism that permeates all facets of our society, beginning with the foundational right to vote. America Votes is also engaging with an understanding of the ways gender, sexuality and other forms of oppression intersect with race and how those relationships impact inequities faced by our staff, our partners, and the communities that we engage in our work. America Votes strives to model our commitment to racial equity through our internal and external operations, programs, and partnerships. We acknowledge the inequitable structures that continue to exist and are moving forward with a sustained commitment in time, resources and people to challenge structural racism and work towards creating a reflective organization and democracy.

Position Description

America Votes is looking for a Data Analyst to find and communicate insights to improve our voter contact programs, win elections, and drive progressive change. The ideal candidate is excited about talking to staff across teams to understand their needs and questions, then creating dashboards, graphs, memos and slide decks to share answers. In particular, we're looking for someone with past political experience who loves the work we do supporting states, understands both the data and the program context, and can turn data into not just reports, but recommendations.

This is a permanent, full-time bargaining unit position that reports to the Analytics Director.

Responsibilities

• Dashboards and Reporting: Create reports used by AV staff and partners to make programmatic and strategy decisions; use reports and other tools to proactively highlight trends and insights that inform AV and partner programs.
• Analysis and Writing: Collaborate with internal program staff to translate their needs into analytics questions, investigate those questions using SQL queries and other tools, then communicate your findings in clear, accessible, and actionable ways.
• Continuous Learning: Stay up to date with research and best practices from across the political data space, continually grow your own analytics knowledge, and help national and state staff incorporate new methods into our analysis work.
• Other duties as assigned.

Qualifications

Must Haves

• Political experience – At least one cycle of data experience at a political campaign or at a progressive organization, including working with voter files and voter contact data.
• Strong SQL skills - you should have worked in a cloud data warehouse environment before, be comfortable writing queries with complex joins and aggregate functions, and care about writing clean and well-documented code.
• Experience gleaning actionable insights from data - you should be able to dig into data quickly, turn your investigations into recommendations, and communicate the results in presentations, graphs, and written memos.
• Experience creating dashboards - we use Google Data Studio and Hex, but we are platform agnostic for this role; we care that you understand how to communicate clearly in a dashboard, not necessarily that you have used a particular platform before.
• 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.

Nice to Haves

• Experience with Voter Registration, especially site-based programs using BLOCKs.
• More advanced technical skills, including advanced SQL skills, coding in R or Python, or experience using dbt (data build tool) for data transformations.
• More advanced knowledge of analytics and statistical methods such as regressions, predictive modeling, or time series analysis.
• Experience with additional political data sets such as Census data, FEC reports, DDx, and digital or TV advertising data.
• Past experience as a political organizer or field staffer.

Hiring Process

1. Hiring Manager Resume Review
2. Initial Hiring Manager Interview (30 min)
3. Technical Assessment (done on own time, 4 hours)
4. Final Interview with Hiring Manager and Data Team Members (45 minutes)
5. Reference Check

How you'll ramp

• 30 days: Get an overview of our data stack and our existing reports; meet the data and program staff you'll be working with and learn more about the partners we support.
• 45 days: Take ownership of a report or analysis from end-to-end – understanding the request, creating an analysis plan, and then building a dashboard or writing a memo.
• 60 days: Step into your role as the go-to person for questions on specific reports and programs; proactively dig into program data and flag changes or warning signs.

Location

This is a remote position, with a sight preference for someone based in DC. Some travel and reasonable access to an airport is required. America Votes has offices located in DC and CO, FL, GA, MI, MN, NC, NH, NM, NV, OH, PA, and WI.

Compensation

The salary for this position will be $75,000 - $85,000 and depend upon the applicant's experience. America Votes offers a competitive benefits package covering 100% of employee medical, dental, & vision insurance premiums, life insurance, long term disability coverage, monthly cell phone reimbursement, personal professional development funds, parental leave, and 401 (K) after six months of continuous service with the organization. America Votes provides a generous paid time off policy with paid vacation, unlimited sick and safe leave, paid personal days, at least 10 Federal paid holidays including Juneteenth, as well as paid organizational time off from at least December 23 to January 1.

America Votes is an equal opportunity employer committed to a diverse, inclusive and equitable workplace. America Votes does not discriminate on the basis of race, color, creed, religion, national or ethnic origin, sex, sexual orientation, gender identity or expression, age, disability, veteran status or any other protected category under local, state or federal law. People of color, LGBTQ candidates, individuals with disabilities, and neurodivergent individuals are strongly encouraged to apply.