Lead Financial Data Analyst

upside

United States

Hybrid

USD 145,000 - 180,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Medical, dental, and vision
Equity (ISOs)
401(k) program
Parental leave
Wellness memberships
Mental health support
Unlimited PTO
Flexible work environment
Lunch reimbursement
Employee Resource Groups
Learning and Development stipend
Transparent culture
Mission-driven

Job summary

Upside is seeking a Lead Financial Data Analyst to translate large operational datasets into strategic financial insights. You will sit at the intersection of FP&A and Data Engineering, scaling financial data infrastructure, replacing legacy reporting with automated pipelines, and delivering analytics to senior leadership.

You’ll own data warehouses with Snowflake, write dbt models, manage Pigment planning data, and build Looker/HEX dashboards.

Qualifications

  • The Technical Core: 7+ years of FP&A or Strategic Finance at a high-growth SaaS/Tech company.
  • Databases & Querying: Advanced SQL mastery (window functions, CTEs, query optimization). Experience with Snowflake, AWS, and HEX.
  • Data Pipelines: Experience using dbt for data transformation, or basic workflow orchestration with Airflow.
  • Programming: High proficiency in Python (Pandas, NumPy) and automating financial workflows.
  • Business Intelligence: Expert-level creation of dynamic reporting layers in Looker, HEX, and Pigment.
  • Traditional Finance: 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.

Skills

SQL
Snowflake
AWS
HEX
dbt
Airflow
Python
Pandas
NumPy
Looker
Pigment
Unit economics

Tools

Looker
HEX
Pigment

Job description

Meet Upside:

We created Upside to transform brick-and-mortar commerce. Our technology uses the sophistication of online retail-profit measurement, attribution, and incrementality-to provide users with more value on their everyday purchases and brick-and-mortar businesses with new, profitable customers. We’ve helped millions of users earn 2 to 3 times more cashback than any other product, and hundreds of thousands of brick-and-mortar businesses earn measurable profit. Billions of dollars in commerce run through the Upside platform every year, and that value goes directly back to our retailer partners, the consumers they serve, and important sustainability initiatives.

The Role:

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.

What You’ll Do:
  • 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.
What You’ll Need:
  • The Technical Core: 7+ years of experience in FP&A or Strategic Finance at a high‑growth SaaS/Tech company
  • Databases & Querying: Advanced SQL mastery (window functions, CTEs, query optimization). Experience with Snowflake, AWS, and HEX.
  • Data Pipelines: Experience using dbt for data transformation, or basic workflow orchestration with Airflow.
  • Programming: High proficiency in Python (Pandas, NumPy) and automating financial workflows.
  • Business Intelligence: Expert‑level creation of dynamic reporting layers in Looker, HEX, and/Pigment.
  • Traditional Finance: Advanced knowledge of tech unit economics (LTV, CAC, Payback Period, Churn) and corporate finance fundamentals.
The fine print:

Location: This hybrid role is based in our Austin, Chicago, DC, or NYC office. In‑office attendance is required on Monday, Tuesday, and Thursday and may increase based on project‑based needs and changes to Upside’s in‑office policy over time.

Compensation: The U.S. base salary range for this full‑time position varies by work location:Tier 1: NYC $160,000 - $180,000Tier 2: Austin, Chicago, Washington, DC $145,000 - $165,000In addition to base salary, this position is also eligible for equity and benefits.The final starting pay will be determined based on job‑related skills, experience, qualifications, work location, and market conditions.

#LI-Hybrid

Benefits:
  • Medical, dental, and vision coverage starting on Day1
  • Equity (ISOs)
  • 401(k) program
  • Family planning programs + paid parental leave
  • Physical fitness and wellness memberships
  • Emotional and mental health support programs
  • Unlimited PTO + 10 paid federal holidays + our annual, week‑long Winter Break
  • Flexible work environment
  • Lunch reimbursement for in‑office employees
  • Employee Resource Groups
  • Learning and Development stipend
  • Transparent culture
  • Amazingmission!
Diversity and Inclusion:

Diversity drives innovation, and our differences make us stronger. We’re passionate about building a workplace that represents a variety of backgrounds, skills, and perspectives, and we do not discriminate based on race, religion, color, national origin, gender, sexual orientation, age, marital status, veteran status, or disability status. Everyone is welcomehere!

If there’s anything we can do to support a disability or special need during your application or interview process, please email accommodations@upside.com.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Lead Financial Data Analyst
Lead Financial Data Analyst

Upside • Washington

Hybrid
USD 145,000 - 180,000
Medical, dental, and vision coverage
Equity (ISOs)
401(k) program
+8
Analytics Engineer, Data Platform
Analytics Engineer, Data Platform

Upside • Washington

On-site
USD 120,000 - 180,000
Medical, dental, and vision coverage
Equity (ISOs)
401(k)
+3
Director, Merchant & Payments Engineering
Director, Merchant & Payments Engineering

Upside • New York (NY)

Hybrid
USD 270,000 - 293,000
Medical, dental, and vision coverage
Equity (ISOs)
401(k) program
+1
Analytics Engineer, Data Platform
Analytics Engineer, Data Platform

Upside • City of Syracuse (NY), City of Auburn (NY)

On-site
USD 110,000 - 170,000
Medical/dental/vision
Equity (ISOs)
401(k)
+6
Analytics Engineer, Data Platform
Analytics Engineer, Data Platform

Upside • Chicago (IL)

On-site
USD 149,000 - 180,000
Health insurance
Equity
401(k)
Analytics Engineer, Data Platform
Analytics Engineer, Data Platform

Upside • New York (NY)

On-site
USD 149,000 - 180,000
Medical coverage
Dental coverage
Equity (ISOs)
+4
Analytics Engineer, Data Platform
Analytics Engineer, Data Platform

Upside • Washington

On-site
USD 149,000 - 180,000
Medical/Dental/Vision
Equity (ISOs)
401(k)
+10
Staff Forward Deployed Engineer, GTM Platform
Staff Forward Deployed Engineer, GTM Platform

Upside • New York (NY)

On-site
USD 150,000 - 210,000
Engineering Manager, Reconciliation
Engineering Manager, Reconciliation

Upside • New York (NY)

Hybrid
USD 188,000 - 237,000
Medical, dental, vision coverage
Equity (ISOs)
401(k) program
+10
Director, Engineering - Merchant & Pay
Director, Engineering - Merchant & Pay

Upside • Austin (TX)

Hybrid
USD 245,000 - 293,000
Medical, dental, and vision coverage
Equity (ISOs)
401(k) program
+9