Data Analyst

Engagement Type

Contract

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, drill‑downs, and role‑based views
• Establish refresh logic and data‑quality 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 leadership‑ready visuals
• Documentation for refresh processes and data definitions
• 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 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