Power BI Dashboard Requirements and Development Data Analyst - SHORT TERM!
100% Remote role but must be able to pick up equipment IN PERSON if selected.
SHORT TERM EXPECTED
Pls note: This is a time sensitive role that has a tight timeline. They can choose to work full time (or part-time, 20 hrs/week) until the work is completed. If they work 40 hrs /week then the work could finish sooner and the engagement may end sooner. At this time it is slated to go to 6/30/26 (at the latest)
*Even though this is also a DA role it has different responsibilities than Req# 798838 - pls read carefully before submitting your candidates. Your candidate could potentially be able to do both roles - if so get them submitted to both
ABOUT THE ROLE This engagement aims to transform a large Excel extract of potential duplicate patient encounters into a structured, interactive Power BI dashboard that supports dataquality 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 highrisk 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 DBHDS as it arises if time in needed.
Key Tasks
Conduct requirements sessions with HIM, data governance, and operations
Analyze the structure and quality of the duplicateencounter 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
Knowledgetransfer session with internal staff
Milestones
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
| Skill | Required / Desired | Amount | of Experience |
| 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 | | |