Data Analyst

The role

The Data Analyst is a vital role within the Blenheim Chalcot portfolio and Oakbrook. The Data Analyst will support the growth of the consumer lending business by providing data-driven insights into marketing performance across direct and third-party aggregator channels. This role will be responsible for building and maintaining dashboards (using SQL and Power BI), tracking campaign effectiveness, analyzing customer acquisition and conversion trends, and helping optimize marketing spend and strategy. The role will also involve regular performance monitoring of aggregator partners and internal loan products to ensure channel efficiency and product-market fit.

Key Responsibilities :

Campaign & Channel Performance Analysis

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

Aggregator Performance Monitoring

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

Product Performance Tracking

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

Dashboard Development & Reporting

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

Customer Journey & Funnel Analysis

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

Marketing Data Governance

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

About you

The ideal candidate will have a track-record in delivering results in a fast-moving business and hence be comfortable with change and uncertainty. Excellent stakeholder management experience is essential to being successful in this role.

Technical and or professional experience required to be successful in the role:

Technical Skills

 SQL (Advanced)

• Ability to write complex queries, joins, subqueries, CTEs.
• Experience querying relational databases (e.g. Snowflake, Big Query, Redshift, etc.).

Power BI (or similar BI tools like Tableau/Looker)

• Dashboard design and maintenance.
• Drill-down reporting and KPI visualization.
• DAX for advanced calculations.

Excel/Google Sheets

• Pivot tables, VLOOKUP/XLOOKUP, array formulas.
• Used for ad-hoc analysis and data validation.

Data Cleaning & Preparation

• Proficient in cleaning raw datasets and ensuring data integrity.
• Familiarity with tools like Alteryx or Python/Pandas (desirable but optional).

Campaign & Attribution Analysis

• Understanding of UTM tracking, campaign tagging, attribution models (first-touch, last-touch, multi-touch).
• Familiarity with Google Analytics or Adobe Analytics.

A/B Testing & Experimentation

• Analyzing test vs. control group outcomes using statistical significance methods.

CRM & Marketing Platform Reporting

• Experience working with data from marketing platforms like Google Ads, Meta, email/SMS platforms, or third-party aggregators.
• Understanding lead-to-loan tracking across multiple systems.

Data Governance Awareness

• Familiarity with GDPR compliance, data minimization, and handling personally identifiable information (PII).

Non-Technical Skills 

Commercial Awareness

• Strong understanding of customer acquisition in a lending context (cost of funds, bad rate, ROI per channel).
• Ability to link marketing performance to business outcomes.

Stakeholder Communication

• Can translate data insights into non-technical language for marketing, finance, or compliance teams.
• Comfortable presenting in team or leadership meetings.

Attention to Detail

• Spotting inconsistencies, anomalies, or data quality issues before they go live.

Problem Solving

• Able to investigate issues across data pipelines, conversion metrics, or lead quality.

Time Management & Prioritization

• Can balance recurring reporting with ad hoc requests and longer-term projects.

Curiosity & Proactivity

• Continuously looks for trends, anomalies, or areas of improvement even without being asked.

Collaboration

• Works well with marketing, product, risk, and data engineering teams to resolve dependencies or cross-functional asks.

 About Blenheim Chalcot

Blenheim Chalcot is one of the leading venture builders in the world. We have been building exciting and disruptive businesses for over 26 years across sectors including FinTech, EdTech, GovTech, Media, Sport, Charity and more. These companies are all GenAI enabled and are some of the most innovative companies in the UK and increasingly around the world.

The BC team in India has been instrumental to the growth and success of Blenheim Chalcot. Established in 2014, Blenheim Chalcot India serves as a pivotal launchpad for those aiming to make a difference in the realm of innovation and entrepreneurship.

Blenheim Chalcot India is driven by a mission to empower visionaries to lead, innovate, and build disruptive solutions. We support our diverse portfolio of ventures and create impactful solutions that shape global trends. We provide a range of services to help new business get off the ground, including technology, growth (marketing and sales), talent, HR, finance, legal and tax, plus so much more!

One of our FinTech ventures, Oakbrook, is scaling fast and we’re looking to hire high energy, motivated and curious talent to support them on that journey!

About Oakbrook

Founded in 2011, Oakbrook has united experts in consumer lending, advanced analytics, and innovative technology, all driven by the belief that consumer lending can be more personalized and customer centric. The collective mission across our three companies is to simplify and tailor the borrowing experience. By leveraging cutting-edge technology, data, and analytics, we provide fairer access to credit that reflects each customer’s unique circumstances, moving beyond outdated models that rely on averages and backward-looking assessments. Our goal is to create a more inclusive, individualized approach to lending.

What we can offer you

• Be part of the World’s Leading Digital Venture Builder
• Have the opportunity to be a part of and learn from the incredible diverse talent in BC
• Be exposed to the right mix of challenges, within a culture that promotes continuous learning and development and opportunity to work with Gen AI
• A fun and open, if a little cricket obsessed, atmosphere – we own the Rajasthan Royals IPL team!
• 24 days of annual leave &10 public holiday days
• Private Medical for you and your immediate family & Life Insurance for yourself

Important

At Blenheim Chalcot, we strive to create an environment where differences are not only accepted but greatly valued; where everyone can make the most of their capabilities and potential. We promote meritocracy, competence and the sharing of ideas and opinions. We are driven by data and believe the diversity, agility, generosity, and curiosity of our people is what sets us apart as an organization. Our strong commitment to a culture of inclusion is evident through our constant focus on recruiting, developing and advancing individuals based on their skills and talent.