Bonterra
We help the people who make social good possible drive more impact for more people, in less time.
Washington DC
Remote

Senior SQL Server Developer (NGP VAN) at Bonterra (Washington DC or Remote)

| Washington DC +3 more | Remote
Sorry, this job was removed at 1:54 p.m. (CST) on Wednesday, September 28, 2022
Find out who's hiring in Washington DC.
See all Developer + Engineer jobs in Washington DC
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Overview
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.
We are currently operating as a remote workforce and have equipped our teams with the technology to stay connected to each other and our customers.
Responsibilities & Requirements
As a Senior SQL Server Developer you will be collaborating with application software engineers, architects, product analysts, and third-party clients to design and develop database schemas, stored procedures, and general data processes for a large scale web application.
You will possess strong attention to detail, excellent relationship management skills, and be comfortable in working in a time-sensitive environment while meeting critical deadlines. You should have experience writing SQL queries and have an understanding of data modeling and normalization techniques.
The perfect candidate would have past experience with political or non-profit data in a technology, field organizing, digital, or fundraising position.
Responsibilities
  • Support new product development by creating new database solutions and stored procedures in an OLTP environment
  • Work closely with Application Developers to ensure proper design and implementation of database systems
  • Implement and improve advanced ETL processes that acquire, load, or deliver large datasets to and from clients and partners
  • Assist in developing SQL scripts and business processes for large scale database deployments
  • Support current database architecture, and troubleshoot and optimize existing code

Crucial Skills/Experience - A good candidate will have all of these:
  • 10+ years experience writing complex SQL queries
  • Experience with performance tuning and indexing strategies
  • Strong understanding of general software design principles and practices including data modeling
  • Enterprise software development experience
  • Experience with dynamic SQL

Additional Skills/Experience - A great candidate will have several of these
  • Experience with non-profit fundraising, campaign/volunteer management, or general purpose CRM applications
  • Experience with query optimization and effective index usage
  • Exposure to cloud-based database technologies (Azure/AWS)
  • Exposure to various ETL technologies
  • Exposure to Agile/Scrum workflows and iterative design principles
  • Experience working in a geographically distributed team, along with associated collaboration software
  • Familiarity with C# .Net (you won't have to write this but being able to read your coworkers' code can be very helpful)
  • Experience with Powershell

This position is part of a bargaining unit represented by CWA Local 1400, 2336 or 13000.
About Us
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.
Some of our comprehensive and competitive benefits include:
  • Generous PTO 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
  • Health, vision, dental, and life insurance with additional access to health and wellness programs.
  • Opportunities to learn, develop, network, and connect
  • When we can-company-sponsored events and swag!!
See More
Apply Now
By clicking continue you agree to Built In’s Privacy Policy and Terms of Use.
Candidate Location Eligibility:
Atlanta, GA
Austin, TX
Washington DC

Technology we use

  • Engineering
  • Product
  • Sales & Marketing
  • People Operations
    • C#Languages
    • JavascriptLanguages
    • PHPLanguages
    • ReactLibraries
    • ReduxLibraries
    • ASP.NETFrameworks
    • Node.jsFrameworks
    • ZendFrameworks
    • TrustRadiusAnalytics
    • AsanaManagement
    • ConfluenceManagement
    • SmartsheetManagement
    • WordpressCMS
    • ZapierCMS
    • SalesforceCRM
    • DrawloopCRM
    • TenfoldCRM
    • DocuSignCRM
    • OutreachCRM
    • MarketoLead Gen
    • BizibleLead Gen
    • TableauLead Gen
    • SlackCollaboration
    • ZoomCollaboration
    • SmartsheetProject Management
Previous
Next

What are Bonterra Perks + Benefits

Culture
Volunteer in local community
Receive up to 8 paid hours per quarter to volunteer with a non-profit organization of your choice.
Partners with Nonprofits
Friends outside of work
Daily sync
Open door policy
Open office floor plan
Diversity
Dedicated Diversity/Inclusion Staff
Highly diverse management team
Unconscious bias training
Diversity Employee Resource Groups
Hiring Practices that Promote Diversity
Health Insurance & Wellness Benefits
Flexible Spending Account (FSA)
The Dependent Care FSA allows you to set aside up to $5,000 per plan year to cover expenses such as day care, after-school programs, and mroe so you and your spouse can work or go to school.
Disability Insurance
Our benefits include short and long-term disability, as well as $50K of coverage provided by the company for employees.
Dental Benefits
We pay 100% of medical insurance for employees. Dental and vision is free for employees and family. We offer an HSA match for employees and family.
Vision Benefits
We pay 100% of medical insurance for employees. Dental and vision is free for employees and family. We offer an HSA match for employees and family.
Health Insurance Benefits
We pay 100% of medical insurance for employees. Dental and vision is free for employees and family. We offer an HSA match for employees and family.
Life Insurance
Our benefits include short and long-term disability, as well as $50K of coverage provided by the company for employees.
Pet Insurance
Wellness Programs
Our Wise and Well program offers monthly events incorporating physical, intellectual, emotion, financial and social well-being – like chair massages, financial planning workshops, and happy hours.
Onsite Gym
Mental Health Benefits
Retirement & Stock Options Benefits
401(K)
We offer a 401K match to help our employees invest in their future retirement.
401(K) Matching
Social Solutions' 401(K) retirement plan matches 50% of an employee's contributions up to 3% of their annual base salary.
Performance Bonus
Many individual contributor roles at Social Solutions are eligible for an annual performance bonus. Bonuses are based on a percentage of the employee's salary and are paid during performance reviews.
Match charitable contributions
Child Care & Parental Leave Benefits
Generous Parental Leave
We recognize the importance of bonding with a new baby, so new parents receive paid off for both birthing and non-birthing leave.
Flexible Work Schedule
Bonterra employees are encouraged to work with their manager to establish a schedule that works both for them and for the business.
Remote Work Program
All employees will work from home will be until June 1st, 2021. Optional/reservable work from office is available.
Family Medical Leave
Bonterra will provide up to 12 weeks of unpaid, job protected leave to eligible employees for a variety of reasons.
Vacation & Time Off Benefits
Unlimited Vacation Policy
Paid Volunteer Time
Bonterra provides each employee with 8 hours of paid volunteer time per quarter. Employees are encouraged to volunteer with an organization of their choice.
Paid Holidays
Paid Sick Days
Bonterra employees are able to take paid sick days as a part of our Flexible PTO policy.
Perks & Discounts
Beer on Tap
Casual Dress
Bonterra's culture is laid back and our dress code matches that. Employees dress in casual clothing every day.
Company Outings
Bonterra has an annual summer party and a holiday party for all employees and a guest. Past parties have included a casino night, a shrimp boil, and of course eating BBQ.
Game Room
The Bonterra break room includes an arcade machine with over 1000 games, a ping pong table, pop a shot basketball, and corn hole. We're very competitive and regularly hold gaming tournaments.
Happy Hours
We work hard and we play hard. Bonterra hosts happy hours once per month either in our office break room or at a local bar.
Parking
We recognize that Austin isn't known for it's public transportation, so we have on-site parking for all employees.
Recreational Clubs
Bonterra offers a variety of groups for employees to join that range from sports leagues to breakfast clubs and book clubs.
Home Office Stipend for Remote Employees
Professional Development Benefits
Job Training & Conferences
We offer a 2-Day New Hire Orientation, monthly professional development training, a High Potential program that accelerates growth of our top talent, and the LEAD program which is offered to managers.
Tuition Reimbursement
Bonterra offers $1,500 per year toward role related graduate and undergraduate programs or $500 per year for continued education courses.
Diversity Program
Promote from within
Continuing Education stipend

More Jobs at Bonterra