Founding Business Intelligence Engineer
Leads data strategy for a healthcare claims recovery platform, owning data quality, BI dashboards, and commercial insights to drive financial decisions using Databricks, Postgres, and Sigma.
- Compensation
- Not disclosed
- Location
- United States
- Work setup
- Remote
- Seniority
- Not specified
- Employment
- Not specified
- Experience
- 5+ years
- Category
- Data analytics
- Posted
Skills
Must have
- 5+ years of hands-on experience in BI engineering, analytics engineering, data analytics, or a similarly technical role.
- Advanced SQL skills, including complex joins, CTEs, window functions, query optimization, and debugging across large or complicated datasets.
- Proven experience personally building and maintaining production dashboards, reporting datasets, and reusable analytical models.
- Experience with modern analytical platforms such as Databricks, Snowflake, BigQuery, or Redshift, and BI tools such as Sigma, Looker, Tableau.
- Strong understanding of relational data modeling, analytical transformations, metric definitions, data quality, and reconciliation.
- Demonstrated ability to independently reverse-engineer unfamiliar datasets and understand relationships across multiple systems.
- Experience working directly with business stakeholders to understand ambiguous requirements, investigate problems, and deliver useful analytical solutions.
- Ability to connect operational metrics to business outcomes and identify insights beyond the immediate reporting request.
- Comfortable being the primary hands-on BI contributor, owning implementation and ongoing maintenance without a team beneath you.
- Strong attention to detail, intellectual curiosity, and a high bar for correctness.
Nice to have
- Experience building BI or analytics capabilities from scratch in an early-stage or rapidly growing company.
- Experience in operationally intensive businesses such as insurance, fintech, logistics, healthcare operations, or claims processing.
- Hands-on experience with Databricks, Postgres.
- Experience with dbt, Git-based workflows, automated data tests, or similar analytics engineering practices.
- Experience analyzing operational funnels, productivity, unit economics, financial reconciliation, or automation performance.
- Familiarity with data that changes over time, including event histories, workflow transitions, and financial outcomes that require reconciliation across systems.
Full description
About the Company
The Public Interest Company provides a comprehensive solution for identifying and recovering third party liability for health plans, risk-bearing provider groups, and self-funded employers. We combine AI and a legal tech platform to identify and recover claims that should have been paid by third party payers. We handle the entire recovery process, all while protecting members and streamlining operations. We empower healthcare organizations to maximize their financial performance and recoup dollars towards care delivery, without adding administrative burden.
**Role Overview
**Our business runs on data. Recovery performance, operational throughput, client reporting, and financial results are deeply interconnected, and we need someone who can turn that complexity into reliable, actionable information.
We're looking for a founding, hands-on BI engineer to build and own TPIC's business intelligence foundation. You'll work directly with raw data in Databricks and Postgres, develop analytical models, write complex SQL, build dashboards and reporting, and establish the definitions and quality standards that make our data trustworthy.
This is not a request-taking dashboard role, nor is it a position where you manage others to do the technical work. You'll personally build the tools and analytical foundations the business depends on, while developing a deep understanding of how our operational workflows translate into recovery and financial outcomes.
The right person combines strong technical execution with curiosity and business judgment. You'll work directly with operations, finance, litigation, and engineering to understand the question behind a request, investigate discrepancies, and identify insights that improve business performance. You should be comfortable working independently in an environment where data is imperfect, requirements are ambiguous, and the right solution often needs to be discovered rather than specified.
This is a founding individual contributor role with end-to-end ownership of BI. You'll establish the technical and analytical foundation that scales as TPIC grows.
Responsibilities
Hands-On BI Engineering & Analytics
- Design, build, and maintain dashboards, reports, and analytical tools used across operations, finance, litigation, and client-facing workflows.
- Write and optimize complex SQL to analyze large datasets, reconcile data across systems, and solve ambiguous business questions.
- Build and maintain reusable analytical data models, transformations, and metric definitions on top of data in Databricks, Postgres, and other source systems.
- Develop reliable reporting datasets and semantic definitions that support consistent metrics across dashboards, analysis, and client deliverables.