Sr. Data Analytics Consultant at The Ohio State University
Posting DateNovember 12, 2019
Location of Position
For 144 years, The Ohio State University's campus in Columbus has been the stage for academic achievement and a laboratory for innovation. It's where friendships are forged. It's where rivalries and revelry are born.
The university's main campus is one of America's largest and most comprehensive. As Ohio's best and one of the nation's top-20 public universities, Ohio State is further recognized by a top-rated academic medical center and a premier cancer hospital and research center. As a land-grant university, Ohio State has a physical presence throughout the state, with campuses and research centers located around Ohio.
The Ohio State University is proud to be a premier employer that provides an exceptional total rewards package including medical, dental, vision and many other “hidden” benefits. Our competitive benefits package is offered to all eligible faculty and staff in order to attract, develop and retain top performers eager to share their talent, time and success. Our benefits support your health and financial goals and include not only health insurance, but also generous state retirement, tuition assistance for our employees and their dependents, wellness initiatives, and much more. Please visit https://hr.osu.edu/benefits/ for detailed information. Be your best at The Ohio State University!
Duties and Responsibilities
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.
The Sr. Data Analytics Consultant 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.
- Bachelor’s degree in Data Analytics, Statistics, Applied Math, Computer Science, Computer Information Systems or Management Information Systems, Marketing, Psychology or related field; or an equivalent combination of education and experience.
- Five years of experience in a data analyst role.
- Experience with enterprise reporting tools (i.e. MS BI Suite).
- Two years of experience using SQL with preference to Microsoft T-SQL.
- Two years of experience with statistical analysis using statistical packages for analyzing datasets (Excel, SPSS, R, SAS etc.).
- Two years of experience visualizing and presenting data.
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.