Senior Data Analyst

We're seeking a Senior Data Analyst to join our Data Engineering team who brings three things together: deep healthcare domain expertise that lets you engage health plan clients directly on payment and process questions; the ability to quickly learn and work across Machinify's internal products — from data ingestion through claims adjudication; and a drive to develop and build AI-driven workflows that continuously raise the bar on what our analyst function can do. This is not a pure back-office role — you'll be the bridge between client needs, internal product knowledge, and data-driven outcomes. 

What You’ll Do

• Collaborate with clients and internal stakeholders to understand payment integrity requirements, document process flows, and integrate analytical outputs with client workflows and downstream adjudication systems 
• Develop deep understanding of Machinify's internal processes and how they integrate together — from data ingestion through claims adjudication — ensuring analytical solutions are accurate, traceable, and aligned with business needs 
• Actively drive AI adoption: prompt and iterate with LLMs to accelerate analysis, identify processes where AI can replace manual workflows, and contribute to AI-assisted pipeline development 
• Write and maintain complex analytical SQL against large-scale claims datasets: window functions, CTEs, multi-table joins, query optimization, and production-quality logic that runs reliably at scale 
• Identify and build AI-driven automation workflows that replace or accelerate manual analytical processes — moving from one-off prompts to repeatable, team-shareable tooling 
• Design and implement data transformations that convert raw medical and institutional claims into canonical models, applying healthcare coding standards (ICD-10, CPT, HCPCS, UB-04, CMS-1500) throughout 
• Drive payment integrity analysis — identify overpayment patterns, coordination of benefits issues, and billing edit opportunities by applying deep knowledge of payer policy, CMS regulations, and provider reimbursement methodologies 
• Conduct data quality audits and build monitoring frameworks that surface anomalies before they reach production 
• Support onboarding of new client data feeds, ensuring smooth integration with minimal disruption 
• Partner with engineers, clinical staff, and product managers to translate complex healthcare requirements into data solutions 
• Mentor analysts and engineers on healthcare domain questions — serving as the go-to SME on coding, claims adjudication, and payer policy 
• Document transformation logic, data lineage, and analytical methodologies to support knowledge transfer and audit readiness 

What You Bring 

• 5+ years of data analysis experience and working directly with healthcare claims data 
• Deep knowledge of medical claim types (professional and institutional), coding systems (ICD-10-CM/PCS, CPT, HCPCS), and standard form formats (UB-04, CMS-1500)
• Demonstrated experience using LLMs or AI tools to accelerate analytical work — not as a novelty, but as a repeatable part of your workflow 
• Expert-level SQL: complex analytical queries, window functions, CTEs, performance tuning against datasets of hundreds of millions of rows 
• Hands-on payment integrity experience: overpayment detection, COB, billing edits, or claim editing logic 
• Familiarity with CMS regulations and commercial payer guidelines as they apply to claims adjudication and payment policy 
• Strong communicator — able to discuss healthcare process and payment logic directly with health plan clients and non-technical stakeholders 
• Ability to translate ambiguous business and clinical requirements into precise, well-documented data logic 
• Working knowledge of provider reimbursement methodologies — MS-DRG/APR-DRG pricing, fee schedules, per diem, and capitation 
• Proficiency with Spark SQL or a comparable distributed query engine — writing and optimizing queries against large-scale data environments is a daily expectation 
• Experience with Databricks or a cloud data lakehouse (Delta Lake, Snowflake, BigQuery) 
• Background in ETL/ELT pipeline development or close collaboration with data engineers on pipeline design 
• Exposure to value-based care arrangements or risk adjustment (HCC coding, RADV) 
• Prior experience at a health plan, payment integrity vendor, or healthcare analytics firm  

What We Offer  

• Work from anywhere in the US! Machinify is digital-first.  
• Full Medical/Dental/Vision for employees & their families  
• Flexible and trusting environment where you’ll feel empowered to do your best work  
• Unlimited FTO  
• Competitive salary, equity, 401(k) including employer match  

The salary for this position is based on an array of factors unique to each candidate: Such as years and depth of experience, set skills, certifications, etc. The base salary range for this role is $140,000-$170,000. We are hiring for different levels, and our Recruiting team will let you know if you qualify for a different role/range. Salary is one component of the total compensation package, which includes meaningful equity, excellent healthcare, flexible time off, and other benefits and perks.