Analytics Engineer, Finance & Modeling

This is a fully remote position, open to applicants in Illinois.

📋 Description

• Take ownership of the metrics, reporting, and reconciliation that support financial decisions for OurFamilyWizard, Cozi, FamilyWall, and Custody Navigator.

• Incorporate governed finance metrics like ARR, renewal rates, churn, and CAC, all versioned in dbt, documented in Unity Catalog, tested, and integrated into the internal Slack AI agent.

• Transition recurring finance reporting to marimo, phase out the underlying Tableau views, and automate scheduled executions.

• Reconcile transactions across app stores, payment processors, subscription systems, and the ledger.

• Establish automated checks for discrepancies and alerts, escalate discrepancies with supporting evidence, and transform discrepancies into tests; Accounting will manage the resolution.

• Project cohort subscriber and revenue forecasts, aggregate renewal and retention data, and provide inputs for CFO forecasts and board reports.

• Model LTV by acquisition source to guide paid-spend allocation in collaboration with Growth.

• Analyze pricing and promotional impacts prior to launch.

• Develop individual churn propensity and uplift models once retention workflows are established.

• Deliver models as tested, traceable scored tables in dbt and Unity Catalog instead of notebooks.

⛳️ Requirements

• Minimum of 3 years in analytics engineering, data science, BI engineering, or advanced analytics.

• Experience in statistical modeling applied to business processes, such as forecasting, survival or cohort analysis, or propensity modeling.

• Proven ability to measure the impact of price changes or growth experiments.

• Demonstrated experience in building and defending subscription metrics to finance stakeholders, including ARR/MRR, renewal rates, churn, LTV/CAC, or cohort revenue.

• Proficiency in SQL and real dimensional modeling; designed marts rather than merely querying them.

• Regular use of Python and Git.

• Practical proficiency in AI, including tools like Claude Code, coding agents, and agent SDKs.

• Statistically rigorous with the ability to identify incorrect cohort curves, model leakage, and statistical noise.

• Strong understanding of finance, capable of investigating and clarifying discrepancies between systems.

• Ownership of metrics from end to end, addressing CFO inquiries through modeling, testing, reporting, and follow-up.

• Willingness to take on multiple roles within a small team supporting four brands.

• A motivation to work on products that benefit families.

• Experience with dbt, Databricks, and Unity Catalog or similar lakehouse technologies is a plus.

• Background in reconciling transactional data to a financial system of record is advantageous.

• Familiarity with code-first notebook reporting using marimo, Hex, Streamlit, or Quarto is a plus.

🏝️ Benefits

• Medical: In Tandem covers 100% of the premium for employees and 99% for all additional family members.

• 401k: Offers a match of up to 4% with immediate vesting.

• Paid leave available for all new parents.

• Learning & Development stipend provided 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, increasing to 20 days for 1-3 years of employment.

• Supportive and flexible working environment – work from anywhere!