Reveleer logo
Reveleer
Posted 16 days agoVerified live 13h ago

Data Integration Analyst, AI & Risk Adjustment

Brief overview

Remote
UndergradOr in progress
3+ yrsMinimum
SQL Server / T-SQLRelational DatabasesData TransformationData Cleaning, Mapping, and ValidationETL and Data IngestionAlgorithm DesignPythonSQL Server Integration Services (SSIS)Healthcare Risk Adjustment

About the company

Reveleer logo
Reveleerreveleer.com

Provides software and services for healthcare value-based care.

Job description

Summary

Reveleer delivers a unified platform for risk adjustment, quality improvement, clinical intelligence, and member management in value-based care. The Data Integration Analyst will build data ingestion and transformation pipelines, develop risk adjustment and condition-suspecting data products, and structure healthcare data for analytics and AI applications.

Responsibilities

  • Serve as the technical point of contact for receiving customer data (health plans) in whatever format they already use, member, provider, clinic location, chart-retrieval detail, claims, and other source data, rather than requiring them to conform to ours
  • Ingest source data as-is into our SQL Server data warehouse, preserving raw data for traceability, and build scalable, repeatable ingestion routines that handle varied and often messy structures and file types
  • Write and maintain SQL to transform raw source data into accurate, platform-ready outputs, including load files for the Reveleer medical record retrieval platform
  • Monitor pipelines for errors, anomalies, and data quality issues, and remediate them before they affect downstream work
  • Build and maintain the data foundations that support retrospective risk adjustment coding workflows
  • Develop, test, and refine condition-suspecting algorithms that surface likely undocumented or under-documented diagnoses from the underlying data
  • Partner with coding, clinical, and analytics teams to translate domain logic into reliable, production-grade data products
  • Design and build semantic data structures that make our underlying healthcare data materially more accessible and useful to AI tools
  • As an early priority, take ownership of a significant library of semantic analytics tables currently maintained in our development environment: refactor and clean up the code, migrate it into production, and stand up automated, scheduled refreshes
  • Establish durable, repeatable standards for promoting code from development to production and for turning massive, raw healthcare data into well-structured, reusable datasets that downstream analytics and AI can leverage
  • Document data models, transformation logic, algorithms, and source-specific rules to build institutional knowledge and reduce rework
  • Partner closely with the Data Management, analytics, and platform teams to ensure smooth handoffs and dependable production systems
  • Work with the VP of Data Strategy and cross-functional partners to continuously improve how raw healthcare data becomes structured, AI-ready assets

Skills

  • • Bachelor's degree in a quantitative, scientific, technical, or related field, or equivalent hands-on experience
  • • Proven, hands-on coding ability and demonstrable experience working with database technology
  • • Demonstrated ability to design creative, original solutions to parse, structure, and make sense of complex, messy, or unfamiliar data
  • • Comfort designing, testing, and refining algorithms or analytical logic against real-world data
  • • Experience cleaning, mapping, and validating real-world data from multiple sources and file formats into a required structure
  • • Experience building repeatable, maintainable ETL or data-ingestion workflows
  • • Strong attention to detail and a structured, methodical approach to data quality and validation
  • • Clear written and verbal communication skills, including the ability to work directly with customers and internal teams
  • • Self-starter who takes ownership end-to-end and thrives with autonomy
  • • Experience in health insurance or another healthcare-related field is ideal but not required, strong candidates without healthcare experience are encouraged to apply
  • • Graduate study or research experience in a quantitative or scientific discipline
  • • Familiarity with SQL Server Integration Services (SSIS) or comparable ETL tooling
  • • Exposure to Python for data manipulation and automation
  • Understanding risk adjustment (including retrospective risk adjustment coding, HCCs, or condition suspecting), medical record retrieval, or value-based care operations
  • • Exposure to preparing, structuring, or engineering data for AI/ML tools and workflows
  • • Experience supporting customer onboarding or client data implementations

Qualifications

Must Haves

  • • Bachelor's degree in a quantitative, scientific, technical, or related field, or equivalent hands-on experience
  • • Proven, hands-on coding ability and demonstrable experience working with database technology
  • • Demonstrated ability to design creative, original solutions to parse, structure, and make sense of complex, messy, or unfamiliar data
  • • Comfort designing, testing, and refining algorithms or analytical logic against real-world data
  • • Experience cleaning, mapping, and validating real-world data from multiple sources and file formats into a required structure
  • • Experience building repeatable, maintainable ETL or data-ingestion workflows
  • • Strong attention to detail and a structured, methodical approach to data quality and validation
  • • Clear written and verbal communication skills, including the ability to work directly with customers and internal teams
  • • Self-starter who takes ownership end-to-end and thrives with autonomy

Nice to Haves

  • • Experience in health insurance or another healthcare-related field is ideal but not required, strong candidates without healthcare experience are encouraged to apply
  • • Graduate study or research experience in a quantitative or scientific discipline
  • • Familiarity with SQL Server Integration Services (SSIS) or comparable ETL tooling
  • • Exposure to Python for data manipulation and automation
  • Understanding risk adjustment (including retrospective risk adjustment coding, HCCs, or condition suspecting), medical record retrieval, or value-based care operations
  • • Exposure to preparing, structuring, or engineering data for AI/ML tools and workflows
  • • Experience supporting customer onboarding or client data implementations

Benefits

  • Remote opportunity
  • Medical, Dental and Vision benefits
  • 401k match
  • Generous PTO plan

More jobs like this