// Lead Analyst · Data & Marketing

Data that drives
decisions.
Not just reports.

I'm Swarnadip — a Lead Analyst with 3+ years turning messy, multi-source data into attribution models, segmentation pipelines, and dashboards that teams actually use.

majumderswarnadip@gmail.com
Open to opportunities
swarnadip@career.io ~ analytics.sql
SELECT channel, SUM(revenue) as romi
FROM attribution_model
WHERE cohort_month = '2024-09'
GROUP BY 1 ORDER BY 2 DESC;
// running... 50M+ rows · ClickHouse
Query complete · 0.38s · 4 channels ranked
+15%
ROMI boost
+7%
conversions
100+
data models
scroll
CAC ↓18% ROMI +15% CVR +7% SM Lead Analyst
majumderswarnadip@gmail.com
+91 85974 48018
Raiganj, West Bengal, India · Remote

// specialisations

Marketing attribution & channel analysis
User segmentation at scale (50M+ records)
dbt data pipelines & warehouse modelling
A/B testing & product analytics
Executive KPI dashboards (CAC, LTV, AOV)
Download Resume

// about me

Analyst.
Strategist.
Problem solver.

100+
data models
50M+
records processed
3+
years exp

I'm Swarnadip — a Lead Analyst currently at Career.io (Bridgetalent Pvt. Ltd.), where I sit at the intersection of data engineering and business intelligence. I build the models, pipelines, and dashboards that give teams the clarity to act fast and spend smart.

My edge is breadth with depth: I can write production-grade SQL in Redshift and ClickHouse, design dbt pipelines from staging to mart, and translate the output into a clean Periscope dashboard the exec team can actually navigate. I've shipped attribution models, user segmentation systems for 50M+ records, and A/B testing frameworks that moved conversion metrics.

I think of myself less as an "analyst" and more as the person who closes the loop between data and decision.

Marketing Analytics Product Analytics Data Engineering A/B Testing Attribution Modelling KPI Dashboards

// selected projects

Work that
moved numbers.

Featured Project ↑ Production

Marketing Attribution Model

Built a multi-touch attribution model using ClickHouse and Mixpanel event data to accurately credit each marketing channel across the customer journey. Merged ad platform data, Google Search Console, and Impact partner data for a full-funnel view. The model directly informed budget reallocation and drove a 15% increase in ROMI.

ClickHouseMixpanelSQLGoogle Ads APISearch ConsolePython
+15%
Return on marketing investment
4 ch
Channels mapped end-to-end
// channel attribution breakdown
Paid Search38%
Email (organic)29%
Affiliate / Impact21%
Display / Other12%
// model outcome
Budget reallocated from Display → Search
↑ ROMI 15% · quarter-on-quarter
Segmentation · Email

User Segmentation for Personalized Email

Processed 50M+ resumes with Sovren to extract job title, industry, and YOE. Used GPT + an in-house canonical service to build audience segments for targeted email and product offerings. Shipped a dbt pipeline (staging → transform → mart) and a conversion dashboard tracking open rates, CTR, and CVR.

PythonGPT APIdbtMessageGears
+7% conversion rate increase
BI · KPI Monitoring

Executive Management Dashboard

Built an interactive KPI dashboard in Periscope tracking CAC, LTV, and AOV in real time. Implemented ETL in dbt integrating ad platforms, PSPs, and product data. Leadership went from weekly Excel reviews to a single live source of truth.

PeriscopedbtRedshiftSQL
CAC · LTV · AOV · real-time
Finance · Partner Ops

Payout Attribution Model

Designed and maintained a payout attribution model at Career.io to allocate revenue credits to external partners accurately. Also managed payout structure optimization at Shadowfax across multiple locations, ensuring financial accuracy and operational consistency.

SQLRedshiftPythonZoho Analytics
Measurable cost savings on partner payouts

// technical stack

Tools I
actually ship with.

Languages
SQLPython
Analytics & BI Tools
PeriscopeMixpanelZoho AnalyticsTableauRedash
Databases
MySQLPostgreSQLClickHouse
Data Warehouses
RedshiftSnowflake
ETL & Transformation
dbtStitch
Other Tools
MessageGearsJIRALinearMiroWhimsical

// depth of expertise

SQL · Data ModelingExpert
Attribution & A/B TestingExpert
dbt · Warehouse PipelinesAdvanced
Python · ML / SegmentationProficient
Email Marketing AnalyticsExpert

// domain focus

Marketing Analytics
Attribution, email, CVR
Product Analytics
A/B testing, funnels, UX
Data Engineering
dbt, ETL, warehousing
Executive Reporting
KPIs, CAC, LTV, dashboards

// career history

Where I've
shipped work.

Software Engineer · Lead Analyst

Career.io (Bridgetalent Pvt. Ltd.) · Remote
Jun 2022 – Present
  • Led a team of analysts to solve complex business challenges and improve analytical capabilities
  • Designed and maintained payout attribution models for external partner payouts, resulting in cost savings
  • Developed 100+ data models to optimize data processing, reporting accuracy, and business insights
  • Set up and optimized A/B tests to boost engagement and conversions via product analytics
  • Enhanced Redshift efficiency by identifying and rewriting bottleneck queries
  • Led email marketing strategy — audience targeting logic for engagement and conversion lift
RedshiftdbtClickHouseMixpanelMessageGears

Senior Lead Data Analyst

Shadowfax Technologies Pvt. Ltd. · Bangalore
Apr 2022 – Jun 2022
  • Developed and monitored critical metrics informing strategic decisions for last-mile delivery ops
  • Conducted bi-weekly marketplace performance reviews using Excel and SQL to identify growth opportunities
  • Managed and optimized payout structures across locations for financial accuracy
SQLExcelReporting

Game Server Developer

FiveM · Self-employed · Remote
Oct 2019 – Jun 2021
  • Developed and managed multiple FiveM game servers in Lua for a prominent YouTuber
  • Optimized server performance and managed application databases to ensure data integrity
  • Collaborated on custom scripts and mods to enhance gameplay and player engagement
LuaDatabase MgmtCommunity Ops

// education

PGP in Data Science & Engineering
Great Lakes Institute of Management
Sep 2021 – Apr 2022

Covered ML, statistics, engineering pipelines, and business analytics applications.

B.Sc. Physics
The Heritage College, Calcutta University
Aug 2017 – Jul 2021

// what I bring

Full-stack analytics
From raw SQL to exec dashboards
Team leadership
Led analyst teams, mentored peers
Cross-functional impact
Marketing, product & finance
Outcomes orientation
Every model tied to a metric

// collaboration tools

JIRALinearMiroWhimsical

Comfortable with async-first, remote teams and agile workflows.

// let's connect

Have data.
Need answers?

I'm open to senior analytics, data strategy, and lead analyst roles — especially in product-led or marketing-heavy environments. If you want someone who can own the full stack from raw SQL to stakeholder decks, let's talk.

+91 85974 48018 Raiganj, West Bengal · Open to remote