Senior Data Analyst Public Cloud LRP Model Automation

Santa Clara, CA, US • Posted 12 hours ago • Updated 12 hours ago
Contract W2
50% Travel Required
On-site
$70 - $80/hr
Fitment

Dice Job Match Score™

🎯 Assessing qualifications...

Job Details

Skills

  • Monte Carlo Method
  • FP&A
  • Finance
  • Jupyter

Summary

Job Responsibilities:
Demonstrated, hands-on experience building production financial models directly in Jupyter Notebooks. Portfolio / GitHub links required analysis-only notebooks do not qualify.
Proven track record implementing Monte Carlo simulations in Python: distribution fitting, correlated variable sampling, simulation loop design, and P10/P50/P90 output interpretation.
Proficiency in core Python modelling stack: NumPy, Pandas, SciPy (stats), and at least one Monte Carlo framework (PyMC, NumPyro, custom simulation engine, or equivalent).
Experience with Plotly, Matplotlib, or Bokeh for financial chart types: waterfall bridges, fan charts, tornado charts.
Excel LRP / Driver-Based Model Experience Mandatory
Direct experience working with or converting complex Excel-based LRP, 3-statement, or driver-based financial models (multi-tab, formula-intensive, 3 5-year horizon).
Ability to reverse-engineer Excel model logic tracing precedents, documenting assumptions, and translating formula chains into equivalent Python with verified numerical accuracy.
Understanding of driver-based modelling methodology: separating volume drivers from price/rate drivers, building assumption sensitivity tables, structuring base/upside/downside scenarios.
Source System Pipeline Engineering
Ability to build lightweight ETL/ELT pipelines in Python: API authentication, pagination, schema normalization, error handling, and incremental refresh logic.
SQL proficiency for data extraction from billing databases, data warehouses
Experience with data pipeline orchestration tools (Airflow, Prefect, dbt, or notebook scheduling) is advantageous.
Model Versioning & Variance Analysis
Experience designing model version control beyond Git structured snapshot storage of inputs, assumptions, and outputs to enable point-in-time model reconstruction.
Familiarity with variance bridge / waterfall decomposition methodologies used in FP&A (price-volume-mix, driver attribution).
Comfort building automated commentary or structured output that explains numerical movements in business terms.
Qualifications:
Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.
  • Dice Id: 90941473
  • Position Id: 8949431
  • Posted 12 hours ago
Create job alert
Set job alertNever miss an opportunity! Create an alert based on the job you applied for.

Similar Jobs

Hybrid in Santa Clara, California

Yesterday

Easy Apply

Contract

Depends on Experience

Santa Clara, California

Today

Easy Apply

Contract, Third Party

$107.14

Sunnyvale, California

5d ago

Easy Apply

Contract

Depends on Experience

Santa Clara, California

Today

Easy Apply

Third Party, Contract

Search all similar jobs