Revenue Cycle Report Writer

Role Description

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.

Qualifications

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

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.