What are the responsibilities and job description for the EA-Data Pipeline position at Social Solutions Global?
NGP VAN is the winningest technology platform in the history of democratic and progressive causes, working tirelessly to innovate and advance the technology our clients rely on to bolster our democracy. We help power the trailblazers, campaigners, and advocates fighting up and down the ticket for equality, racial justice, reproductive freedom, democracy, climate reform, and more- including the national Democratic committees and progressive organizations, thousands of Democratic campaigns, hundreds of labor unions, advocacy organizations, progressive and non-partisan PACs, and other organizations.
The EA-Data Pipeline position fills a critical role at NGP VAN, processing large datasets for our clients and vendors and building out automated processes for large data automation. The ideal candidate is someone who has both the technical skills required for the job but also possesses critical experience within the political tech ecosystem, having an understanding of the unique needs of our clients.
Essential Position Duties and Responsibilities :
Process datasets from a variety of data vendors and clients, including voter files, client membership, and other requests.
Identify and implement automation improvements for data processing enhance efficiency and reliability.
Maintain project plans and documentation for data pipeline initiatives.
Coordinate with cross-functional teams to ensure seamless integration of automated solutions.
Required Skills / Abilities (Ideal candidates will possess all of these) :
Experience writing SQL statements in a common RDBMS language (MSSQL)
Prior experience working for a political campaign / organization, electoral-focused non-profit, or labor union.
Experience using a scripting language for basic file manipulation tasks
Knowledge of political districts, electoral calendars, voter files, and other core concepts of electioneering.
Additional Critical Skills / Abilities (Ideal candidates will possess several of these) :
Experience with PowerShell.
Excellent T-SQL skills, including experience with dynamic SQL
Experience with the NGP VAN / EveryAction application
Experience with automating systems
Understanding of query optimization in a MSSQL environment
Optional Skills / Abilities (Ideal candidates may possess these) :
AI-first mindset for innovation and for enhancing functionality.
Comfort and ability to use AI for automation and for building data pipelines.
The range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.
Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and in addition to benefits this role may be eligible for discretionary bonuses / incentives, and equity.
This position is a part of a bargaining union represented by CWA Local 1400, 2336, or 13000.
US Base Salary Range : $85,800 - $110,000
Please note that the compensation range and benefits specified in this job posting is applicable to candidates based in the United States. For international applicants, actual salary offers and benefit plans may vary based on the local market compensation standards and will be determined in accordance with regional considerations, including but not limited to applicable laws, cost of living, and industry norms.
We will be accepting applications for the role until 3 / 18 / 2025
Our Culture :
Our team is made up of industry experts and advocates who are 100% committed to supporting the doers of social good. We are currently undergoing an effort to create the vision and values that embody our collective organization and embrace the individuals who make up our community.
Our comprehensive and competitive benefits include :
Generous Flexible Time Off (FTO) Policy
Up to 15 paid company holidays including some commemorating social justice events and self-care
Paid volunteer time
Resources for savings and investments
Paid parental leave
Paid sick leave
Health, vision, dental, and life insurance with additional access to health and wellness programs.
Opportunities to learn, develop, network, and connect
Please note the benefits specified on this page are applicable to full-time employees based in the United States. For international employees, actual benefits may vary based on local standards and regulations and will be determined in accordance with regional considerations, including but not limited to applicable laws and industry norms.
We are committed to being an equal opportunity employer and evaluate qualified applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, diversity of thought and any other characteristic protected by applicable law.
Salary : $85,800 - $110,000
