Experience : 4.00 + years

Salary : Confidential (based on experience)

Expected Notice Period : 30 Days

Shift : (GMT+05:30) Asia/Kolkata (IST)

Opportunity Type : Office ()

Placement Type : Full Time Permanent position(Payroll and Compliance to be managed by: al)

**(*Note: This is a requirement for one of Uplers' client - al)

**What do you need for this opportunity?

Must have skills required: Business Analyst, Strategy analyst, Growth Analyst, Product Analyst, SQL, BigQuery, Cohort, retention, LTV, Unit economics, Financial Modelling, Ott, OTT streaming, Media al is Looking for:**** Business Analyst | Full BULLET MICRODRAMA BUSINESS | MUMBAI / DELHI NCR Role snapshot

- Position: Business Analyst - Strategy, Investment Intelligence & Growth Analytics mid-level individual contributor 4-7 years of relevant experience.
- Education: MBA from a leading B-school (IIMs, ISB, FMS, XLRI, SPJIMR, MDI or comparable) preferred equivalent analytical track record considered.
- Preferred industries: OTT, media and entertainment, microdrama, gaming, consumer internet, subscription platforms, or investment-oriented corporate strategy.

About Bullet And The Opportunity

- Bullet is a microdrama entertainment platform backed by ZEE Entertainment, combining episodic content, technology, consumer analytics and digital monetization.
- We need a hands-on analytical business partner who can move from raw data to investor-grade recommendations. This is not a traditional MIS-only reporting position.

Business strategy and investor intelligence

- Evaluate growth quality, scalability, unit economics, capital efficiency, operating leverage, cash burn and runway.
- Build investor-grade operating models, management dashboards, business forecasts, and board-ready analytical narratives.
- Assess return on invested capital, content ROI, payback, NPV/IRR where relevant, sensitivity scenarios, and opportunity costs.
- Support market sizing, competitor benchmarking and prioritization of capital across content, marketing, product and technology.

Micro-cohort analytics and consumer intelligence

- Construct granular cohorts by acquisition channel, campaign, geography, language, device, first-watch behavior,



genre preference and subscription status.
- Analyze D1/D3/D7/D14/D30 retention, episode progression, binge behavior, churn, propensity to pay and cohort-level contribution.
- Estimate cohort-based LTV and CAC payback using consistent observation windows distinguish observed from projected value.
- Find repeatable high-value micro-segments while checking sample size, selection bias, attribution and statistical reliability.

Micro-investment and content portfolio economics

- Treat individual shows, campaigns and customer cohorts as measurable investment units.
- Build show-level models incorporating production, licensing, localization, marketing, distribution and other attributable costs.
- Evaluate incremental revenue, contribution, payback and marginal return recommend scale, pause, restructure or discontinue decisions.
- Compare content performance across languages, genres and episodes using completion, next-episode conversion, monetization and retention.

Data, SQL, BigQuery and reporting

- Independently write SQL with joins, CTEs, window functions, date logic and performance-conscious BigQuery queries.
- Join user, session, event, acquisition, subscription, advertising and payment data into trusted analytical views.
- Perform funnel analysis, anomaly investigation, reconciliation, experiment analysis and data quality validation.
- Build repeatable dashboards in Looker Studio, Power BI, Tableau or equivalent.

Advanced Excel and financial modelling

- Develop driver-based forecasts, cohort models, subscription and ad revenue models, and budget-versus-actual analyses.
- Demonstrate PivotTables, Power Query, XLOOKUP, SUMIFS, dynamic arrays, sensitivity tables and auditable assumptions.
- Understand CAC, LTV, ARPU, ARPPU, churn, gross/contribution margins, cash flow and payback.

Growth, monetization and AI literacy





- Analyze activation, onboarding, retention, subscription trial-to-renewal conversion, ad yield, fill rates and acquisition incrementality.
- Use ChatGPT, Gemini, Claude or comparable approved tools for research, SQL drafting, spreadsheet automation and analytical synthesis.
- Understand prompt engineering, LLM limitations, hallucination checks, confidentiality and responsible handling of business data.
- Follow AI applications in content production, audience intelligence, localization and personalization.

Stakeholder ownership and success outcomes

- Partner with founders, growth, content, finance, product, engineering and analytics leadership.
- Communicate the business question, evidence, limitations, recommended action, expected economics and success measure.
- Success means faster decisions, reliable cohort economics, improved allocation of investment and measurable commercial outcomes.

Mandatory Vs Preferred

- Mandatory: hands-on SQL, BigQuery, advanced Excel, cohort analysis, financial modelling, commercial reasoning, AI-tool fluency and clear communication.
- Preferred: top B-school MBA, OTT/media experience, board/investor reporting, Python/Pandas and visualization platforms.
- Strong analytical execution and ownership matter more than pedigree alone.

How to apply for this opportunity?

- Step 1: Click On Apply! And Register or Login on our portal.
- Step 2: Complete the Screening Form & Upload updated Resume
- Step 3: Increase your chances to get shortlisted & meet the client for the Interview!

About Uplers: Our goal is to make hiring reliable, simple, and fast. Our role will be to help all our talents find and apply for relevant contractual onsite opportunities and progress in their career. We will support any grievances or challenges you may face during the engagement. (Note: There are many more opportunities apart from this on the portal. Depending on the assessments you clear, you can apply for them as well).

So, if you are ready for a new challenge, a great work workplace, and an opportunity to take your career to the next level, don't hesitate to apply today. We are waiting for you!

📌 Business Analyst | Microdrama, short video, OTT (Mumbai)
🏢 Uplers
📍 Mumbai