Are you a passionate innovator looking to harness the power of technology to do more good? You've come to the right place. NGP VAN, together with ActionKit and Mobilize, delivers leading technology to Democratic and progressive campaigns as well as nonprofits.
Our parent company, Bonterra, was formed by bringing together leading solutions from CyberGrants, EveryAction, Network for Good, Social Solutions and their respective entities to form the second-largest and fastest-growing social good software company in the world. This collaboration will help NGP VAN accelerate enhancements in our platforms and continue to drive our top three areas of focus: reinforcing the core, committing to innovation, and helping lead in the Democratic ecosystem.
Data Pipeline Developers fill a critical role at NGP VAN, ensuring that data from our clients and their vendors is quickly and accurately available in our organization. They use their data-centric skills to work with other members of our technical and client-facing teams to ensure our clients can operate their programs at peak efficiency. The ideal candidate is someone who has both the technical skills required for the job, but also possesses experience within the political tech ecosystem who understands the unique needs of our clients.
Responsibilities

• Process voterfile updates from a variety of data vendors
• Process ad-hoc data loads from clients and vendors
• Collaborate with client support to quickly respond to incoming support requests.
• Provide recommendations for improvements to existing processes to departmental leadership

Crucial Skills/Experience - A good candidate will have all of these:

• Experience writing SQL statements in a common RDBMS language(MSSQL, pgsql, MySQL, Oracle)
• 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 Skills/Experience - A great candidate will have several of these

• Experience with Powershell
• Excellent T-SQL skills, including experience with dynamic SQL
• Experience with the NGPVAN/EveryAction application
• Understanding of basic query optimization in a MSSQL environment

This position is part of a bargaining unit represented by CWA Local 1400, 2336 or 13000.
Applicants must be authorized to work for any employer in the U.S. We are unable to sponsor or take over sponsorship of an employment Visa at this time.
Compensation
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.
US base salary range: $85,000 - $115,000
Please note that the compensation range specified in this job posting is applicable to candidates based in the United States. For international applicants, actual salary offers 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.
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
• Equity for ALL regular, full-time employees from individual contributors to management - share in our success!
• 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

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.