Data Analyst 4 (Remote) Job at Serigor Inc., Richmond, VA

SHBDclNPWVJMOUxuQ0tUZG5Eclk4eWRkZVE9PQ==
  • Serigor Inc.
  • Richmond, VA

Job Description

Job Title: Data Analyst 4 (Remote)

Location: Richmond, VA

Duration: 02 Months Possibility of Extension

Job Description:

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 clients as it arises if time in 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, 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 client 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

Skills:

Skills

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

Job Tags

Remote work

Similar Jobs

Social Factor

French Language Social Media Community Moderator - Remote Global Job at Social Factor

 ...Social Factor is looking for remote, French Language Social Media Community Moderator. The Language Community Moderator will be responsible for the review, removal and escalation of inappropriate content on assigned projects across social media platforms. The Language... 

Ikon Solutions Asia Inc.

Staff Nurse Job at Ikon Solutions Asia Inc.

 ...required specialty areas :- North Dakota- Ohio - Arkansas, Louisiana, and Alabama - NCLEX, IELTS, CGFNS, and US Visa Screen sponsorship - Direct hire -Hospital setting; other settings/facilities are also available depending on your specialty area -... 

Care Access

Clinical Research Assistant Job at Care Access

 ...the future of health better for all. With hundreds of research locations, mobile clinics, and clinicians across the globe, we bring world-class research...  ...This Role Makes a Difference The Clinical Research Assistant is an entry level clinical position and is designed to... 

University of Florida

Education Library - Federal Work Study Library Student Assistant Job at University of Florida

Classification Title:Education Library - Federal Work Study Library Student AssistantClassification Minimum Requirements: Federal Work-Study Program Good communication skills Detail-oriented Works well with the public Capable of working independently...

American Income Life Insurance Company

Benefits Specialist (Remote Work) Job at American Income Life Insurance Company

 ...international insurance organization dedicated to supporting working families across the United States, Canada, and New...  ...program Fully remote position (work from home) Competitive pay structure Weekly pay with performance bonuses Opportunities for advancement...