Data Analyst 4

Immediate Opening
Title: Data Analyst 4
Location: Richmond, VA 23219 United States (100 % Remote but must be able to pick up equipment IN PERSON if selected)
No. of Openings: 2
Job Duration: Approx. 03 months (High possibility of longer extensions)

**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. Currently, 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 before submitting them.

Job Description:
ABOUT THE ROLE:
This engagement focuses on converting the BugTrack issuemanagement Excel extract into a comprehensive, interactive Power BI dashboard for leadership visibility and operational decisionmaking. The consultant will collaborate with the business, HIT, IT, and operational teams to define reporting requirements and translate them into a scalable data model and intuitive visualizations. Metrics will include (but are not limited to) total tickets opened/closed, aging of open tickets, ticket type and category distribution, priority trends, facilitylevel insights, EPMOrelated tickets, and a dedicated AVATAR ticket dashboard (opened, closed, maintenance). The consultant will build automated refresh processes, apply dataquality checks, and deliver a polished dashboard ready for leadership review. The resource may also be engaged in other Power BI work related to ***** as it arises if time in needed.

Key Tasks:

• Conduct requirements workshops with the business, HIT, IT, and operational stakeholders
• Review and validate the BugTrack Excel extract structure
• Build a Power BI data model optimized for large datasets
• Develop visualizations for ticket volume, aging, type, category, priority, facility, and AVATAR metrics
• Create filters, drilldowns, and rolebased views
• Establish refresh logic and dataquality validation steps
• Iterate with stakeholders to refine usability and accuracy
• Mentor and train ***** identified SMEs for long-term maintenance
• Create and develop documentation supporting the dashboards

Deliverables:

• Requirements document and dashboard mockups
• Power BI data model and transformation scripts
• Fully developed BugTrack dashboard with leadershipready visuals
• Documentation for refresh processes and data definitions
• 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

Skills Matrix: Skill Required Amount of Experience Experience Power BI & Data Modeling Expertise Required Analytics & Data Interpretation Required Stakeholder Engagement & Requirements Gathering Required Technical & Tooling Skills Required Training & Knowledge Transfer Required Project & Delivery Skills Required Experience with EHR systems (Cerner/Oracle Millennium, AVATAR) Nice to have Background in operational reporting Nice to have IT service management analytics Nice to have

Feel free to forward my email to your friends/colleagues who might be available. We do offer referral bonus!!
Thank you for your time and for consideration. I look forward to hearing from you.