Back to jobs

Founding Business Intelligence Engineer

Pay
Pay not listedSimilar roles state $95K–$145K
Work setting
Remote — work setting source
Location type: Remote
From the employer’s posting
Employment
Full-time — employment source
Employment type: Full-time
From the employer’s posting
Team
Operations — team source
Department: Operations
From the employer’s posting

What you’ll work on

Full posting
  • Design, build, and maintain dashboards, reports, and analytical tools used across operations, finance, litigation, and client-facing workflows.

  • Develop a deep understanding of TPIC's recovery lifecycle, from incident identification and validation through pursuit, recovery, and financial reconciliation.

  • Own the BI function end to end, from understanding requirements and exploring source data to building, validating, deploying, and maintaining analytical solutions.

From the employer’s posting
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.
Business & Operational Analytics Develop a deep understanding of TPIC's recovery lifecycle, from incident identification and validation through pursuit, recovery, and financial reconciliation. Build analytics that track recovery performance, case throughput, processing efficiency, operational bottlenecks, and unit economics.
Foundational Ownership & Scalability Own the BI function end to end, from understanding requirements and exploring source data to building, validating, deploying, and maintaining analytical solutions. Prioritize BI work based on business impact, balancing immediate reporting needs with building reusable foundations.

Before you apply

Sponsorship
Visa sponsorship not confirmed — sponsorship source
Will you now or in the future require visa sponsorship to continue working in the United States?
From the employer’s application form

What you’ll bring

All qualifications

Core experience

  • 5+ years of hands-on experience in BI engineering, analytics engineering, data analytics, or a similarly technical role.
  • Experience building BI or analytics capabilities from scratch in an early-stage or rapidly growing company.
  • Proven experience personally building and maintaining production dashboards, reporting datasets, and reusable analytical models.
  • Experience in operationally intensive businesses such as insurance, fintech, logistics, healthcare operations, or claims processing.
  • Experience with modern analytical platforms such as Databricks, Snowflake, BigQuery, or Redshift, and BI tools such as Sigma, Looker, Tableau.
  • Hands-on experience with Databricks, Postgres.
Qualification wording
5+ years of hands-on experience in BI engineering, analytics engineering, data analytics, or a similarly technical role.
Experience building BI or analytics capabilities from scratch in an early-stage or rapidly growing company.
Proven experience personally building and maintaining production dashboards, reporting datasets, and reusable analytical models.
Experience in operationally intensive businesses such as insurance, fintech, logistics, healthcare operations, or claims processing.
Experience with modern analytical platforms such as Databricks, Snowflake, BigQuery, or Redshift, and BI tools such as Sigma, Looker, Tableau.
Hands-on experience with Databricks, Postgres.

About The Public Interest 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.

In the employer’s words · Read in context · Company website ↗

Posting record

Report an error

Open 4 monthsWe first saw this posting 126 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.

Status in our records
Live
First seen by us
Jul 18, 2026126 days ago
Recorded sightings
63
Last seen by us
Nov 21, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$95K–$145K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 2,327 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 126

Up longer than most. Similar jobs usually come down between day 5 and day 43.

From 16,008 similar postings that came down. Coming down is not always a hire.

The Public Interest Company is hiring

1 open job

  • No new data jobs since July
Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • SQL
  • BigQuery
  • Databricks
  • dbt
  • Looker
  • Redshift
  • Sigma
  • Snowflake
  • Tableau
  • PostgreSQL
Where the posting names them
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.
- 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.
- 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.
- Reliable BI foundation: Core business metrics are clearly defined, validated, and consistently used across internal and client-facing reporting. - Hands-on delivery: You independently build and maintain the SQL models, dashboards, and reporting tools the business needs. - Operational visibility: Business teams can understand recovery performance, case throughput, bottlenecks, and operational efficiency without relying on fragmented or manually assembled data.
- 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.
- 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.
- 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.
- 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.

Your next step

Complete your application on jobs.ashbyhq.com. The employer’s form will show what is required.

Applying through Ashby

  • No account needed. “Autofill from resume” at the top of the form fills the key fields from your file.

Already applied? Track this application

Job description

View original posting ↗

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.

  • Independently investigate data discrepancies, trace issues to underlying sources, and work with engineering to resolve root causes.

  • Improve the performance, reliability, and maintainability of BI queries, models, and reporting workflows.

Business & Operational Analytics

  • Develop a deep understanding of TPIC's recovery lifecycle, from incident identification and validation through pursuit, recovery, and financial reconciliation.

  • Build analytics that track recovery performance, case throughput, processing efficiency, operational bottlenecks, and unit economics.

  • Partner with business stakeholders to understand operational questions, translate them into analytical requirements, and deliver solutions that enable better decisions.

  • Proactively investigate performance changes, identify root causes, and surface opportunities to improve recovery outcomes and operational efficiency.

  • Develop measurement frameworks for operational changes and automation initiatives, helping teams determine whether improvements are delivering the expected impact.

  • Go beyond presenting metrics to explain what they mean, why they changed, and where the business should investigate or act.

Data Understanding, Quality & Governance

  • Build and maintain a comprehensive understanding of the business's analytical data landscape, including source tables, entity relationships, workflow states, and data lineage.

  • Establish and maintain consistent definitions for business-critical metrics across operational, financial, and client reporting.

  • Implement validation checks, reconciliation logic, and quality controls to detect missing, inconsistent, or inaccurate data.

  • Partner closely with data engineering and software engineering on source data quality, schema changes, data modeling, and pipeline issues.

  • Document analytical models, metric definitions, assumptions, and known data limitations so other teams can use and trust the data.

  • Establish standards for production-ready BI assets, including correctness, maintainability, performance, and documentation.

Foundational Ownership & Scalability

  • Own the BI function end to end, from understanding requirements and exploring source data to building, validating, deploying, and maintaining analytical solutions.

  • Prioritize BI work based on business impact, balancing immediate reporting needs with building reusable foundations.

  • Develop scalable reporting and self-service capabilities that reduce dependence on manual analysis and repetitive requests.

  • Establish practical engineering practices for BI development, including version control, testing, review, and change management where appropriate.

  • Work independently and make pragmatic technical decisions in a fast-moving environment with evolving requirements and imperfect data.

Qualifications

Must-Haves

  • 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-Haves

  • 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.

What Success Looks Like

  • Reliable BI foundation: Core business metrics are clearly defined, validated, and consistently used across internal and client-facing reporting.

  • Hands-on delivery: You independently build and maintain the SQL models, dashboards, and reporting tools the business needs.

  • Operational visibility: Business teams can understand recovery performance, case throughput, bottlenecks, and operational efficiency without relying on fragmented or manually assembled data.

  • Proactive problem-solving: You identify discrepancies and performance issues early, investigate their causes, and help business teams act on the findings.

  • Scalable analytics: Reporting becomes increasingly reusable, automated, and self-service as TPIC grows, rather than requiring more manual effort for every new question.

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.

Demand for Analyst roles

New Analyst postings at the employers we follow are up 26% over the last 6 weeks compared with the 6 before.

Weekly new Analyst postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 993, the most 1,510, and the latest week had 1,367.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Analyst, by the work the posting describes.

Analysts answer business questions with data. They pull numbers with SQL, build reports and dashboards, and explain what changed and why to the people making decisions.

Most postings ask for SQL, spreadsheets, a dashboard tool such as Tableau or Power BI, and clear writing.

Unlike a data scientist, an analyst mostly explains what happened rather than building models that predict what will.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

United States

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.