RCO Business Intelligence Analyst, Sr

The Rector & Visitors of the University of Virginia; Charlottesville, Virginia, Evanston Township (VA, MN, IL); On-site; USD 96,000 - 156,000; Full time

Job summary

An established industry player is seeking a Senior Revenue Cycle Business Intelligence Analyst to leverage data for impactful decision-making within their operations. This role involves designing and maintaining BI reports, collaborating with stakeholders, and mentoring team members. Ideal candidates will have extensive experience in data analysis, particularly within a large academic health system, and possess strong skills in T-SQL and various BI tools. Join a diverse and inclusive environment where your insights will drive efficiency and innovation in healthcare operations.

Qualifications

• 7+ years of relevant experience in Revenue Cycle, preferably in a large academic health system.
• Expertise in T-SQL and data analysis methodologies.

Responsibilities

• Design, create, and maintain BI reports and tools for Revenue Cycle Operations.
• Mentor team members and provide consultative analytics support to leadership.

Skills

T-SQL

Data Analysis

Microsoft Excel

Business Intelligence (BI)

Data Visualization

SQL

Consultative Analytics

Education

Bachelor's Degree

Tools

Microsoft SSIS

Microsoft SSRS

Microsoft SSAS

SAP Crystal Reports

Epic Reporting Workbench

Tableau

R

Minitab

Job description

The Revenue Cycle Business Intelligence Analyst, Sr. is responsible for using the enterprise's data to design, create, and maintain analyses and BI reports and tools in support of Revenue Cycle Operations from a financial & operational perspective at UVA Health. Performs data analysis utilizing appropriate analytics methodologies and fosters data-driven decision-making by providing valuable consultative analytics support to Revenue Cycle leadership, in accordance with regulatory standards as appropriate. Mentors other team members and offers technical advice/guidance to peers within the RCO Continuous Process Improvement team and the greater Revenue Cycle team.

• Participate in cross-functional performance improvement team efforts, ensuring appropriate analysis of data, data accuracy, and data availability.
• Consult with all levels of users to help them solve problems, as well as contribute to highly-visible and impactful organizational, projects through the expert analysis and presentation of data.
• Collaborate with operational subject matter experts and stakeholders, serving as lead developer and resident expert for outcomes-related metrics, ensuring accurate metadata, target/threshold acquisition, appropriate metric and report development, data validation, maintenance, and modification.
• Collect business requirements from appropriate stakeholders, design, code, validate, deploy, and maintain the semantic layer and metadata for complex reports and reporting tools, creating efficient and appropriately distributed solutions.
• Utilize tools such as Microsoft SSIS, SSRS, and SSAS, SAP Crystal Reports, Epic Reporting Workbench, Extract Framework, and Radar Dashboards, as well as, Tableau to build BI solutions.
• Develop code with structured query language (SQL), preferably Microsoft T-SQL.
• Employ tools such as Microsoft Excel, R, and Minitab to perform analysis of data.
• Design data collection tools based on parameters appropriate for the situation.
• Perform system administration: build, test, and assist with upgrade/enhancement/patch-related implementation activities.
• Adhere to, as well as provide leadership and ideas for, team and departmental performance improvement activities related to quality standards and development best practices.
• Appropriately monitor the team work queue and triage requests (ensuring coverage if-needed).
• Prioritize and assign work for fellow team members, as well as effectively run team meetings, in the absence of the manager.
• Participate in governance and Change Control-related activities (ensuring coverage if-needed).
• Keep abreast of new and emerging technologies that could provide an enhanced BI experience for customers, conduct cost-benefit evaluations, and provide recommendations related to potential new technology offerings. Regularly provide guidance and training to less experienced team members.
• Conduct review of fellow team member's work as requested and provide innovative ideas for performance tuning and general query optimization.
• Coach customers, as appropriate, on use of BI tools.
• Adapt to competing demands, shifting priorities, and organizational constraints.
• In addition to the above job responsibilities, other duties may be assigned.

Position Compensation Range: $96,907.20 - $155,043.20 Annual

MINIMUM REQUIREMENTS

Education: Bachelor's degree
Experience: 7+ years relevant experience with a minimum of 5 years in Revenue Cycle, preferably in support of a large academic health system. Solid understanding of relational and multi-dimensional databases, schema design, indexing, and referential integrity. Expert with T-SQL. Skilled with organizing and analyzing large datasets. Proficient with Microsoft Excel and Word. Able to learn new software as-required for the position. Relevant experience may be considered in lieu of a degree.
Licensure: None required. Epic certification preferred.

PHYSICAL DEMANDS

This is primarily a sedentary job involving extensive use of desktop computers. The job does occasionally require traveling some distance to attend meetings, and programs.

The University of Virginia, including the UVA Health System which represents the UVA Medical Center, Schools of Medicine and Nursing, UVA Physicians Group and the Claude Moore Health Sciences Library, are fundamentally committed to the diversity of our faculty and staff. We believe diversity is excellence expressing itself through every person's perspectives and lived experience. We are equal opportunity employers. All qualified applicants will receive consideration for employment without regard to age, color, disability, gender identity or expression, marital status, national or ethnic origin, political affiliation, race, religion, sex, pregnancy, sexual orientation, veteran or military status, and family medical or genetic information.