Revenue Cycle Report Writer (100% Remote)

Duke Careers•Durham, NC

3d•Remote

About The Position

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. 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, including scheduling, registration, coding, billing, and other essential revenue cycle functions. The PRMO Business Intelligence (BI) department, where this position resides, is responsible for understanding the core technical components of Duke Health’s EHR and for the design, development, support, and execution of reports, dashboards, and data solutions to support Duke Health’s revenue cycle operations. This position plays a key role in transforming Epic EHR revenue cycle data into detailed reports, comprehensive analysis, and interactive visualization dashboards. It 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.

Requirements

Bachelor's Degree in Information Technology, Computer Science, or a related technical field is required.
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
Certification in Epic Clarity Data Model and Revenue Data Model required.
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.

Responsibilities

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.
Create and maintain basic interactive visualizations in Tableau and Power BI.
Simplify complex data sets into clear graphics and stage data for visualization.
Provide support in exploring new technologies and emerging BI platforms.
Assist in implementing these technologies and learn from senior team members.
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.