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:<ul><li>Process datasets from a variety of data vendors and clients, including voter files, client membership, and other requests.</li><li>Identify and implement automation improvements for data processing enhance efficiency and reliability.</li><li>Maintain project plans and documentation for data pipeline initiatives.</li><li>Coordinate with cross-functional teams to ensure seamless integration of automated solutions.</li></ul>Required Skills/Abilities (Ideal candidates will possess all of these): <ul><li>Experience writing SQL statements in a common RDBMS language (MSSQL)</li><li>Prior experience working for a political campaign/organization, electoral-focused non-profit, or labor union.</li><li>Experience using a scripting language for basic file manipulation tasks</li><li>Knowledge of political districts, electoral calendars, voter files, and other core concepts of electioneering.</li></ul>Additional Critical Skills/Abilities (Ideal candidates will possess several of these):<ul><li>Experience with PowerShell.</li><li>Excellent T-SQL skills, including experience with dynamic SQL</li><li>Experience with the NGP VAN/EveryAction application</li><li>Experience with automating systems</li><li>Understanding of query optimization in a MSSQL environment</li></ul>Optional Skills/Abilities (Ideal candidates may possess these):<ul><li>AI-first mindset for innovation and for enhancing functionality.</li><li>Comfort and ability to use AI for automation and for building data pipelines.</li></ul>This position is part of a bargaining unit represented by CWA Local 1400, 2336 or 13000​.US Base Salary Range: $85,800 - $110,000At this time, we are unable to consider candidates who require current or future sponsorship for employment authorization. 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:<ul><li>Generous Flexible Time Off (FTO) Policy</li><li>Up to 15 paid company holidays including some commemorating social justice events and self-care</li><li>Paid volunteer time</li><li>Resources for savings and investments</li><li>Paid parental leave</li><li>Paid sick leave</li><li>Health, vision, dental, and life insurance with additional access to health and wellness programs.</li><li>Opportunities to learn, develop, network, and connect</li></ul>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.Candidate AccommodationsIf you require assistance due to a disability in the application or recruitment process, please submit a request <a href="http://forms.office.com/Pages/ResponsePage.aspx?id=0FZT8l0YxkOCliCkFvHNj0w0euElBs9Erq16k2CMofxURTZWVzZNUFVPRjhWUzZBQkNKNzczQ1YzNy4u" target="_blank">here</a>.

Bonterra

EA-Data Pipeline Remote, United States

Bonterra