Power BI Data Analyst
Listed on 2026-05-30
-
IT/Tech
Data Analyst, Business Systems/ Tech Analyst, Data Engineer, Data Science Manager
Job
Position:
Data Analyst 4
Location:
1220 Bank Street Richmond Virginia (Remote)
Client: DBHDS
Duration: 02+ Months (Possibility of Extension)
AboutThe Role
This engagement focuses on converting the Bug Track issue‑management Excel extract into a comprehensive, interactive Power BI dashboard for leadership visibility and operational decision‑making. 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, facility‑level insights, EPMO‑related tickets, and a dedicated AVATAR ticket dashboard (opened, closed, maintenance).
The consultant will build automated refresh processes, apply data‑quality 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.
- Conduct requirements workshops with the business, HIT, IT, and operational stakeholders
- Review and validate the Bug Track 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
- Requirements document and dashboard mockups
- Power BI data model and transformation scripts
- Fully developed Bug Track dashboard with leadership‑ready visuals
- Documentation for refresh processes and data definitions
- Knowledge‑transfer session with internal staff
- 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
(If this job is in fact in your jurisdiction, then you may be using a Proxy or VPN to access this site, and to progress further, you should change your connectivity to another mobile device or PC).