Lead Financial Data Analyst

Upside•Washington, DC

4d•$145,000 - $180,000•Hybrid

About The Position

As a Lead Financial Data Analyst, you will own the translation of large operational datasets into strategic financial frameworks. Sitting at the intersection of FP&A and Data Engineering, you will scale our financial data infrastructure, replace legacy reporting with automated pipelines, and deliver high-impact analytics directly to senior leadership and cross-functional business partners.

Requirements

7+ years of experience in FP&A or Strategic Finance at a high-growth SaaS/Tech company
Advanced SQL mastery (window functions, CTEs, query optimization). Experience with Snowflake, AWS, and HEX.
Experience using dbt for data transformation, or basic workflow orchestration with Airflow.
High proficiency in Python (Pandas, NumPy) and automating financial workflows.
Expert-level creation of dynamic reporting layers in Looker, HEX, and/Pigment.
Advanced knowledge of tech unit economics (LTV, CAC, Payback Period, Churn) and corporate finance fundamentals.

Responsibilities

Scale Data Architecture: Partner directly with Data Engineering to design, optimize, and maintain financial data warehouses (using Snowflake).
Owner of Financial Datasets: Define, write, and maintain complex SQL queries and dbt models to transform raw data into clean, audit-ready financial metrics.
Maintain FP&A Planning Tool: Manage spend forecast and actuals data for department budget owners in planning tool (Pigment) as well as drive optimization of spend through AI exploration and trend analysis.
Automate Revenue Workflows: Architect automated pipelines to track key user metrics such as CAC, LTV, Payback periods, and IRR.
Statistical Forecasting: Leverage Python and AI to improve user cohort performance forecasting as well as merchant net revenue retention.
New Vertical Pricing Support: Partner with Product and Go-to-market teams to model the financial impact of new pricing models, monetization strategies, or international expansions.
Institutional Dashboarding: Design and build self-service dashboards (using Looker, HEX) that allow executive leadership to track real-time performance of the business.
Ad-Hoc Strategic Analytics: Act as analytical swat team for high-stakes business cases, evaluating corporate development opportunities or M&A modeling.