Data Analyst (Remote - Short Term)

Job Title:

Data Analyst (Remote - Short Term)

Location:

Richmond, VA

Duration:

3 months

Pay Rate:

$55/hr on C2C / 1099 all inclusive (OR) $50/hr on W2

Interview Process:

Web Cam Interview Only

Note:

100 % Remote but must be able to pick up equipment IN PERSON if selected.  

Pls note: This is a time sensitive role that has a tight timeline. They can choose to work full time (or part-time, 20 hrs/week) until the work is completed. If they work 40 hrs /week then the work could finish sooner and the engagement may end sooner. At this time it is slated to go to 6/30/26 (at the latest). Please confirm that you explained to your candidate that this is expected to be a SHORT TERM engagement and they understand and agreed to that arrangement if selected bf submitting them.

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 client  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

Top Skills & Years of Experience

Required/Desired Skills

Recruiter Details:

Kris : 

Lokesh : Eight three two - Nine nine zero -Two four two six

Sameer : Seven one nine – two three nine – Five five five five