What are the responsibilities and job description for the Data Services Specialist position at NGP VAN?
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.
How To Apply
Submit your application by visiting our Careers Page. We are hiring for this position in both the DC and Somerville offices.
NGP VAN believes a diverse, inclusive staff makes us a stronger company and better partner for our clients. Women, people of color, LGBTQ individuals, and members of other minority or marginalized groups are encouraged to apply. We’re committed to hiring people on the basis of qualifications, merit and business need, and NGP VAN is proud to be an equal opportunity employer.
Since this position will have access to certain client data, an offer of employment will be contingent upon clear results of a background check, particularly clear of convictions of the crimes of cyberterrorism, espionage, fraud, harvesting, identity theft, hacking, and misuse of accounts. Background checks will only be conducted after a conditional offer of employment has been made, and will include Social Security verification, a criminal history review, and a domestic terrorist watchlist search, but not a credit check. Our full company policy will be shared with you prior to the search, which will not commence without your written consent.