Ideal Candidate Profile: Seeking a Data Analyst - Power BI Dashboard Development . This role 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 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 as it arises if time in needed.
Job Duties & Responsibilities 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
