Apply on Employer Site

Alaffia Health · 9 hours ago

Sr. Business Intelligence Engineer

New York, New York, United States

Full-time

Hybrid

Senior Level

$140K/yr - $170K/yr

5+ years exp

Alaffia Health is a healthcare AI startup revolutionizing medical billing, analytics, and data automation. They are seeking a Senior Business Intelligence Engineer to own their reporting stack end-to-end, ensuring high-quality insights for internal teams and clients while serving as the go-to expert for Alaffia reporting.

Artificial Intelligence (AI)Health CareMachine Learning

Responsibilities

Ensure all internal and external reports are delivered on-time and with accuracy, including scheduled client deliverables and internal operational dashboards

Work closely with stakeholders to produce detailed reporting requirements, documentation, and SOPs, ensuring clarity on metric definitions and data lineage

Execute, maintain, and progressively automate manual reporting tasks, using SQL, scripting, and BI tooling to reduce operational burden

Own and enhance report-focused apps in Retool, including building new views, improving UX, and integrating with underlying data sources

Partner with data engineering to design and improve ETL/ELT workflows and data models that support scalable, performant reporting

Perform data investigations and root-cause analyses when report discrepancies, anomalies, or data quality issues occur, and drive resolution

Act as a subject matter expert on healthcare claims reporting, helping internal and external stakeholders interpret trends, metrics, and exceptions

Qualification

SQLData WarehousingETL / ELT WorkflowsExcelJavaScriptHealthcare Claims DataBusiness Intelligence EngineerClient ReportingData InvestigationsSOP Documentation

Required

Expert at writing performant SQL queries, building views, and working with large healthcare claims datasets

Strong familiarity with dimensional modeling and warehouse concepts (star/snowflake schemas, slowly changing dimensions, etc.)

Experience designing and maintaining ETL/ELT workflows that feed BI models and reports

Comfortable with advanced Excel for analysis, reconciliation, and prototyping reports when needed

Working knowledge of JavaScript to build and maintain report-focused apps in Retool or similar internal tools platforms

Demonstrated experience delivering external client custom reports, including gathering requirements, validating outputs with stakeholders, and iterating based on feedback

Hands-on work with healthcare claims data (e.g., payer claims, eligibility, provider files, remittances) and related concepts such as denials, pricing, and utilization

Proven track record as a Business Intelligence Engineer / Reporting Engineer / Analytics Engineer or similar role focused on operational and client-facing reporting