Reporting Analyst at The Ohio State University
Posting DateJanuary 10, 2018
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
The reporting analyst serves as a member of the team providing fundraising and alumni relations data analysis and reporting services for Advancement and the University. This position provides data extraction and presentation assistance using visual query tools, custom built standard outputs and Microsoft SQL Server reporting tools. Results include generating communications lists, providing support for direct marketing efforts, delivering data analysis lists and building ad-hoc and production level reports.
Builds and tests queries and performs data validation while managing multiple projects with set deadlines. The reporting analyst identifies problems, anticipates needs, resolves data file problems, creates and maintains documentation for processes, exceptions, and decision-making criteria for projects and ongoing processes.
Bachelor’s Degree or equivalent education/experience; Must understand database query tools, gathering user requirements, data quality control, problem-resolution and excellent customer service practices when working with end users; Functional and technical proficiency with office productivity software including, but not limited to MS Excel and MS Access.
Data analysis, report development, troubleshooting, and experience with a CRM system (preferably Blackbaud); Working with data for the purposes of fundraising; Experience with MS SQL Reporting Services; Experience with MS SQL Server.
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.