// data analyst · analytics engineer

Data in.
Decisions out.

I help startups see their business clearly — building the pipelines, models, and dashboards behind $100M+ in revenue decisions, and finding the money everyone else missed.

Explore my work Let’s talk
  • 4+ years in data
  • 6+ startups shipped with
  • remote-first, US time zones
impact_report.sql 
SELECT metric, value
FROM career_impact
WHERE analyst = 'Ujjwal Jha'
ORDER BY business_value DESC;
revenue_analyzed$100.6M+
refund_leakage_surfaced$9.67M
query_runtime_cut96.5%
pipeline_uptime99.99%
4 rows returned · 14 ms

$100.6M+

Revenue analyzed end-to-end

leadership revenue-protection dashboard

$9.67M

Refund leakage surfaced

broken down by tier & customer type

96.5%

Query runtime cut

6m 40s → 14s · CTEs, indexes, joins

99.99%

Production pipeline uptime

7+ sources flowing into PostgreSQL

// how I add value

Tools are table stakes.

SQL, Snowflake, Sigma, Power BI, Python — I’m fluent in the stack. But you don’t hire an analyst for the stack. You hire one for what happens to the business next.

fn find_the_money()

Find the money

Revenue leakage, commission accuracy, payout forecasting — I dig until the numbers explain themselves, then hand leadership a decision, not a data dump.

$9.67M leakage surfaced · $7M commissions at 100% accuracy

fn make_data_dependable()

Make data dependable

Pipelines, modeling, and warehousing that nobody has to babysit — engineered for reliability first and cost a very close second.

99.99% uptime · Fivetran spend $900/mo → $0

fn ship_decisions()

Ship decisions, not just charts

Executive views the C-suite actually opens every morning — designed around the questions leadership is really asking.

$33M+ tracked for COO/CTO · 3 dashboards in first 4 days

// where I’ve done it

Proof, in production.

Analytics Engineer

US-Based Fitness Company

Nov 2025 – Jan 2026

  • Built the C-suite operations dashboard in Sigma — $33M+ in revenue, ad spend, and new customers across MTD / QTD / YTD and prior-day views.
  • Shipped 3 production Black Friday dashboards within 4 days of joining — $1.7M+ in sales and 300+ renewals monitored in real time.
  • Cut a business-critical query from 6m 40s to 14s (−96.5%) through CTE refactoring, index design, and join optimization.
  • Replaced spreadsheet commission tracking with an analytics system covering $7M+ in sales — automated tier-based payouts at 100% accuracy.
  • Drove Fivetran transformation costs to $0 (−$900/mo) and kept a 7-source production ETL at 99.99% uptime.
  • Designed a payout framework tracing $3.5M+ in coach payouts, with customer lifecycle modeled through 2031 — used directly by the COO and CTO.

SigmaSQLPostgreSQLFivetranHubSpotSupabase

Data Analyst Consultant

6+ pre-seed & seed startups

Mar 2021 – Present

  • +25% product sign-ups via funnel analysis — pinpointed an OTP verification drop-off and partnered with the mobile team to fix it.
  • +40% processing efficiency with scalable Snowflake / Python / SQL ETL over 20M+ row, multi-source datasets.
  • +25% marketing ROI through channel & campaign analysis and KPI dashboards — ROI, ROAS, LTV, CAC, ARPU.
  • +10% customer acquisition by rebalancing budget using LTV:CAC, retention, and churn analysis across channels.

SQLPythonSnowflakePower BIA/B Testing

// the toolkit

The stack behind the outcomes.

TABLE skills.analytics_experimentation

SQL (Advanced)Python · PandasstatsmodelsStatisticsA/B TestingHypothesis TestingFunnel AnalysisCohort AnalysisRetention & ChurnKPI Design

TABLE skills.data_engineering

ETL / ELTData PipelinesData ModelingData WarehousingAPIsFivetran

TABLE skills.warehouses_databases

SnowflakeBigQueryRedshiftPostgreSQLMySQLSupabase

TABLE skills.bi_visualization

SigmaPower BI · DAXPower QueryLooker StudioExcel

// selected work

Projects with a point.

Each one built end-to-end: raw data → pipeline → model → a dashboard someone can act on.

All projects →

Product Analytics

End-to-end product analytics delivering executive-ready insight across revenue, customer behavior, cohorts, and product performance.

Marketing Analytics

ETL, data modeling, and dashboards for campaign & creative performance — surfacing top channels, campaigns, and CTAs.

// next step

Got data? Let’s make it decisive.

I partner with teams that want clarity — fully remote, async-friendly. If your dashboards raise more questions than they answer, we should talk.

Email me LinkedIn

· Working across US/EU and many other time zones