Power BI Data Analyst (3 months ONLY)

InnoSoul • Richmond, VA

4d • Remote

About The Position

This engagement focuses on converting the BugTrack 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 in needed.

Requirements

• Power BI & Data Modeling Expertise
• Analytics & Data Interpretation
• Stakeholder Engagement & Requirements Gathering
• Technical & Tooling Skills
• Training & Knowledge Transfer
• Project & Delivery Skills

Nice To Haves

• Experience with EHR systems (Cerner/Oracle Millennium, AVATAR)
• Background in operational reporting
• IT service management analytics

Responsibilities

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed