Analytics you can audit.

Four shapes of engagement.

Scope is written down before anything starts, and you keep everything that gets built.

1. 01 Make the numbers defensible.

   Reimbursement and benchmark models, price-transparency data, payer-facing analysis, outcomes and effect-size work. Sourcing you can hand to a skeptic without bracing for it. Where a figure has no anchor in a primary source, it gets listed as a gap rather than estimated into place.

2. 02 Build the platform underneath them.

   Microsoft Fabric: medallion lakehouse, PySpark notebooks, OneLake shortcuts, capacity sizing, workspace and gateway governance, refresh orchestration. Power BI: semantic models, DAX, Power Query M, row-level security. Fix the model once and everything downstream gets easier.

3. 03 Ship the tool people use.

   Next.js and Postgres on Vercel: auth-gated internal applications, importers, export packs, CRMs. Built by the same person who modeled the data, so the model and the interface never drift apart.

4. 04 Sit in the room for the decision.

   Fractional analytics leadership. Roadmap, governance, vendor evaluation, and the translation between data, operations, and leadership that most teams are actually short of. Most organizations do not need another report.

You get the code, the models, and the documentation. Not just a slide deck.

The terms, before you ask.

These are the terms on the signed statement of work, not a posture written for this page.

Basis

Time and materials, billed against a written estimate.

Cap

A written not-to-exceed on every engagement. The invoice cannot surprise you.

The 80% call

When billed hours reach 80 percent of the estimate, I tell you in writing before continuing. That is a clause, not a courtesy.

Invoicing

Itemized by workstream with the hours attached, not a lump sum. Net 15.

Ledger

A running hours ledger you can read start to finish, with every hour tagged to the invoice it was billed on.

IP

Assigns to you on full payment. All of it.

Exit

Either of us can end the engagement on seven days' written notice.

Changes

Scope changes by written change order only.

The budget position is printed on the face of every invoice I send — hours worked against the estimate, dollars billed against the cap — so you never have to ask where you stand. Including on the invoices where the position is uncomfortable.

Ren Rooney.

Ten-plus years building data products in healthcare and consulting. Most recently, Director of Analytics at a multi-site behavioral health provider, where I architected and administered the Microsoft Fabric environment — medallion lakehouse, PySpark notebooks, OneLake shortcuts, capacity sizing, workspace and gateway governance, refresh orchestration — and owned the Power BI semantic layer above it.

Before that, four years in management consulting in Chicago: staffing and spend analysis across managed IT services engagements, technology scorecards benchmarking client operations against their peers, and the BI layer behind an annual industry technology benchmark. I started in healthcare revenue-cycle analytics at an academic medical center, building recurring dashboards across several revenue-cycle systems and presenting fiscal-year trend findings at quarterly reviews.

Data-Roo is the independent practice. It runs on my own accounts and my own infrastructure and has never touched an employer's.

Published

Co-author, a peer-reviewed study on the effectiveness of brief partial hospitalization for depression and anxiety. the Behavior Therapist, Vol. 49 No. 1, January 2026.

Spoke

Four Becker's Healthcare panels across 2025 and 2026: behavioral health data strategy, EHR data silos and integration, and health IT tooling.

Degree

B.B.A., Business Analytics and Information Systems, University of Iowa.

Microsoft Fabric · Power BI · DAX · PySpark · T-SQL / Spark SQL · Python · Next.js · Postgres · Vercel

Tell me what is broken.

The report nobody trusts, the platform decision you are stuck on, the number two systems disagree about. Send the problem, who else is involved, and what "done" would look like.