Senior Data Specialist
Overview
Are you a passionate innovator looking to harness the power of technology to do more good? You've come to the right place. At Bonterra, our purpose is to power those who power social impact. To that end, we serve the people who make social good possible-the doers behind the scenes across nonprofits, public agencies, corporations, philanthropic organizations, and foundations.
As the second-largest and fastest-growing social good software company in the world, Bonterra brings together leading solutions from CyberGrants, EveryAction, Network for Good, Social Solutions, and their respective entities. By bringing our intuitive technology and expertise together, Bonterra will enable unprecedented connectivity between social good organizations and their community of supporters and constituents. This will reshape philanthropic giving, empower digital transformation, and bring the social good sector the technology it needs to accelerate lasting social change.
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
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 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 ofCRM solutions andrelational databases, and experience working with non-profitorpolitical campaignrelated data.Please specifically highlight any experience working with non-profit development data, if applicable, in your cover letter.
What You'll Do
- 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, reporting, and migration requests.
- Work across departments, including Sales, Engineering, and Product, to accurately set, manage, and meet project timelines and outcomes.
- Manage and prioritize your own workflows.
- Work with team members to document technical tasks and solutions.
Who You Are
- 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 mannerto 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 torelational database software
- Experience with Salsa and or/EveryAction
- 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-profitorpoliticaldata
- Proficiency inworking with ETL applications and scripts.
- Familiarity with source control (git preferred)
- Must be able to occasionally work weekends and off hours.
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.
Our robust benefits program:
Some of our comprehensive and competitive benefits include:
- Generous PTO policy
- 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!!