Patient Revenue Management Organization

Pursue your passion for caring with the Patient Revenue Management Organization, which is the fully integrated, centralized revenue cycle organization that supports the entire health system in streamlining the revenue cycle. This includes scheduling, registration, coding, billing, and other essential revenue functions for Duke Health.

PRMO Finance - Business Intelligence

Analyst, IT, SR

Job Code: 2426

Internal Job Description

About Duke Health's Patient Revenue Management Organization

The Patient Revenue Management Organization (PRMO), is Duke Health's fully integrated, centralized revenue cycle organization that supports the entire health system in streamlining the revenue cycle. This includes scheduling, registration, coding, billing, and other essential revenue cycle functions. The PRMO Business Intelligence (BI) department resides within the PRMO and is responsible for understanding the core technical components of Duke Health's EHR. The department is responsible for the design, development, support, and execution of reports, dashboards, and data solutions to support Duke Health's revenue cycle operations.

General Description of the Job Class

This position plays a key role in transforming Epic EHR revenue cycle data into detailed reports, comprehensive analysis, and interactive visualization dashboards. This position requires proficiency in SQL and data modeling and advanced skills in data visualization tools. The developer will collaborate with business stakeholders to translate requirements into technical solutions, develop dashboards, and optimize BI solutions to support strategic decision-making.

Duties and Responsibilities of this Level

Reporting Solutions: Assist in gathering and understanding business requirements from stakeholders to support BI solutions. Develop basic SQL queries to extract, transform, and analyze datasets. Utilize data visualization tools like Tableau and Power BI to create simple, yet effective reports and dashboards. Learn and apply best practices in data modeling and ETL processes to ensure data integrity and accuracy. Collaborate with senior team members to refine and optimize reporting solutions.

Data Visualizations: Create and maintain basic interactive visualizations in Tableau and Power BI. Simplify complex data sets into clear graphics and stage data for visualization.

Technological Innovation: Provide support in exploring new technologies and emerging BI platforms. Assist in implementing these technologies and learn from senior team members.

Technical Expertise: Develop foundational skills in BI platforms, resolve basic technical challenges, optimize performance, and ensure functionality. Assist in developing, debugging, and troubleshooting SQL queries, Tableau/Power BI dashboards, and other reporting functions.

Education

Bachelor's Degree in Information Technology, Computer Science, or a related technical field is required.

Experience

• Six years of related technical experience required, of which 4 years' experience in an Epic EHR reporting environment.
• Proficiency in SQL and data modeling: Ability to write complex queries and design efficient database schemas.
• Advanced skills in data visualization tools: Proficiency in creating detailed and interactive dashboards using tools like Tableau or Power BI.
• Strong programming skills: Advanced knowledge of SQL for complex data manipulation and analysis.
• Ability to translate business requirements into technical specifications: Skill in understanding business needs and converting them into technical solutions.
• Excellent communication and collaboration skills: Ability to work effectively with stakeholders and team members.
• Proven experience with Epic EHR data and revenue cycle management

Certifications

Certification in Epic Clarity Data Model and Revenue Data Model required.

Knowledge, Skills, Abilities, and Personal Characteristics

• Ability to clearly articulate ideas and findings to team members and stakeholders. Effective listening skills to understand requirements and feedback.
• Willingness to work collaboratively with colleagues, share knowledge, and contribute to team goals.
• Openness to learning new tools, technologies, and methodologies. Ability to adjust to changing project requirements and priorities.
• Advanced analytical skills to tackle complex issues and develop effective solutions. Creative thinking to approach problems from different angles.
• Careful and precise approach to data analysis and report creation to ensure accuracy and reliability.
• Ability to manage time effectively, prioritize tasks, and meet deadlines.