Power BI- Data Analyst

About the role

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).

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
• Deliverables include 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, and knowledge-transfer session with internal staff
• Milestones include requirements gathering & data review (Week 1-3), data modeling & initial dashboard build (Week 4-8), stakeholder review & refinement (Week 9-10), and final dashboard delivery & documentation (Week 11-12)

Requirements

Knowledge of Power BI, SQL, and data modeling skills.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, or a related field
• At least 5 years of experience in data analysis and dashboard development
• Experience with Power BI, SQL, and data modeling
• Strong analytical and problem-solving skills
• Excellent communication and collaboration skills
• Ability to work independently and manage multiple tasks simultaneously

Skills

• Data analysis
• Power BI
• SQL
• Data modeling
• Visualizations
• Collaboration

Benefits

Flexible schedule options (full-time or part-time, 20 hours/week) until the work is completed.

Pay

Competitive hourly rate based on experience and qualifications.

Schedule

Remote work option available.