Job Summary
Data Analyst – Revenue Cycle Management (RCM)
Job Title
Data Analyst – RCM Data Mapping & Semantic Layer Development
Job Summary
We are seeking a highly analytical and detail-oriented Data Analyst with experience in Revenue Cycle Management (RCM) and healthcare data. The candidate will be responsible for analyzing source data in Google BigQuery, performing data profiling and mapping activities, translating source data into the IBM Unified Data Model for Healthcare (UDMH), and supporting the design and development of a business-friendly Semantic Layer for reporting and analytics.
The role requires close collaboration with business stakeholders, data architects, data engineers, and reporting teams to ensure accurate data transformation, standardization, and accessibility across RCM domains.
Key Responsibilities
Source Data Analysis & Profiling
- Analyze and understand healthcare and RCM data stored in BigQuery source tables.
- Perform data profiling, data quality assessments, and completeness checks on source datasets.
- Identify relationships, dependencies, and business rules within source systems.
- Document source-to-target data transformations, calculations, and derivation logic.
Data Mapping & UDMH Alignment
- Map source system data elements to the IBM Unified Data Model for Healthcare (UDMH).
- Develop and maintain detailed source-to-target mapping documents.
- Collaborate with Data Architects to ensure adherence to UDMH standards and modeling guidelines.
- Identify data gaps, inconsistencies, and mapping challenges, and propose remediation approaches.
- Validate mappings with business stakeholders and subject matter experts.
Semantic Layer Development
- Assist in designing and developing enterprise semantic models for reporting and analytics.
- Define business-friendly metrics, dimensions, hierarchies, and KPIs within the semantic layer.
- Translate complex healthcare and RCM data structures into consumable datasets for business users.
- Work with reporting and analytics teams to ensure consistency of calculations and metric definitions.
- Support semantic layer testing, validation, and optimization.
Business & Stakeholder Collaboration
- Facilitate discussions with RCM business teams to understand reporting and analytical requirements.
- Gather and document business definitions, data requirements, and KPI specifications.
- Support data governance and metadata management initiatives.
- Provide functional guidance during data validation and user acceptance testing activities.
Data Quality & Validation
- Perform reconciliation between source systems, UDMH structures, and reporting layers.
- Validate transformed data and business rules to ensure accuracy and integrity.
Support defect analysis and resolution during development and testing cycles
Skill Requirements
Required Qualifications
- Bachelor's degree in Computer Science, Information Systems, Healthcare Informatics, Data Analytics, or related field.
- 5+ years of experience in Data Analytics, Data Warehousing, or Healthcare Data Management.
- Strong understanding of Revenue Cycle Management (RCM) processes including Patient Access, Scheduling, Registration, Claims, Billing, Payments, Denials, and Collections.
- Hands-on experience with Google BigQuery and SQL.
- Experience performing source-to-target mapping and data profiling activities.
- Understanding of dimensional modeling, data warehousing, and semantic data models.
- Excellent analytical, documentation, and problem-solving skills.
- Strong stakeholder communication and requirements gathering experience.
Preferred Qualifications
- Experience with IBM Unified Data Model for Healthcare (UDMH).
- Experience in healthcare provider data and analytics environments.
- Familiarity with semantic layer technologies such as Power BI Semantic Models, Looker, Tableau, Cognos, or similar platforms.
- Knowledge of healthcare data standards and healthcare business domains.
Experience with cloud-based data platforms and modern analytics architectures
Other Requirements
ey Deliverables
- Source System Data Assessment Documents
- Data Profiling Reports
- Source-to-UDMH Mapping Specifications
- Business Rules Documentation
- Semantic Layer Design Artifacts
- KPI and Metric Definitions
- Data Validation and Reconciliation Reports
Required Skills
- Revenue Cycle Management (RCM)
- BigQuery SQL
- Data Mapping & Data Profiling
- IBM UDMH
- Healthcare Data Analytics
- Data Warehousing
- Semantic Layer Modeling
- Data Quality Analysis
- Requirements Gathering
- Documentation & Stakeholder Communication
Location: Remote
Experience: 5–8+ Years
Industry: Healthcare Provider / Revenue Cycle Management (RCM) Analytics