Medical Informatics Analyst - Business Analyst Advanced

Blue Cross Blue Shield of Michigan; Detroit (MI); On-site; USD 90,000 - 120,000; Full time

Job summary

Blue Cross Blue Shield of Michigan in Detroit seeks a data analytics professional to provide technical, data and analytical support to departments such as Quality, Value Partnerships, Hospital Contracting, Care Management, Risk Adjustment and HCV.

The role involves leading data projects, developing data-centric solutions, and collaborating with IT and Clinical Data Strategy to enhance EMR data use and reporting for major initiatives like STARS and NCQA/HEDIS.

Qualifications

• 4+ years of experience in data analytics or related field.
• Proficiency with SQL or SAS or SPSS for data projects and ad-hoc requests.
• Experience with data warehousing, ETL concepts and data modeling.

Responsibilities

• Lead or participate in data projects requiring data solutions.
• Provide programming and data expertise for moderate projects and ad-hoc requests.
• Present data findings and solutions clearly to internal/external customers.
• Support reporting activities and optimize data delivery for stakeholders.

Skills

SQL

SAS

SPSS

Databricks

Excel

PowerPoint

Visio

Access

MDX

C++

Education

Bachelor's degree in Computer Science or related field

Master's degree preferred

Tools

SQL

SAS

SPSS

Databricks

Excel

Job description

Provides technical, data and analytical support to customer departments such as Quality, Value Partnerships, Hospital Contracting, Care Management, Risk Adjustment and HCV.

ESSENTIAL DUTIES AND RESPONSIBILITIES

Other duties may be assigned.

• Leads or participates, with some direction, in projects where data solutions are necessary.
• Provides programming and data expertise for simple and moderately complex projects and ad-hoc requests.
• Presents data and solutions to internal and/or external customers in a logical way.
• Provides data support and analysis for programs supporting over 4 million BCBSM beneficiaries using administrative claims and supplemental data.
• Provides analysis and data support for various corporate departments including Quality, Risk Adjustment, Value Partnership, Care Management, and Hospital Contracting, in support of major corporate initiatives such as EMR Connectivity, PGIP, Risk Adjustment, STARS and NCQA/HEDIS.
• Standardizes, harmonizes, cleans and shares data with others in the organization as well as external customers.
• Creates and maintains data-centric product solutions, including third party program integrations such as, HEDIS, risk scores and PGIP incentives.
• Supports various reporting activities and continuously strives to make them more efficient and easier for the customers to consume.
• Completes ad-hoc data and analytic requests assigned.
• Works with IT and Clinical Data Strategy to maintain and enhance our EMR Clinical Data in the Informatics environment.

Qualifications

• Bachelors Degree in Computer Science, Information Systems, Business, Mathematics, Healthcare Information Technology or similar degree required.
• Master's Degree preferred.
• Minimum 4 years of experience.
• Ability to use advanced functions in SQL or SAS or SPSS programming.
• Solid working knowledge of Microsoft tools and software (i.e., Excel, Visio, Access, PowerPoint).
• Competency in programming concepts such as Visual Basic, Business Objects, .Net, MDX, C++, or COBOL.
• Must possess the ability to help others think critically and share complex technical solutions to non-technical audiences both orally and in writing.
• Must be able to translate thoughts and ideas from non-data customers into data-centric solutions.
• Knowledge of data warehousing and data mining concepts including but not limited to ETL, datamart design, fact tables, dimension tables, data views within data marts/data warehouses, olap, rolap, and data models such as star schemas and snowflake schemas.
• Ability to recognize data patterns, quantify potential issues and identify solutions.
• Ability to standardize, harmonize, clean, prepare and use data for developing datasets, reporting and analysis.
• Basic understanding of epidemiologic principals and population health management concepts desirable.
• Knowledge of healthcare terminology, plan/benefit design, fundamental operational principles and administrative claims data including standard coding schemes such as ICD-9/10 and HCPCS.

Departmental Preferences

• Experience working with EMR/EHR clinical data, including encounters, diagnoses, procedures, medications, labs, vitals, immunizations, and clinical documents.
• Strong analytical skills with experience using Databricks, SQL and data analysis tools to investigate, validate, and reconcile large clinical datasets.
• Experience with EMR platforms CCDA data such as Epic, Oracle Health/Cerner, athenahealth, eClinicalWorks.
• Knowledge of C-CDA documents, including clinical data extraction, mapping, transformation, validation, and downstream processing.
• Experience developing and maintaining data mappings and performing data quality, reconciliation, and root cause analysis for clinical data integrations.
• Ability to independently execute EMR operational activities, including project planning, status tracking, issue resolution, stakeholder communication, and process improvement initiatives.
• Experience collaborating with business and clinical stakeholders to identify opportunities for new HEDIS measures, quality programs, and clinical data acquisition efforts.
• Familiarity with cloud-based data platforms and healthcare interoperability standards (e.g., HL7, CCDA, FHIR), with the ability to analyze EMR/ADT data and develop meaningful reporting and insights.

All qualified applicants will receive consideration for employment without regard to, among other grounds, race, color, religion, sex, national origin, sexual orientation, age, gender identity, protected veteran status or status as an individual with a disability.