RCO Business Intelligence Analyst, Sr

University of Virginia; Charlottesville (VA); 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. In this role, you will design and maintain BI reports and tools, ensuring data accuracy and availability while collaborating with various stakeholders. Your expertise in T-SQL and BI tools will be crucial in supporting Revenue Cycle Operations. This position offers the chance to mentor team members and contribute to performance improvement initiatives, making a significant impact in a dynamic healthcare environment. If you're passionate about data-driven solutions and want to enhance operational efficiency, this opportunity is for you.

Qualifications

• 7+ years of relevant experience with a minimum of 5 years in Revenue Cycle.
• Expert with T-SQL and skilled in organizing and analyzing large datasets.

Responsibilities

• Design, create, and maintain analyses and BI reports for Revenue Cycle Operations.
• Collaborate with stakeholders to ensure accurate data and reporting solutions.

Skills

T-SQL

Data Analysis

Business Intelligence (BI)

Microsoft Excel

Data Validation

Data Collection Tools Design

Education

Bachelor's Degree

Tools

Microsoft SSIS

Microsoft SSRS

Microsoft SSAS

SAP Crystal Reports

Epic Reporting Workbench

Tableau

Minitab

R

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.

Responsibilities

• 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.

Compensation

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.