Job ID: VA-798840 (97190413)
Remote/Local Power BI Data Analyst (3 months ONLY) with Modeling, ITSM, Cerner/Oracle Millennium/AVATAR EHR experience
Location: Richmond, VA (DBHDS)
Duration: 3 Months
100% Remote role but must be able to pick up equipment IN PERSON if selected.
Skills:
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
Description:
Power BI Dashboard Requirements and Development Data Analyst – SHORT TERM!
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 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 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 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
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