View Our Website View All Jobs

Data Services Specialist

As a Data Services Specialist, you will provide data support and data load during client onboarding and post-onboarding to build and maintain custom data jobs. You’ll collaborate internally with technical and non-technical teams at NGP VAN/ EveryAction to create sustainable and elegant data solutions. 

Ideal candidates possess strong communications skills, attention to detail, and high comfort level of working with clients. Candidates are expected to have strong SQL skills, have a working knowledge of relational databases, and experience working with political campaigns or non-profit programs. 

Responsibilities:

  • Work with clients to understand data needs and fulfill import, export, and migration requests
  • Migrate clients of all sizes and data savviness levels to NGP VAN and EveryAction databases
  • Implement ETL processes to acquire and load large datasets and improve efficiency of existing ETL processes
  • Assist in developing SQL scripts and protocols for large scale client migrations
  • Manage and prioritize your own workflows
  • Work with team members to document and train others on technical tasks
  • Work across departments, including Sales, Engineering, and Product, to accurately set and manage project timelines and outcomes

Essential Skills:    

  • Experience with SELECT, UPDATE, and INSERT statements in any of the various flavors of SQL – including but not limited to T-SQL MySQL, Postgres, etc. 
  • Background in non-profit database migrations and understanding of non-profit workflows OR working with political data sets, including 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
  • Strong organizational skills along with an 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 other relational databases software is a plus
  • Prior exposure to working with large datasets
  • Familiarity with source control (git preferred) 
  • Experience consuming REST or SOAP web services
  • 2 cycles or 3+ years of experience with political or non-profit data
  • Proficiency in writing SSIS script tasks or other ETL applications
  • Experience in common scripting and/or programming languages (PERL, PowerShell, C#, Python, Java, Ruby, etc.)
  • 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 nine years in a row.

Last year 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 200 smart, passionate, and innovative co-workers, many of whom are industry recognized as experts in their fields.

NGP VAN believes a diverse, inclusive staff makes us a stronger company and better partner for our clients.  We’re committed to hiring people of all races, ethnicities, ages, sex, genders, sexual orientation or gender identities, marital status, religions, and disabilities.  Women, people of color, LGBTQ individuals, and members of other minority or marginalized groups are encouraged to apply.

 

Read More

Apply for this position

Required*
Apply with Indeed
Attach resume as .pdf, .doc, or .docx (limit 2MB) or Paste resume

Paste your resume here or Attach resume file

150