Data Analyst

Mbi Llc; Richmond (VA); On-site; USD 80,000 - 120,000; Full time

Job summary

A consulting company in healthcare analytics is seeking a professional to develop a Power BI dashboard aimed at identifying and remediating duplicate patient encounters. The role requires expertise in Power BI, strong stakeholder engagement skills, and the ability to analyze and visualize large datasets. The consultant will collaborate with clinical operations and data governance teams to improve data quality and streamline operational processes. Experience with EHR systems is a plus, along with a background in reporting and analytics.

Qualifications

• Expertise in Power BI data modeling and analytics required.
• Strong stakeholder engagement and requirement gathering experience necessary.
• Ability to interpret and translate complex data extracts expected.

Responsibilities

• Conduct requirements sessions with HIM, data governance, and operations.
• Analyze the structure and quality of duplicate-encounter extract.
• Build a Power BI data model capable of handling large datasets.
• Develop visualizations for duplicate patterns and severity indicators.
• Create data dictionary and process documentation.

Skills

Power BI & Data Modeling Expertise

Analytics & Data Interpretation

Stakeholder Engagement & Requirements Gathering

Ability to translate extracts and data

Technical & Tooling Skills

Training & Knowledge Transfer

Project & Delivery Skills

Background in operational reporting or IT service management analytics

Job description

Overview

The engagement aims to transform a large Excel extract of potential duplicate patient encounters into a structured, interactive Power BI dashboard that supports data‑quality improvement and operational cleanup. The consultant will work with HIM, data governance, and clinical operations teams to define the criteria and visualizations needed to surface duplicate patterns, encounter clusters, and high‑risk records. The dashboard will help teams quickly identify duplicates, understand root causes, and prioritize remediation efforts. The resource may also be engaged in other Power BI work related to DBHDS as time allows.

Key Tasks

• Conduct requirements sessions with HIM, data governance, and operations
• Analyze the structure and quality of the duplicate‑encounter extract
• Build a Power BI data model capable of handling large datasets
• Develop visualizations for duplicate patterns, encounter groupings, frequency, and severity indicators
• Create filters for facility, date ranges, encounter type, and risk level
• Implement automated refresh and validation logic
• Iterate with stakeholders to refine insights and usability
• Produce requirements document and dashboard wireframes
• Develop Power BI data model and transformation logic
• Create data dictionary and process documentation
• Conduct knowledge‑transfer session with internal staff

Milestones

• Week 1‑3: Requirements gathering & data review

Required Skills

• Power BI & Data Modeling Expertise
• Analytics & Data Interpretation
• Stakeholder Engagement & Requirements Gathering
• Ability to translate extracts and data
• Technical & Tooling Skills
• Training & Knowledge Transfer
• Project & Delivery Skills
• Background in operational reporting or IT service management analytics

Nice to Have

• Experience with EHR systems (Cerner/Oracle Millennium, AVATAR)