ReportingMD
DESCRIPTION
The Healthcare Data Analyst will play a key role in analyzing, validating, and testing data for ReportingMD’s healthcare analytics platform. This role combines data analysis expertise with product and release testing responsibilities to ensure the accuracy, quality, and usability of our analytics products. The analyst will work closely with Product, Development, QA, and Implementation teams to mine healthcare data, validate integrations, build and test clinical quality measures, analyze and verify healthcare models such as attribution logic, HCC coding, and predictive modeling, and maintain standardized healthcare code sets. Responsibilities also include testing quality measure calculations, performing both functional and data quality testing, and supporting internal and client‑facing deliverables.
GENERAL SUMMARY OF DUTIES The Healthcare Data Analyst is responsible for collecting, analyzing, and validating healthcare data from multiple sources, including EMR extracts, payer files, and APIs. The role involves following results back to raw data to confirm accuracy, identifying discrepancies, and resolving data quality issues. This position will conduct testing of quality measure calculations against measure specifications, requiring a strong understanding of those specifications. The analyst will also work with HCC risk coding, healthcare coding, and best practices to ensure reporting accuracy.
SUMMARY OF DUTIES RESPONSIBILITIES
Perform healthcare data analysis, data profiling, and validation to support product development, client implementations, and ongoing customer needs.
Follow analytical and reporting results back to raw data sources to confirm accuracy and identify root causes of data issues.
Extract complex data from multiple data sources into usable and meaningful reports and analyses by implementing stored procedures and SQL queries including logic to support complex healthcare outcome measures.
Test business intelligence solutions on the Microsoft Business Intelligence stack (SSRS, SQL Server Database, SSIS, SSAS).
Test high‑quality automated Extract, Transformation, and Load (ETL) processes, programs, and scripts to migrate data from source systems into the Clinical Data Warehouse and Data Marts.
Create and maintain data‑dictionaries of key tables and libraries within the data‑warehouse and data marts.
Test quality measure calculations based on official measure specifications (eCQMs, CQMs, MIPS, HEDIS, etc.) and document results.
Apply knowledge of HCC risk adjustment coding, healthcare coding standards, and coding best practices to validate reporting accuracy.
Conduct product testing and release testing to ensure analytics features, reports, and dash‑boards function as intended.
Validate data quality for internal and client‑facing reporting products; identify anomalies and work with technical teams to resolve them.
Mine and transform healthcare data from multiple sources, including EMR extracts, payer claims files, APIs, and database queries.
Maintain and manage code libraries including clinical code databases, measure libraries, and model definitions.
Create and execute test cases for functional, regression, and user acceptance testing (UAT) focused on analytics and reporting features.
Collaborate with developers and analysts to troubleshoot and resolve data integration, map‑ping, and transformation issues.
Perform related work as assigned.
MINIMUM JOB REQUIREMENTS AND QUALIFICATIONS
Bachelor’s degree in Healthcare Informatics, Data Science, Computer Science, or related field; or equivalent work experience.
3+ years of experience in healthcare data analysis, data quality validation, or related health IT roles.
Hands‑on experience with healthcare data formats and standards (e.g., CPT, ICD‑10, SNOMED, HL7, QRDA, CCLF, 837/835, FHIR).
Ability to apply mathematical and statistical techniques and principles into the analysis of health‑related data, draw analytical conclusions and present findings both in oral and written format.
Proficiency in SQL for querying, validating, and transforming healthcare data.
Familiarity with EMR/EHR systems (e.g., Epic, Athena, eClinicalWorks, NextGen) and payer claims data.
Experience working with APIs and integrating healthcare data from multiple systems.
Ability to interpret and apply measure specifications to test and validate reporting logic.
Understanding of HCC risk coding and healthcare coding best practices.
Knowledge of software testing principles, including regression testing, UAT, and automated testing frameworks (preferred).
Strong analytical skills with a detail‑oriented approach to problem solving.
Excellent written and verbal communication skills.
Experience in database programming, ETL (extract‑transform‑load) processes, multitenant SaaS applications, complex SQL queries, complex stored procedures, data mining, or machine learning.
Experience in roles where multi‑level staff or client interaction is required.
Experience with Microsoft Business Intelligence stack preferred, but willing to train.
KNOWLEDGE, SKILLS AND ABILITIES REQUIRED
Strong knowledge of Data Warehouse Architectures.
Excellent interpersonal skills and strong organizational skills required, including the ability to work effectively with diverse groups.
Demonstrated ability to drive to deadlines, balancing multiple priorities, and ensuring quality standards.
Excellent analytical, problem‑solving, and innovative thinking skills.
Knowledge and understanding of HIPAA requirements, including EDI, privacy and security regulations.
Deep understanding of healthcare data sources, interoperability standards, and industry terminology.
Ability to trace results back to raw data for validation and troubleshooting.
Strong skills in SQL, relational database concepts, and data mapping.
Ability to design and execute structured test plans for analytics and reporting applications.
Knowledge of Agile and SDLC practices, including testing and release cycles.
Strong organizational and time management skills; able to handle multiple priorities and dead‑lines.
TYPICAL PHYSICAL DEMANDS Requires prolonged sitting, some bending, stooping and stretching. Requires eye – hand coordination and manual dexterity sufficient to operate a keyboard, photocopier, telephone, calculator and other office equipment. Requires normal range of hearing and eyesight to record, prepare and communicate appropriate reports. Lifting of equipment not to exceed 20 pounds.
WORKING CONDITIONS AND PHYSICAL EFFORT
Work is normally performed in the office work environment, although some virtual work is permissible.
Very limited physical effort required.
#J-18808-Ljbffr
GENERAL SUMMARY OF DUTIES The Healthcare Data Analyst is responsible for collecting, analyzing, and validating healthcare data from multiple sources, including EMR extracts, payer files, and APIs. The role involves following results back to raw data to confirm accuracy, identifying discrepancies, and resolving data quality issues. This position will conduct testing of quality measure calculations against measure specifications, requiring a strong understanding of those specifications. The analyst will also work with HCC risk coding, healthcare coding, and best practices to ensure reporting accuracy.
SUMMARY OF DUTIES RESPONSIBILITIES
Perform healthcare data analysis, data profiling, and validation to support product development, client implementations, and ongoing customer needs.
Follow analytical and reporting results back to raw data sources to confirm accuracy and identify root causes of data issues.
Extract complex data from multiple data sources into usable and meaningful reports and analyses by implementing stored procedures and SQL queries including logic to support complex healthcare outcome measures.
Test business intelligence solutions on the Microsoft Business Intelligence stack (SSRS, SQL Server Database, SSIS, SSAS).
Test high‑quality automated Extract, Transformation, and Load (ETL) processes, programs, and scripts to migrate data from source systems into the Clinical Data Warehouse and Data Marts.
Create and maintain data‑dictionaries of key tables and libraries within the data‑warehouse and data marts.
Test quality measure calculations based on official measure specifications (eCQMs, CQMs, MIPS, HEDIS, etc.) and document results.
Apply knowledge of HCC risk adjustment coding, healthcare coding standards, and coding best practices to validate reporting accuracy.
Conduct product testing and release testing to ensure analytics features, reports, and dash‑boards function as intended.
Validate data quality for internal and client‑facing reporting products; identify anomalies and work with technical teams to resolve them.
Mine and transform healthcare data from multiple sources, including EMR extracts, payer claims files, APIs, and database queries.
Maintain and manage code libraries including clinical code databases, measure libraries, and model definitions.
Create and execute test cases for functional, regression, and user acceptance testing (UAT) focused on analytics and reporting features.
Collaborate with developers and analysts to troubleshoot and resolve data integration, map‑ping, and transformation issues.
Perform related work as assigned.
MINIMUM JOB REQUIREMENTS AND QUALIFICATIONS
Bachelor’s degree in Healthcare Informatics, Data Science, Computer Science, or related field; or equivalent work experience.
3+ years of experience in healthcare data analysis, data quality validation, or related health IT roles.
Hands‑on experience with healthcare data formats and standards (e.g., CPT, ICD‑10, SNOMED, HL7, QRDA, CCLF, 837/835, FHIR).
Ability to apply mathematical and statistical techniques and principles into the analysis of health‑related data, draw analytical conclusions and present findings both in oral and written format.
Proficiency in SQL for querying, validating, and transforming healthcare data.
Familiarity with EMR/EHR systems (e.g., Epic, Athena, eClinicalWorks, NextGen) and payer claims data.
Experience working with APIs and integrating healthcare data from multiple systems.
Ability to interpret and apply measure specifications to test and validate reporting logic.
Understanding of HCC risk coding and healthcare coding best practices.
Knowledge of software testing principles, including regression testing, UAT, and automated testing frameworks (preferred).
Strong analytical skills with a detail‑oriented approach to problem solving.
Excellent written and verbal communication skills.
Experience in database programming, ETL (extract‑transform‑load) processes, multitenant SaaS applications, complex SQL queries, complex stored procedures, data mining, or machine learning.
Experience in roles where multi‑level staff or client interaction is required.
Experience with Microsoft Business Intelligence stack preferred, but willing to train.
KNOWLEDGE, SKILLS AND ABILITIES REQUIRED
Strong knowledge of Data Warehouse Architectures.
Excellent interpersonal skills and strong organizational skills required, including the ability to work effectively with diverse groups.
Demonstrated ability to drive to deadlines, balancing multiple priorities, and ensuring quality standards.
Excellent analytical, problem‑solving, and innovative thinking skills.
Knowledge and understanding of HIPAA requirements, including EDI, privacy and security regulations.
Deep understanding of healthcare data sources, interoperability standards, and industry terminology.
Ability to trace results back to raw data for validation and troubleshooting.
Strong skills in SQL, relational database concepts, and data mapping.
Ability to design and execute structured test plans for analytics and reporting applications.
Knowledge of Agile and SDLC practices, including testing and release cycles.
Strong organizational and time management skills; able to handle multiple priorities and dead‑lines.
TYPICAL PHYSICAL DEMANDS Requires prolonged sitting, some bending, stooping and stretching. Requires eye – hand coordination and manual dexterity sufficient to operate a keyboard, photocopier, telephone, calculator and other office equipment. Requires normal range of hearing and eyesight to record, prepare and communicate appropriate reports. Lifting of equipment not to exceed 20 pounds.
WORKING CONDITIONS AND PHYSICAL EFFORT
Work is normally performed in the office work environment, although some virtual work is permissible.
Very limited physical effort required.
#J-18808-Ljbffr