Sr Reporting Analyst

University of Rochester; City of Rochester (NY); On-site; USD 64,000 - 96,000; Full time

Job summary

University of Rochester seeks a data analytics professional to develop and maintain comprehensive dashboards and reports for the Department of Surgery. You will collect, analyze, and translate data requirements, create ad-hoc reports, and present findings to leadership, staff, and faculty to support strategic decisions.

The role emphasizes data integrity, collaboration with Revenue and IT teams, and use of Tableau, Power BI, SQL, and Excel to enable data-driven insights across clinical and

Qualifications

• Bachelor’s degree and 5 years of relevant experience required.
• Or equivalent combination of education and experience.

Responsibilities

• Develops methods for data collection, analysis, and reporting for the Department of Surgery.
• Utilizes best practices. Analyzes and interprets data using statistical techniques for reporting purposes.
• Identifies actionable insights and recommendations. Creates presentations and reports based on findings.
• Works directly with Department & Division Leadership, Faculty, and Staff to identify analytical requirements as well as collect data requirements, analyze, determine technical issues, and design ad-hoc reports.
• Collects, analyzes and documents business requirements and translates into function and system requirement specifications.
• Guides Administrators, Practice Managers, and Faculty in navigating reporting systems.

Skills

Data analysis

Tableau

Power BI

SQL

Excel

Communication

Presentation

Education

Bachelor’s degree

Tools

Tableau

Power BI

SQL

Excel

Job description

As a community, the University of Rochester is defined by a deep commitment to Meliora - Ever Better. Embedded in that ideal are the values we share: equity, leadership, integrity, openness, respect, and accountability. Together, we will set the highest standards for how we treat each other to ensure our community is welcoming to all and is a place where all can thrive.

Job Location (Full Address):

601 Elmwood Ave, Rochester, New York, United States of America, 14642

Opening:

Worker Subtype:

Regular

Time Type:

Full time

Scheduled Weekly Hours:

40

Department:

910140 Surgery Central Administration

Work Shift:

UR - Day (United States of America)

Range:

UR URG 111

Compensation Range:

$64,200.00 - $96,200.00

The referenced pay range represents the minimum and maximum compensation for this job. Individual annual salaries/hourly rates will be set within the job’s compensation range, and will be determined by considering factors including, but not limited to, market data, education, experience, qualifications, expertise of the individual, and internal equity considerations.

Responsibilities:

Develops methods for data collection, analysis, and reporting for the Department of Surgery. Utilizes best practices. Analyzes and interprets data using statistical techniques for reporting purposes. Identifies actionable insights and recommendations. Creates presentations and reports based on findings. Works directly with Department & Division Leadership, Faculty, and Staff to identify analytical requirements as well as collect data requirements, analyze, determine technical issues, and design ad-hoc reports. Collects, analyzes and documents business requirements and translates into function and system requirement specifications. Guides Administrators, Practice Managers, and Faculty in navigating reporting systems. Supports revenue integrity, provider onboarding, and manages assigned projects.

ESSENTIAL FUNCTIONS

• Organizes, directs, develops and updates methodologies for reporting data. Conducts data analysis and reports on studies that collect and analyze internal and external report data. Designs, develops, and maintains complex reports, dashboards, and data visualizations to support various divisions, including academic, administrative, and clinical areas. Trains and mentors division administrators and practice managers on self-service reporting visualizations and dashboards in Tableau and eRecord.
• Establishes and maintains data strategy and data integrity. Builds and maintains systems for reporting data using a variety of data systems. Collaborates with administrators and key stakeholders to ensure timely access to high quality and reliable institutional data. Collaborates with IT and data management teams to ensure data integrity, consistency, and security across all reporting systems.
• Supports department revenue integrity through routine analysis of billing trends of existing service lines. Conducts reviews of new service lines and providers. Serves as a subject matter expert for new department builds. Works closely with the United Business Office, including department’s Revenue Cycle Advisor and Coding Manager. Collaborates with MSO and ISD for new provider build/enrollment and any necessary updates to existing providers. Maintains records of provider identifiers, locations, and supervising relationships.
• Leads cross-functional projects involving data analysis and reporting. Requests escalation to department embedded analyst and or centralized reporting teams as necessary.
• Provides trend analysis and forecasting to support Department strategic planning, budget cycles, and business plans. Including analysis of financial, operational, and physician productivity metrics.
• Other duties as assigned.

MINIMUM EDUCATION & EXPERIENCE

• Bachelor’s degree and 5 years of relevant experience required
• Or equivalent combination of education and experience

KNOWLEDGE, SKILLS AND ABILITIES

• Strong analytical and problem-solving skills with attention to detail required
• Ability to manage multiple projects and meet deadlines required
• Excellent communication and presentation skills, with the ability to translate complex data into clear, actionable insights required
• Proficiency in data analysis tools (e.g., Excel, SQL, Tableau, Power BI) required

The University of Rochester is committed to fostering, cultivating, and preserving an inclusive and welcoming culture to advance the University’s Mission to Learn, Discover, Heal, Create – and Make the World Ever Better. In support of our values and those of our society, the University is committed to not discriminating on the basis of age, color, disability, ethnicity, gender identity or expression, genetic information, marital status, military/veteran status, national origin, race, religion, creed, sex, sexual orientation, citizenship status,or any other characteristic protected by federal, state, or local law (Protected Characteristics). This commitment extends to non-discrimination in the administration of our policies, admissions, employment, access, and recruitment of candidates, for all persons consistent with our values and based on applicable law.