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.