Senior Data Consultant

Bonterra exists to propel every doer of good to their peak impact. We measure that impact against our vision to increase the giving rate as a percentage of GDP from 2% to 3% by 2033. We know that this goal is lofty, but we are confident that the right technology and expertise will strengthen trust in the sector, allowing the social good industry to accelerate growth and reach peak impact. Bonterra's differentiated, end-to-end solutions collectively support a unique network of over 20,000 customers, including over 16,000 nonprofit organizations and over 50 percent of Fortune 100 companies. Learn more at bonterratech.com.

Are you passionate about leveraging technology for social good? Do you have a vision for using innovative solutions to drive impactful change in communities?

We are seeking a dynamic and strategic consultant to join our team as the Senior Data Consultant for a multi-city community violence intervention (CVI) initiative. In this crucial role, you'll play a key part in deploying innovative data management solutions, collaborating closely with key stakeholders including CAPS (Community Anti-Violence Programs) and cities, to evaluate systems, interpret data, and offer actionable recommendations for improvement to ensure the successful execution of project initiatives. This position is perfect for someone with a proven track record in managing complex data projects, engaging stakeholders effectively, and delivering impactful results in a dynamic, fast-paced environment. 

By leveraging deep analytical skills, insights from data, and collaborative strategies, this role helps shape policies, frameworks, and processes that propel cities and cohorts toward their violence reduction goals. This role reports to Professional Services Senior Director and will contribute significantly to on-the-ground implementation and program success. 

What You’ll Do: 

Operational Excellence & Data Management 

• Lead conversations with community stakeholders to integrate diverse perspectives into actionable, data-driven strategies for operational improvements. 

• Advocate for iterative enhancements to CVI models, ensuring operational efficiency and fostering a culture of continuous improvement. 

• Develop a Data Management Toolkit to include:   

• Data Migration: Details how to migrate data from Apricot forms and reports into SafeStat

• Data Management Strategy: Details how data will be collected, stored, reported, and quality control methods for SafeStat   

• Data Dictionary: Defines the CVI-specific fields inside of the Apricot Database for SafeStat reporting   

• Entity Relationship Diagram (ERD): Visually represents how elements in Apricot relate to one another allowing organizations to understand what data is stored, entities and their attribute, and how entities relate to one another   

• Establish and maintain rigorous data governance standards, ensuring the quality, accuracy, and timeliness of data used in decision-making. 

• Define data standards and model for data capture   

• Audit existing data systems and data export capabilities  

• Audit current data collection practices  

• Define reporting needs for each Stakeholder in each city 

Reporting & Analysis 

• Collaborate with stakeholders to define reporting and analysis needs, developing enhanced dashboards, reports, and analytics tools using SAP Business Objects [i.e. Apricot Results Reporting]