Sr. Business Intelligence Engineer

Job type: Full Time · Department: EPD · Work type: Hybrid · USD 140000 -170000 / year New York, New York, United States About Alaffia & Our Mission Each year, the U.S. healthcare system suffers from over $500B in wasted spending due to medical billing fraud, waste, and administrative burden. At Alaffia, we're committed to changing that paradigm. We've assembled a team of clinicians, AI engineers, and product experts to build advanced AI solutions that will directly bend the cost curve for all patients across the healthcare ecosystem. Collectively, we're building best-in-class AI software to provide our customers with co-pilot tools, AI agents, and other cutting-edge solutions to reduce administrative burden and reduce healthcare costs. We're a high-growth, venture-backed startup based in NYC and are actively scaling our company. About the Role & What You'll Be Doing Alaffia Health is a healthcare AI startup revolutionizing medical billing, analytics, and data automation. As we scale, we are seeking a Senior Business Intelligence Engineer to own our reporting stack end-to-end, ensure high-quality insights for both internal teams and clients, and serve as the go-to expert for Alaffia reporting. In this role, you will: Own the reporting lifecycle for internal and external stakeholders, ensuring all reports and dashboards are delivered on time, with high accuracy, and clear documentation . Partner with product, operations, business, and engineering teams to define reporting requirements, translate business questions into well-specified data models and metrics, and build robust reporting solutions. Design and maintain BI data models and semantic layers that power dashboards, scheduled reports, and ad-hoc analysis on all operational data. Develop and maintain report-focused internal tools and apps in Retool , enabling self-service analytics and operational workflows for non-technical users. Execute and automate manual reporting workflows , gradually replacing one-off or spreadsheet-heavy processes with repeatable, well-tested ETL/ELT pipelines. Establish and maintain reporting SOPs and documentation , including data dictionaries, metric definitions, and runbooks for recurring reports. Drive data quality and consistency across reports by implementing validation checks, reconciliation processes, and clear definitions for key business metrics. Support external client reporting needs , including custom report builds, one-off analyses, and investigations into anomalies or unexpected trends. You'll be a key partner in turning raw healthcare claims and operational data into trusted, actionable insights for our customers and internal teams. Your 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. What We're Looking For Technical Skills (core) SQL – Expert at writing performant queries, building views, and working with large healthcare claims datasets. Data Warehousing – Strong familiarity with dimensional modeling and warehouse concepts (star/snowflake schemas, slowly changing dimensions, etc.). ETL / ELT Workflows – Experience designing and maintaining data pipelines that feed BI models and reports. Excel – Comfortable with advanced Excel for analysis, reconciliation, and prototyping reports when needed. Technical Skills (Bonus) Experience with modern BI tools (e.g., Looker, Mode, Tableau, Metabase, or similar). Familiarity with dbt or similar transformation frameworks. Experience with scheduling/orchestration tools (e.g., Airflow, Dagster, Prefect). Experience (Core) 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. Experience (Bonus) Experience working in a startup or high-growth environment, comfortable with ambiguity and evolving requirements. Prior work at a payer, health tech company, or healthcare analytics vendor . Exposure to EDI formats (e.g., X12 837/835) or other healthcare data standards. 5–10+ years in data engineering, with at least 3–5 years handling healthcare data, particularly. Our Culture At Alaffia, we fundamentally believe that the whole is more valuable than the sum of its individual parts. Further to that point, we believe a diverse team of individuals with various backgrounds, ideologies, and types of training generates the most value. Our people are entrepreneurial by nature, problem solvers, and are passionate about what they do — both inside and outside of the office. Alaffia Health is a Government contractor subject to the Section 4212 of the Vietnam Era Veterans's Readjustment Assistance Act of 1974, as amended by the Jobs for Veterans Act of 2002, which requires Government contractors to take affirmative action to employ and advance in employment: (1) Disabled veterans – A veteran who served on active duty in the U.S. military and is entitled to disability compensation (or but for the receipt of military retired pay would be entitled to disability compensation) under laws administered by the Secretary of Veterans Affairs, (2) Recently separated veteran – A veteran separated during the three-year period beginning on the date of the veteran's discharge or release from active duty in the U.S. military ground, naval, or air service, (3) Active duty wartime or campaign badge veteran – A veteran who served on active duty in the U.S. military during a war, or in a campaign or expedition for which a campaign badge was authorized under the laws administered by the Department of Defense, (4) Armed forces service medal veteran – A veteran who, while serving on active duty in the U.S. military ground, naval, or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985 (61 Fed. Reg. 1209). If you believe that you belong to any of the categories of protected veterans, please indicate by making the appropriate selection. Alaffia Health does not discriminate on the basis of race, sex, color, religion, age, national origin, marital status, disability, veteran status, genetic information, sexual orientation, gender identity or any other reason prohibited by law in provision of employment opportunities and benefits. J-18808-Ljbffr