Analytics Engineer, Finance & Modeling
Chicago, Illinois, Chicago - Remote
- Pay
$100,000–130,000/year — pay source
Compensation $100,000 - $130,000 / year Employment type
Read the full posting- Work setting
Remote — work setting source
Listed location: Chicago, Illinois, Chicago - Remote
Work setup in the employer’s posting: Remote
From the employer’s posting- Employment
Permanent — employment source
Employment type Permanent - Full Time
Read the full posting
What you’ll work on
Full postingDefine and test governed metrics such as ARR, renewal rate, churn and CAC in dbt
Move the recurring finance pack into marimo and retire the Tableau views behind it
Build automated reconciliation checks across app stores, processors, subscriptions and the ledger
Build cohort subscriber and revenue projections and renewal forecasts for the CFO
Model LTV by acquisition source to inform paid spend with Growth
From the employer’s posting
Add the definitions the finance mart doesn't have yet (ARR, renewal rate, churn, CAC)
Move the recurring finance pack into marimo, retire the Tableau views behind it
Reconcile transactions across the app stores, payment processors, subscription systems and the ledger, with automated checks that alert rather than surface at close.
Cohort subscriber and revenue projection, and aggregate renewal and retention forecasting, feeding the CFO's forecast and board reporting.
LTV by acquisition source, feeding paid spend allocation with Growth.
What you’ll bring
All qualificationsCore experience
- 3+ years in analytics engineering, data science, BI engineering or advanced analytics.
- Strong SQL and real dimensional modeling.
- Python and Git as daily habits.
Qualification wording
3+ years in analytics engineering, data science, BI engineering or advanced analytics.
Strong SQL and real dimensional modeling. You've designed marts, not just queried them.
Python and Git as daily habits.
Tools in this posting
- Python
- SQL
- Databricks
- dbt
- Tableau
- Streamlit
Source — Tool mentions in context
- Strong SQL and real dimensional modeling. You've designed marts, not just queried them. - Python and Git as daily habits. Nice to have, not a dealbreaker:
- Subscription metrics you've built and defended to a finance stakeholder: ARR/MRR, renewal, churn, LTV/CAC, or cohort revenue. - Strong SQL and real dimensional modeling. You've designed marts, not just queried them. - Python and Git as daily habits.
As an Analytics Engineer (Finance & Modeling), you'll own the metrics, reporting and reconciliation our financial decisions rest on, turning subscription and transaction data across OurFamilyWizard, Cozi, FamilyWall and Custody Navigator into numbers the business can defend. As that foundation becomes automatic, the work shifts toward forecasting and modeling. You won't start from scratch. Our dbt project is live on Databricks with a star-schema finance mart in production and documented in Unity Catalog. What's missing is the layer on top, and that layer is yours. We also run an internal AI agent that answers business questions in Slack off the semantic layer, so every metric you define and test becomes a question Finance can ask directly rather than queue. What you'll accomplish:
Nice to have, not a dealbreaker: - dbt, Databricks and Unity Catalog, or a comparable lakehouse. - Reconciling transactional data to a financial system of record.
What you'll accomplish: - Governed metrics. Add the definitions the finance mart doesn't have yet (ARR, renewal rate, churn, CAC), versioned in dbt and documented in Unity Catalog, with the tests that make each one defensible, and wired into the agent so Finance can ask them directly. - Reporting Finance can run without you. Move the recurring finance pack into marimo, retire the Tableau views behind it, and turn a monthly hand-build into something that runs on a schedule.
- Forecasting for Finance. Cohort subscriber and revenue projection, and aggregate renewal and retention forecasting, feeding the CFO's forecast and board reporting. LTV by acquisition source, feeding paid spend allocation with Growth. Pricing and promo impact, modeled before we ship rather than measured after. Individual churn propensity and uplift follow once there's a retention motion ready to act on the scores. - Models ship as scored tables in dbt and Unity Catalog, with tests, lineage and a definition the agent can answer from. Not as notebooks. Who you are:
- Governed metrics. Add the definitions the finance mart doesn't have yet (ARR, renewal rate, churn, CAC), versioned in dbt and documented in Unity Catalog, with the tests that make each one defensible, and wired into the agent so Finance can ask them directly. - Reporting Finance can run without you. Move the recurring finance pack into marimo, retire the Tableau views behind it, and turn a monthly hand-build into something that runs on a schedule. - Numbers that reconcile. Reconcile transactions across the app stores, payment processors, subscription systems and the ledger, with automated checks that alert rather than surface at close. Route discrepancies upstream with the evidence attached and turn each one into a test. You build the checks and escalate. Accounting owns the treatment.
- Reconciling transactional data to a financial system of record. - Code-first notebook reporting (marimo, Hex, Streamlit, Quarto). Why Join?
Posting record
Report an error- Status in our records
- Live
- First seen by us
- Sep 5, 2026 · 54 days ago
- Recorded sightings
- 25
- Last seen by us
- Oct 29, 2026
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.
Your next step
Check the employer’s posting for the current role and application details.
Already applied? Track this application
Job description
As an Analytics Engineer (Finance & Modeling), you'll own the metrics, reporting and reconciliation our financial decisions rest on, turning subscription and transaction data across OurFamilyWizard, Cozi, FamilyWall and Custody Navigator into numbers the business can defend. As that foundation becomes automatic, the work shifts toward forecasting and modeling.
You won't start from scratch. Our dbt project is live on Databricks with a star-schema finance mart in production and documented in Unity Catalog. What's missing is the layer on top, and that layer is yours. We also run an internal AI agent that answers business questions in Slack off the semantic layer, so every metric you define and test becomes a question Finance can ask directly rather than queue.
What you'll accomplish:
- Governed metrics. Add the definitions the finance mart doesn't have yet (ARR, renewal rate, churn, CAC), versioned in dbt and documented in Unity Catalog, with the tests that make each one defensible, and wired into the agent so Finance can ask them directly.
- Reporting Finance can run without you. Move the recurring finance pack into marimo, retire the Tableau views behind it, and turn a monthly hand-build into something that runs on a schedule.
- Numbers that reconcile. Reconcile transactions across the app stores, payment processors, subscription systems and the ledger, with automated checks that alert rather than surface at close. Route discrepancies upstream with the evidence attached and turn each one into a test. You build the checks and escalate. Accounting owns the treatment.
- Forecasting for Finance. Cohort subscriber and revenue projection, and aggregate renewal and retention forecasting, feeding the CFO's forecast and board reporting. LTV by acquisition source, feeding paid spend allocation with Growth. Pricing and promo impact, modeled before we ship rather than measured after. Individual churn propensity and uplift follow once there's a retention motion ready to act on the scores.
- Models ship as scored tables in dbt and Unity Catalog, with tests, lineage and a definition the agent can answer from. Not as notebooks.
Who you are:
- Statistically rigorous. You know why a cohort curve is the wrong shape, what a model is leaking, and when a result is noise.
- Fluent in finance, and unwilling to let a number you can't explain go out the door. When two systems disagree, you find out why and tell the people upstream.
- An engineer who owns the number end to end, from a CFO's question through the model, the test, the report and the conversation that follows. A spreadsheet nobody can reproduce reads to you as a liability.
- AI-proficient in practice, not in theory. Claude Code, coding agents and agent SDKs are part of our daily loop, and we expect you to already work this way. A lot of what used to be a week of modeling work is now an afternoon, and we're hiring for people who have internalized that.
- Willing to wear several hats. This is a small team supporting four brands. Some weeks you're deep in a retention model, some weeks you're chasing an app store discrepancy or unblocking someone else's dashboard. The scope above is the center of the role, not a fence around it.
- Motivated by work that matters. Families rely on these products during real moments in their lives.
What you bring:
- 3+ years in analytics engineering, data science, BI engineering or advanced analytics.
- Statistical modeling shipped into a business process: forecasting, survival or cohort analysis, or propensity.
- Measuring the lift from a price change or a growth experiment. You don't need to have designed the test, but you need to be able to read the result honestly and say what it's worth.
- Subscription metrics you've built and defended to a finance stakeholder: ARR/MRR, renewal, churn, LTV/CAC, or cohort revenue.
- Strong SQL and real dimensional modeling. You've designed marts, not just queried them.
- Python and Git as daily habits.
- dbt, Databricks and Unity Catalog, or a comparable lakehouse.
- Reconciling transactional data to a financial system of record.
- Code-first notebook reporting (marimo, Hex, Streamlit, Quarto).
Why Join?
In Tandem brings together a growing portfolio of trusted tools that support families, and the professionals who guide them, through the moments that matter most. We bring clarity to chaos and stability to daily family life, helping parents feel less stressed so kids can have healthier childhoods.
With more than 20 years of impact and a strong market presence, we’re entering a bold new chapter of growth. We have the foundation, the momentum, and the ambition to go further: expanding our reach, deepening our impact, and elevating the tools families and professionals rely on every day.
Our culture is rooted in accountability, curiosity, and collaboration. We value diverse perspectives, thoughtful problem-solving, and teammates who care deeply about building something that matters.
- Medical: In Tandem pays 100% of the premium for employees AND 99% for all additional family members
- 401k: Up to a 4% match with immediate vesting
- Paid leave for all new parents
- Learning & Development stipend for employees
- Paid Time Off: 11 Holidays + Winter Break (3 Days) + Volunteer Time Off (1 Day) + Floating Holiday (1 Day)
- Personal Time Off: 15 days for 0-1 years of employment, 20 days 1-3 years of employment
- Supportive and flexible working environment – work from anywhere!
Compensation
$100,000 - $130,000 / year
Employment type
Permanent - Full Time
Source details
Source notes
Source excerptsSelected passages from the saved posting. Check the full description for conditions and exceptions.
- Pay
Compensation $100,000 - $130,000 / year Employment type
- Location & working pattern
Chicago, Illinois, Chicago - Remote
Working pattern and location restrictions need checking in the full posting.
- Work authorization
No clear work-authorization passage found. Eligibility is unconfirmed.
AI answers unavailable
We couldn’t identify enough role detail in this saved description to support an AI answer. Read the full posting