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: Responsibilities: Data Analysis and Data Mining (40%) Use statistical methods to analyze fundraising data to identify statistically significant patterns and trends that generate actionable insights Provide high-confidence-level forecasts that allow the business to make informed decisions Perform analysis and interpretation of data to demonstrate fundraising outcomes, within specified timeframes and frequencies Report, Dashboard and Scorecard Creation (40%) Gather requirements, create queries, build reports and dashboards that integrate multiple sources of data, identify actionable insights and conclusions, and translate complex results into simple visualizations that will empower department leaders to take decisive action Develop trend analysis reports that monitor key performance indicators and compares them to internal and external benchmarks and uses this data to assist leadership in decision-making, planning and implementing performance improvement strategies Convene colleagues to share information and best practices. Analyze report results with a focus on explaining changes, inconsistencies and any patters that are identified. Become an established Subject Matter Expert within the Organization (20%) Work collaboratively with Development leadership to understand and design analytical approaches to open-ended strategic business problems and communicates the findings to key stakeholders through reports, presentations, storytelling and thoughtful discussion; Collaborate with the Development leadership team in order to identify trends and opportunities to improve and maximize fundraising revenue Serve as a technical and educational resource to others on fundraising data and benchmarks, modeling, data acquisition and rapid analysis for insight generation Performance Objectives First 1-3 months Demonstrate basic knowledge and understanding of the higher education advancement industry, with particular emphasis on the major gift fundraising component in particular. Demonstrate intermediate level understanding of the t-SQL language, SQL Server Reporting Services and Tableau. Demonstrate basic understanding of the advancement data warehouse. First 3-6 months Demonstrate intermediate knowledge and understanding of higher education major gift oriented fundraising. Assume technical responsibility for the monthly fundraising suite of reports and being transition of existing t-SQL extract – Excel legacy reports to SSRS and / or Tableau. Assume technical responsibility for the existing SSRS based Fundraising Dashboard and all linked reports. First 12 months Demonstrate intermediate knowledge and understanding of the higher education advancement industry. Assume analysis responsibility for monthly fundraising performance analysis. Assume business evolution responsibility for monthly reports and the fundraising dashboard. Why Join Ohio State Advancement Now? 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. More about Advancement Reporting and Analytics 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. Experience Requirements The selected candidate for this position must have demonstrated success in several areas, including: 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. 5 years’ 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. 2 years of experience with statistical analysis using statistical packages for analyzing datasets (Excel, SPSS, R, SAS etc.). 2 years of experience visualizing and presenting data. Desired requirements include: Master’s degree in Statistics, Business, Computer Science, Economics, Engineering, Mathematics or other quantitative disciplines. Experience in the non-profit fundraising space. Familiarity with statistical algorithms such as linear and logistic regression, decision trees, neural networks, etc. 2 years of project management/consulting experience. Experience working in an Agile SCRUM environment. 2 years’ experience building dashboards. 2 years of experience conducting forecasting models. You Need To Know 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. Closing Statement 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. How to Apply 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 bright.159@osu.edu .

Search for Assistant Vice President, Data Analytics and Reporting The University of Maryland, Baltimore The Position The University of Maryland, Baltimore (UMB), the state’s public health, law, and human services university, seeks an innovative, collaborative, leader to serve as its inaugural Assistant Vice President, Data Analytics and Reporting (AVP). The AVP will serve as the founding director of UMB’s Office of Data Analytics and Reporting. The new office will support the entire University‘s analytic and reporting needs within and across a wide range of functional areas, including finance, academic affairs, research administration, human resources, student affairs, and philanthropy. The new office will be responsible for developing a decision support program that leverages data in the warehouse, and will advance the development of data management practices, business intelligence tools, the application of advanced analytics, and the development of interactive dashboards and reports. The AVP will work with key leaders in IT, in numerous administrative offices, and with personnel in schools and departments, in promoting the effective use of data to address key questions, assess performance, and inform decision-making. The AVP will bring a fresh perspective to administrative data management, analytics, and reporting within and across institutional sources of data. The person will identify opportunities to apply contemporary approaches to analytics and reporting through the use of state-of-the-art tools and technologies. The AVP will join campus leadership in fostering a campus-wide culture of informed decision-making and a philosophy of comprehensive self-service reporting such that business intelligence tools and data analytics capabilities are available to all schools and departments. The person will promote enterprise-wide reporting and analytics program that opens the doors to more information and understanding about UMB, leading to data-informed decisions. The AVP is responsible for consulting with and listening to UMB leaders; communicating the benefits and capabilities of the data analytics program; making presentations that demonstrate the value and outcomes produced by transparent BI technologies and data analytics; and encouraging the use of multiple administrative data sources and analytics for decision support related to the management of resources and achieving institutional and school-based goals and strategic outcomes. Candidates should possess demonstrated experience in the field of information management or analytics and reporting; demonstrated expertise with business intelligence and predictive analytics, as well as using and/or leading data warehouse efforts; and significant experience with large databases and Enterprise Resource Planning statistical software programs, spreadsheets, and query, and data mining software; UMB is assisted in this search by Isaacson, Miller, and a national executive search firm. All inquiries, nominations, and applications should be directed in confidence to the firm as described at the end of this document. To Apply All inquiries, nominations/referrals, and application materials should be submitted in confidence via Isaacson, Miller’s website: Daniel Rodas, Partner Liz Vago, Managing Associate Click the "Apply Now" button on this page to be taken to the website. Electronic submission of materials is strongly encouraged. The University of Maryland, Baltimore is an Equal Opportunity/Affirmative Action Employer. Minorities, women, veterans and individuals with disabilities are encouraged to apply.