– CAREX ANALYTICS ENGINEER – HEALTHCARE TRANSACTIONS (SQL EDITION)
WITH role AS (
SELECT
'Analytics Engineer – Healthcare Transactions' AS job_title,
'Healthtech RCM Startup' AS employer,
'Investigate, diagnose, and explain anomalies across healthcare payment data' AS mission,
TRUE AS requires_advanced_sql,
TRUE AS must_love_messy_data
),
responsibilities AS (
SELECT *
FROM (
VALUES
('Investigate anomalies across claims, remittances, and EMR datasets'),
('Identify root causes of data gaps, mismatches, and odd patterns'),
('Compare current dataset pulls to historical loads for completeness'),
('Validate business logic supporting payment intelligence models'),
('Support Data Science + Client Success with accurate Insight Reports'),
('Define investigative paths without pre-written requirements'),
('Translate messy findings into clean narratives for varied audiences'),
('Recommend scalable data quality + validation improvements')
) AS r(task_description)
),
requirements AS (
SELECT *
FROM (
VALUES
('experience_years', '>= 5'),
('degree', 'Computer Science / Healthcare / related'),
('sql_skill', 'advanced'),
('database_experience', 'Snowflake or AWS preferred'),
('analysis_style', 'methodical, reasoning-based'),
('communication', 'strong_written'),
('tools', 'Microsoft Office'),
('independence', 'comfortable_in_ambiguity'),
('collaboration', 'multi-channel_communication')
) AS req(requirement, value)
),
preferred AS (
SELECT *
FROM (
VALUES
('claims_knowledge', '837/835 formats'),
('coding_systems', 'CPT, diagnoses, DRG'),
('edi_translation', 'EDI <-> proprietary systems'),
('python', 'basic for workflows'),
('tools_optional', 'GitHub, Docker, dbt')
) AS p(preferred_skill, value)
),
compensation AS (
SELECT
105000 AS min_salary,
125000 AS max_salary,
'Carex values transparency; salary depends on experience.' AS notes
)
SELECT
role.job_title,
role.employer,
role.mission,
ARRAY_AGG(DISTINCT responsibilities.task_description) AS tasks,
ARRAY_AGG(DISTINCT requirements.requirement || ': ' || requirements.value) AS must_haves,
ARRAY_AGG(DISTINCT preferred.preferred_skill || ': ' || preferred.value) AS nice_to_haves,
CONCAT('$', comp.min_salary, ' – $', comp.max_salary) AS salary_range,
comp.notes
FROM role
CROSS JOIN responsibilities
CROSS JOIN requirements
CROSS JOIN preferred
CROSS JOIN compensation AS comp
GROUP BY role.job_title, role.employer, role.mission, comp.min_salary, comp.max_salary, comp.notes;
Carex Consulting Group is an equal opportunity employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age, marital status, disability, gender identity, or Veteran status.
#LI-LL1