A Data Services Specialist serves as the primary engineer on all data-related aspects of the client onboarding and post-onboarding process. A Data Services Specialist is also charged with building and maintaining custom jobs, as well as collaborating internally with technical and non-technical teams at EveryAction / NGP VAN, to create sustainable and elegant data solutions.

Ideal candidates possess strong communications skills, attention to detail, and a high comfort level working with clients.

Candidates are expected to have strong SQL skills, have a working knowledge of CRM solutions and relational databases, and experience working with non-profit or political campaign related data. Please specifically highlight any experience working with non-profit development data, if applicable, in your cover letter.

Responsibilities

  • Develop SQL scripts and protocols for large scale client migrations 
  • Implement ETL processes to acquire and load large datasets and improve efficiency of existing ETL processes 
  • Scope and execute client requested one-off edits and exports
  • Work with the Account Management team to understand non-profit and/or political client data needs to fulfill import, export, and migration requests 
  • Work across departments, including Sales, Engineering, and Product, to accurately set and manage project timelines and outcomes 
  • Manage and prioritize your own workflows 
  • Work with team members to document and train others on technical tasks 

Essential Skills 

  • An intermediate or greater understanding of SQL fundamentals to run complex SQL queries, inserts, deletes, and updates
  • A strong understanding of relational database structure
  • Background in non-profit database migrations and understanding of non-profit workflows OR working with political data sets, including but not limited to fundraising and compliance workflows 
  • Familiarity with writing, refining, and troubleshooting stored procedures or SQL scripts 
  • Excellent written and verbal communication skills with the ability to present complex technical information in a clear and concise manner to both a technical and non-technical audience
  • Strong organizational skills along with a high attention to detail 
  • Ability to work with internal and external stakeholders to complete projects on expected timelines 

Desired Qualifications 

  • Experience with MS SQL Server
  • Exposure to relational database software
  • Prior exposure to working with large datasets 
  • Familiarity with source control (git preferred) 
  • Experience working with clients or partners on large data migrations, with exposure to sensitive data sets
  • 2 cycles or 3+ years of experience with non-profit or political data 
  • Proficiency in working with ETL applications and scripts 
  • Familiarity with source control (git preferred) 
  • Must be able to occasionally work weekends and off hours 

About Us

NGP VAN is a technology company whose team members do exciting and meaningful work that has a significant impact on promoting civil rights, social justice, and environmental responsibility.

Employees enjoy an unusually generous set of benefits, including 12 weeks paid parental leave, profit sharing, 100% premium-paid health/dental, and an ongoing education allowance.  NGP VAN is one of only a handful of companies to be recognized as one of the fastest growing companies in America by Inc. Magazine for 10 years. Inc. Magazine also recognized us as one of the 50 Best Places to Work in 2016.

We were named one of the Coolest Companies of 2016 by DC Inno. We’ve also been named one of the top 50 fastest growing companies in the DC area by the Washington Business Journal and SmartCEO. The Wall Street Journal wrote “NGP VAN is something of a secret weapon for the Democratic Party and the labor unions and progressive groups that use it.” We have also won the AAPC award for Best Use of New Technology, and the Campaigns & Elections Award for Most Innovative Product.

Join our team and work alongside about 300 smart, passionate, and innovative co-workers, many of whom are industry recognized as experts in their fields.

Salary: Not listed

Location: Washington, DC

See more and apply here