Power BI Dashboard Requirements and Development Data Analyst - SHORT TERM! MAX VENDOR Rate $$.$$: $$.$$ 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 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 Required/Desired Skills Skill Required /Desired Amount of Experience Power BI & Data Modeling Expertise Required 0 Analytics & Data Interpretation Required 0 Stakeholder Engagement & Requirements Gathering Required 0 Ability to translate extracts and data Required 0 Technical & Tooling Skills Required 0 Training & Knowledge Transfer Required 0 Project & Delivery Skills Required 0 Background in operational reporting or IT service management analytics Nice to have 0 Experience with EHR systems (Cerner/Oracle Millennium, AVATAR) Nice to have 0 Questions No. Question Question1 Commonwealth of Virginia security policies prohibit the use of offshore IT contractors. Do you attest to the fact that your candidate will physically reside within the US for the duration of the assignment? Question2 Please list candidate's email address. Question3 In what city and state does your candidate permanently reside? If your candidate is local to Richmond, have you (vendor) taken the necessary steps to verify this residency? NO NEED to upload DL - just confirm you checked their current residence. If not in Richmond, please put where they current reside. Question4 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). Please confirm that you explained to your candidate that this is expected to be a SHORT TERM engagement and they understand and agreed to that arrangement if selected bf submitting them. Question5 If selected - role is 100% remote but they maybe asked to pick up equipment IN PERSON. Do they agree to this arrangement? Remote Skills: Analysis Skills, Clinical Data, Consulting, Data Analysis, Data Collection, Data Modeling, Data Quality, Establish Priorities, IT Service Management (ITSM), Machine Tool, Operational Improvement, Power BI, Quality Management, Reporting Dashboards, Requirements Management, Risk, Training Data Sets About the Company: Advanced American Technologies, Inc