Data Analyst 4 -- Richmond, Va preference
Posted Today by HCL Global Systems
Negotiable
Undetermined
Hybrid
Remote or Hybrid in Richmond, Virginia
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 DBHDS 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 DBHDS 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
| ||||
Required / Desired Skills | ||||
Skill | Required / Desired | Candidate Years of Experience | Amount | of 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 |