Power BI Data Analyst

Job Description

Job Description

Power BI Data Analyst
*Local to Richmond, VA only please
*This is a remote position
*Candidate will need to report onsite to collect equipment
*Candidate may choose to either work part time at 20 hours/week or full time at 40 hours/week

• This engagement aims to transform a large Excel extract of potential duplicate patient encounters into a structured interactive Power BI dashboard that supports data quality improvement and operational cleanup.
• The consultant will work with HIM data governance and clinical operations teams to define the criteria and visualizations needed to surface duplicate patterns encounter clusters and high-risk records.
• The dashboard will help teams quickly identify duplicates understand root causes and prioritize remediation efforts.
• The resource may also be engaged in other Power BI work related to the client as it arises if time in needed.

• Conduct requirements sessions with HIM data governance and operations
• Analyze the structure and quality of the duplicate encounter extract
• Build a Power BI data model capable of handling large datasets
• Develop visualizations for duplicate patterns encounter groupings frequency and severity indicators
• Create filters for facility date ranges encounter type and risk level
• Implement automated refresh and validation logic
• Iterate with stakeholders to refine insights and usability
• Deliverables
• Requirements document and dashboard wireframes
• Power BI data model and transformation logic
• Duplicate Encounter Identification dashboard
• Data dictionary and process documentation
• Knowledge transfer session with internal staff

• Week 1-3: Requirements gathering data review
• Week 4-8: Data modeling initial dashboard build
• Week 9-10: Stakeholder review refinement
• Week 11-12: Final dashboard delivery documentation

• Power BI & Data Modeling Expertise, Required
• Analytics & Data Interpretation, Required
• Stakeholder Engagement & Requirements Gathering, Required
• Ability to translate extracts and data, Required
• Technical & Tooling Skills, Required
• Training & Knowledge Transfer, Required
• Project & Delivery Skills, Required
• Background in operational reporting or IT service management analytics, Nice to have
• Experience with EHR systems (Cerner/Oracle Millennium, AVATAR), Nice to have