Revenue Cycle Report Writer (100% Remote)

At Duke Health, we're driven by a commitment to compassionate care that changes the lives of patients, their loved ones, and the greater community. No matter where your talents lie, join us and discover how we can advance health together.


About Duke Health's Patient Revenue Management Organization


Pursue your passion for caring with the Patient Revenue Management Organization, which 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 functions.


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.

Duke is an Equal Opportunity Employer committed to providing employment opportunity without regard to an individual's age, color, disability, gender, gender expression, gender identity, genetic information, national origin, race, religion, sex (including pregnancy and pregnancy related conditions), sexual orientation or military status.


Duke aspires to create a community built on collaboration, innovation, creativity, and belonging. Our collective success depends onthe robust exchange of ideas—an exchange that is best when the rich diversity of our perspectives, backgrounds, and experiences flourishes. To achieve this exchange, it is essential that all members of the community feel secure and welcome, that the contributions of all individuals are respected, and that all voices are heard. All members of our community have a responsibility to uphold these values.


Essential Physical Job Functions: Certain jobs at Duke University and Duke University Health System may include essential job functions that require specific physical and/or mental abilities. Additional information and provision for requests for reasonable accommodation will be provided by each hiring department.

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...