Data Reporting Analyst, Department of Medical Education Current UC employees must apply internally via SuccessFactors > http://bit.ly/UCEMPL Founded in 1819, the University of Cincinnati ranks among the nation's best urban public research universities. Home to more than 50,000 students, 11,000 faculty and staff and 340,000 alumni, UC combines a Top 35 public research university with a physical setting The New York Times calls "the most ambitious campus design program in the country." With the launch of Next Lives Here, the Cincinnati Innovation District, a $100 million JobsOhio investment, nine straight years of record enrollment, worldwide leadership in cooperative education, a dynamic academic health center and entry into the Big 12 Conference, UC's momentum has never been stronger. UC's annual budget tops $1.65 billion and its endowment totals $1.8 billion. The University's overall regional economic impact exceeds $10.6 billion, paving the way for the future of Cincinnati. Job Overview As one of the oldest medical schools in the country, the University of Cincinnati (UC) College of Medicine has a reputation for training best-in-class health care professionals and developing cutting-edge procedures and research that improves the health and clinical care of patients. The Office of Medical Education is seeking a full-time Data Analyst. This position will provide data analytic support for the College of Medicine to support and maintain system data between various University of Cincinnati databases. This position is hybrid optional Essential Functions Conduct research and collect data which will help in continual product/report development that will meet UC COM/UC Physicians, Inc. objectives. Perform system analysis, data analysis or programming, using Excel, Access, and SQL server. Work to identify data related problems and solve them. Ensure high quality data is collected and the integrity of the data. Process data and develop reports on various projects. Conceptualize data and sharing this knowledge through effective presentation of the data output with the rest of the team and key stakeholders. Effectively communicate with business users and IT/Data Engineering teams to maintain appropriate project management, prioritize development, and increase information product functionality. Develop and prepare information products to be used by the organization. Database design, security, data storage and management. Ensure smooth and proper running of database. Act as source of knowledge for all Accounting and Financial database systems and tools. Support department during budget season (December - March) for troubleshooting on an on-call basis. May be required to work on weekends. Perform related duties based on departmental need. This job description can be changed at any time. Required Education Bachelor's Degree. Five (5) years of relevant work experience and/or other specialized training can be used in lieu of education requirement. Required Experience One (1) year database management or related experience. Familiarity with Access, SQL Server (SSMS), PowerBI, and other data analysis tools. Advanced Excel skills/speed. Physical Requirements/Work Environment Office environment/no specific unusual physical or environmental demands. Compensation and Benefits UC offers a wide array of complementary and affordable benefit options, to meet the financial, educational, health, and wellness needs of you and your family. Eligibility varies by position and FTE. Competitive salary range dependent on the candidate's experience. Comprehensive insurance plans including medical, dental, vision, and prescription coverage. Flexible spending accounts and an award-winning employee wellness program, plus an employee assistance p