Data Analyst

Job Description

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 (eg 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 (eg 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 we'll with marketing, product, risk, and data engineering teams to resolve dependencies or cross-functional asks. 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