HCL Global Systems

Compensation

Full 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 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