Sr Reporting Analyst

University of Rochester•City of Rochester, NY

1d•$64,200 - $96,200•Onsite

About The Position

The Sr Reporting Analyst develops and maintains data collection, analysis, reporting, and data-integrity methods for the Department of Surgery. The role analyzes and interprets data, identifies actionable insights, and prepares reports and presentations. It works with department and division leadership, faculty, and staff to define analytical and data requirements, resolve technical issues, design ad-hoc reports, and translate business requirements into functional and system specifications. The analyst also guides administrators, practice managers, and faculty in using reporting systems, supports revenue integrity and provider onboarding, and manages assigned projects. The position designs, develops, and maintains complex reports, dashboards, and data visualizations for academic, administrative, and clinical areas, and trains and mentors division administrators and practice managers in Tableau and eRecord self-service reporting. It maintains data strategy and integrity, builds reporting systems, and collaborates with stakeholders, IT, and data management teams to ensure timely access to reliable, consistent, and secure institutional data. The role supports revenue integrity through billing-trend analysis and reviews of new service lines and providers. It serves as a subject matter expert for new department builds and works with the United Business Office, the department’s Revenue Cycle Advisor and Coding Manager, MSO, and ISD on provider builds, enrollment, and updates. It maintains provider identifiers, locations, and supervising relationships. The analyst leads cross-functional reporting and data-analysis projects and provides trend analysis and forecasting for strategic planning, budget cycles, and business plans, including financial, operational, and physician productivity metrics. Other duties may be assigned.

Requirements

Bachelor's degree and 5 years of relevant experience, or an equivalent combination of education and experience.
Strong analytical and problem-solving skills with attention to detail.
Ability to manage multiple projects and meet deadlines.
Excellent communication and presentation skills, including the ability to translate complex data into clear, actionable insights.
Proficiency in data analysis tools such as Excel, SQL, Tableau, and Power BI.

Responsibilities

Develop and update methodologies for data collection, analysis, and reporting for the Department of Surgery.
Conduct analyses of internal and external reporting data and prepare reports on studies.
Design, develop, and maintain complex reports, dashboards, and data visualizations for academic, administrative, and clinical areas.
Train and mentor division administrators and practice managers on self-service reporting visualizations and dashboards in Tableau and eRecord.
Establish and maintain data strategy and data integrity, and build and maintain reporting systems using a variety of data systems.
Collaborate with administrators and stakeholders to ensure timely access to high-quality, reliable institutional data.
Work with IT and data management teams to maintain data integrity, consistency, and security across reporting systems.
Analyze billing trends for existing service lines and review new service lines and providers to support revenue integrity.
Serve as a subject matter expert for new department builds and work with the United Business Office, Revenue Cycle Advisor, and Coding Manager.
Collaborate with MSO and ISD on new provider builds and enrollment and updates to existing providers.
Maintain records of provider identifiers, locations, and supervising relationships.
Lead cross-functional projects involving data analysis and reporting, escalating requests to the department embedded analyst or centralized reporting teams as needed.
Provide trend analysis and forecasting for department strategic planning, budget cycles, and business plans, including financial, operational, and physician productivity metrics.
Work with department and division leadership, faculty, and staff to define analytical and data requirements, collect requirements, analyze data, address technical issues, and design ad-hoc reports.
Document business requirements and translate them into functional and system requirement specifications.
Guide administrators, practice managers, and faculty in navigating reporting systems.
Support provider onboarding and manage assigned projects.