Others, Ontario
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.
Solid 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

#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-#body.unify div.unify-button-container .unify-apply-now: focus, #body.unify div.unify-button-container .unify-apply-

📌 Python Senior Technical Lead - Data Analysis, SQL (Canada)
🏢 HCLTech
📍 Canada