Reporting to the Director, Reporting and Analytics, the Senior Data Analytics Consultant provides fundraising data analysis and reporting services for the executive leadership team of the Development arm of the Office of Advancement.
The Sr. Data Analytics Consultant will be primarily responsible for the development and implementation of measurement and analytics strategies designed to ensure appropriate operational models; to monitor and evaluate applicable metrics to compare and analyze data to support strategic fundraising decisions and process improvement; to ensure communication with senior leadership and synthesize data into useful and insightful information; and to write and automate tools and scripts to increase efficiency and reduce manual efforts.
The Sr. Data Analytics Consultant will design and build data visualizations using diverse data sets and will be instrumental in developing and translating analysis, data modeling and ad hoc decision support to fulfill the needs of the development organization. This includes data analysis and reporting to enhance operational efficiency, encouraging data driven decisions and promoting a higher level of data consumption as well as best practices to improve services and processes of strategic importance to the Development team.
Provides significant data analysis using both descriptive and predictive statistical analysis expertise for the Development leadership team. This work includes, but is not limited to, responsibility for the ongoing design and maintenance of monthly Development performance reports and the fundraising dashboard. It further includes conducting significant data analysis and data mining required to understand the results found and communication of insights to leadership.
This work is accomplished using visual query tools, custom built standard outputs, Microsoft SQL Reporting Services tools, data analysis tools like SPSS or Excel and Tableau.
Position highlights include opportunities to accomplish the following:
Data Analysis and Data Mining (40%)
Report, Dashboard and Scorecard Creation (40%)
Become an established Subject Matter Expert within the Organization (20%)
First 1-3 months
First 3-6 months
First 12 months
In 2016, The Ohio State University concluded the most successful fundraising effort in its history, with contributions from what is believed to be the most donors ever to a higher education campaign. The But for Ohio State Campaign raised over $3 billion from more than 750,000 donors, shattering the goal of $2.5 billion. Ohio State is now six months away from the public kickoff of the next campaign which coincides with the celebration of the university’s 150th birthday. All members of Advancement are part of creating an inclusive culture that inspires an exceptionally diverse and talented team and are measured on their adherence to the following core competencies: leadership, continuous improvement, teamwork and collaboration, and communication/interpersonal effectiveness.
Reporting and Analytics (R&A) is one part of the Business Intelligence and Data Science department totaling 15 full-time staff within Advancement. R&A is comprised of 10 staff members with nearly 100 years combined experience working in the Advancement and Enterprise Reporting professions. We are an extremely collaborative group possessing particular technical expertise in t-SQL, SSRS and Tableau. The larger BI team also then possesses extensive experience in Market Research and Data Sciences. Those groups are similarly collaborative in their approach and give the larger BI team experience in market research and advanced statistical techniques. Finally our in group project manager is guiding us in the implementation of the Agile Project Management approach.
The selected candidate for this position must have demonstrated success in several areas, including:
Desired requirements include:
Aside from the unparalleled benefits of working for The Ohio State University and working in the diverse, smart, safe, fun and growing city of Columbus, Ohio, this opportunity will provide exceptional rewards that arise from working for a land grant institution where you will truly feel the impact of your work.
The Ohio State University is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation or gender identity, national origin, disability status, or protected veteran status.
Please click the "Apply Now" button on this page to find out more about University Advancement and apply online.
Questions may be directed to Greg Bright, Recruiter, at firstname.lastname@example.org.