Job ID: JOB_ID_9342
Role Overview:
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 is 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
Additional Information:
- This is a SHORT TERM engagement.
- Work Mode: Remote.
- Interview: Web Cam Interview Only.
- The role can be full-time or part-time (20 hrs/week).
- Expected duration is until 6/30/26 at the latest.
- Keywords: business intelligence, information technology, golang, Idaho.
Special Requirements
SHORT TERM engagement, Web Cam Interview Only
Compensation & Location
Salary: $50,000 – $90,000 per year (Estimated)
Location: Richmond, VA
Recruiter / Company – Contact Information
Email: esh@cyber-resource.com
Recruiter Notice:
To remove this job posting, please send an email from
esh@cyber-resource.com with the subject:
DELETE_JOB_ID_9342