Job details

EA - Data Services Specialist II

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.

A Data Services Specialist II serves as the primary engineer on all data-related aspects of the client onboarding and post-onboarding process. A Data Services Specialist II 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 of CRM solutions and relational databases, and experience working with non-profit or political campaign related data.

Responsibilities

Develop SQL scripts and protocols for Mid-Market and Enterprise Data Conversions
Work on specialized migration assignments (ex. payments migrations)
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
Quote basic technical services
Awareness of when to seek out technical guidance for code review or advice
Develop SQL scripts and protocols for back-end editing requests and 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

Requirements

3+ years experience in data migration
Proficient in manipulating data via SQL, including but not limited to:

update, insert, delete string functions
subqueries
complex table joins
Database schema (primary keys, indexes, execution plans, etc..)
Knowledge of Microsoft SQL Server, Microsoft Access, Oracle and/or similar platforms
Demonstrated competency in project management
Ability to manage client requests and questions, and to be a technical resource in client-facing calls
Proficient in oral and written communications
Demonstrated ability to meet deadlines in a fast-paced environment
Experience with accurate time-keeping entry
Strong attention to detail

This position is part of a bargaining unit represented by CWA Local 1400, 2336 or 13000.

Compensation

The range displayed on this job posting reflects the minimum and maximum target for new hire salaries for the position across all US locations. Within the range, individual pay is determined by work location and additional factors, including job-related skills, experience, and relevant education or training.

Base pay is one part of the Total Package that is provided to compensate and recognize employees for their work, and in addition to benefits this role may be eligible for discretionary bonuses/incentives, and equity.

US base salary range: $64,800 - $97,200.

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 comprehensive and competitive benefits include:

Generous Flexible Time Off (FTO) 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
Paid sick leave
Health, vision, dental, and life insurance with additional access to health and wellness programs.
Opportunities to learn, develop, network, and connect

We are committed to being an equal opportunity employer and evaluate qualified applicants without regard to race, color, religion, sex, pregnancy (including childbirth, lactation and related medical conditions), national origin, age, physical and mental disability, marital status, sexual orientation, gender identity, gender expression, genetic information (including characteristics and testing), military and veteran status, diversity of thought and any other characteristic protected by applicable law.

Social Solutions Glassdoor Company Review

3.4

Social Solutions DE&I Review

No rating

CEO of Social Solutions

Mark Layden

Approve of CEO

By Social Solutions

Unrivaled technology: To provide the industry’s best technology and data solutions to measure and impact social change.Improved outcomes: To lead and advance the ability to measure and optimize outcomes.Community impact: To enable communities to d...

9 jobs

MATCH

Calculating your matching score...

INDUSTRY

Computer Hardware Development

TEAM SIZE

201-500

LOCATION

Hybrid, based in Austin, TX

DATE POSTED

August 4, 2023