Data Analyst Job in Blenheim Chalcot

Position: Data Analyst

Location: Mumbai, India
Division: Data & Analytics / Marketing

About the Role

As a Data Analyst within the Blenheim Chalcot portfolio and Oakbrook, you will be crucial in driving data-driven insights for our consumer lending business. You will analyze marketing performance across direct and third-party aggregator channels, helping optimize spend and strategy. Your work will involve building and maintaining dashboards (SQL, Power BI), monitoring campaign and product performance, and ensuring channel efficiency.

Key Responsibilities

Campaign & Channel Performance Analysis

• Track and analyze marketing campaigns (paid search, social, email, display, aggregators).
• Measure key conversion metrics: impressions → clicks → applications → approvals → disbursals.
• Identify underperforming campaigns/channels and recommend improvements.

Aggregator Performance Monitoring

• Monitor lead volume, quality, and conversion rates from aggregators (e.g., Clear Score, Compare the Market).
• Benchmark aggregator ROI and provide actionable insights for partner management.

Product Performance Tracking

• Analyze application, approval, and disbursal trends by product type.
• Segment performance by demographics, channel, and credit risk tiers (prime, near-prime, non-prime).
• Identify opportunities for product/pricing optimization.

Dashboard Development & Reporting

• Design and maintain interactive dashboards using SQL and Power BI.
• Ensure data accuracy and real-time performance tracking.
• Present weekly/monthly reports and insights to marketing, finance, and product teams.

Customer Journey & Funnel Analysis

• Analyze drop-off points in the customer journey.
• Collaborate with CRO and UX teams to improve application flows.
• Support A/B testing with data analysis.

Marketing Data Governance

• Ensure campaign tagging and data standards across platforms (GA, CRM, ad networks).
• Collaborate with data engineering on data quality and pipeline improvements.

About You

Technical Skills:

• Advanced SQL skills (complex queries, joins, CTEs) on relational databases (Snowflake, Big Query, Redshift).
• Proficient in Power BI (dashboard design, KPI visualization, DAX calculations).
• Strong Excel/Google Sheets skills (pivot tables, VLOOKUP/XLOOKUP, array formulas).
• Data cleaning and preparation expertise; familiarity with Alteryx or Python/Pandas is a plus.
• Understanding of UTM tracking, campaign attribution models, and analytics platforms (Google Analytics, Adobe Analytics).
• Experience with A/B testing and statistical analysis.
• Familiarity with CRM and marketing platforms (Google Ads, Meta, email/SMS tools).
• Awareness of GDPR and data governance best practices.

Non-Technical Skills:

• Commercial awareness in lending context (customer acquisition cost, ROI, bad debt rates).
• Ability to translate data insights for non-technical stakeholders (marketing, finance, compliance).
• Strong attention to detail and problem-solving mindset.
• Excellent time management balancing regular reporting and ad-hoc analysis.
• Curious and proactive in identifying trends and opportunities.
• Collaborative working style across marketing, product, risk, and data teams.

About Blenheim Chalcot & Oakbrook

Blenheim Chalcot is a world-leading digital venture builder with over 26 years of experience creating disruptive businesses in FinTech, EdTech, GovTech, and more. Our India team plays a vital role in our success, fostering innovation and entrepreneurship since 2014.

Oakbrook, a fast-scaling FinTech venture in our portfolio, leverages advanced analytics and technology to provide personalized consumer lending solutions. We aim to simplify borrowing with fair, data-driven credit access tailored to individual customers.

What We Offer

• Join the world s leading digital venture builder.
• Work with a diverse, talented team in a culture of continuous learning and innovation.
• Opportunity to work on Gen AI-enabled cutting-edge solutions.
• A fun, open, and cricket-enthusiast environment (home of Rajasthan Royals IPL team!).
• 24 days annual leave + 10 public holidays.
• Private medical insurance for you and your family & life insurance coverage.

Our Commitment

We value diversity and inclusion, fostering a culture where everyone s skills and talents can thrive. We recruit, develop, and promote based on merit and competence, driven by curiosity and collaboration. Join us to make an impact in a data-driven, fast-paced environment.