Analytics Engineer, Finance & Modeling

OurFamilyWizard; Illinois; On-site; USD 100,000 - 130,000; Full time

Benefits offered by this job

Medical coverage

4% 401k match

Paid parental leave

L&D stipend

Holidays

PTO

Flexible work

Job summary

In Tandem seeks an Analytics Engineer (Finance & Modeling) to own metrics, reporting, and reconciliation across OurFamilyWizard, Cozi, FamilyWall and Custody Navigator. Based in Chicago with remote options, you’ll work on a dbt Databricks finance mart in production and build the top layer that finance can trust.

You’ll forecast, model, and automate checks, turning subscription and transaction data into defendable numbers for CFOs and boards, while collaborating across four brands and AI-enabled

Qualifications

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

Responsibilities

• Governed metrics: add definitions the finance mart doesn't have yet (ARR, renewal rate, churn, CAC), versioned and tested.
• Reporting Finance can run without you: move recurring finance pack to marimo and schedule monthly reports.
• Numbers that reconcile: reconcile transactions across app stores, processors, subscription systems and ledger with automated checks.
• Forecasting for Finance: cohort and revenue projection, renewal/retention forecasting, LTV by acquisition source, pricing impact modeling.
• Models ship as scored tables in dbt and Unity Catalog, with tests, lineage and a definable semantic layer.

Skills

Analytics engineering

SQL

Python

Git

dbt

Databricks

Unity Catalog

Tools

Databricks

Unity Catalog

dbt

Job description

Analytics Engineer, Finance & Modeling

Department: Data Engineering

Employment Type: Permanent - Full Time

Location: Chicago - Remote

Compensation: $100,000 - $130,000 / year

Description

At In Tandem, we build technology that helps families manage everyday routines and navigate life’s biggest transitions. Through our four brands—OurFamilyWizard, Cozi, FamilyWall, and Custody Navigator, we help families stay organized, communicate well, and foster healthy childhoods.

We believe technology should strengthen relationships and make daily coordination less complicated. Everything we create is designed to lighten the mental load, reduce conflict, and support families through big and small moments.

If you want your work to make a real difference in the daily lives of parents and kids, In Tandem is the place where your impact will truly matter. 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 escalated. 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.

Nice to have, not a dealbreaker:

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

We’re redefining family technology. 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.

Scale meets startup energy. 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.

Purpose-driven. Performance-focused. People-first. 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.

How we support you:

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

Come As You Are!

In Tandem provides equal employment opportunities to all employees and applicants for employment and prohibits discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state or local laws.