BI Analyst

Oscar Technology; Cambridge; Hybrid; GBP 40,000 - 55,000; Full time

Job summary

A leading data consultancy in Cambridge seeks a Business Intelligence (BI) Analyst to help clients optimize their CRM and business data through insights. Ideal candidates will have strong SQL skills, experience with BI tools like Power BI, and the ability to communicate effectively with non-technical stakeholders. The role offers a competitive salary and the flexibility of hybrid working arrangements.

Benefits

Competitive salary

Performance-based bonus

25 days holiday

Hybrid/remote-first working

Dedicated personal development budget

Qualifications

• 2 years' experience in a BI or analytics role.
• Experience querying large, complex datasets.
• Comfortable in a client-facing environment.

Responsibilities

• Gather and interpret business requirements.
• Design and deliver dashboards using BI tools.
• Translate data into actionable insights.

Skills

Advanced SQL

Communication skills

Experience with BI tools

Familiarity with CRM platforms

Python

Tools

Power BI

Tableau

SQL Server

Snowflake

Google Data Studio

Job description

Social network you want to login/join with:

Job Title: Business Intelligence (BI) Analyst

Location: Cambridge (2 days on-site)

About Us

We're a fast-growing data consultancy helping forward-thinking clients transform their customer engagement through intelligent use of CRM platforms and AI. We specialise in building integrated data ecosystems that drive smarter business decisions, better customer insights, and measurable ROI.

Our clients range from scaling SaaS startups to global enterprises across sectors like retail, finance, technology, and healthcare. We work at the intersection of data, automation, and customer intelligence.

As we scale, we're looking for a talented BI Analyst to join our analytics team and help our clients extract true business value from their data.

The Role

As a BI Analyst, you will play a critical role in helping our clients understand and optimise their CRM and business performance through data-driven insights. You'll work closely with client stakeholders, CRM specialists, and data engineers to develop scalable dashboards, uncover trends, and turn data into action.

This is a great role for someone who's passionate about business intelligence, CRM systems, AI integration, and delivering consultancy-style impact.

Key Responsibilities

• Gather and interpret business requirements from clients and internal stakeholders
• Design and deliver interactive dashboards and reports using tools like Power BI, Tableau, or Looker
• Query and manipulate data using SQL (and ideally DAX or Python)
• Collaborate with data engineers to ensure clean, reliable, and well-modelled data pipelines
• Translate CRM and behavioural data into actionable insights to support marketing, sales, and customer success
• Build KPIs, performance trackers, segmentation models, and churn/retention reporting
• Work on AI-integrated BI projects (e.g. predictive churn, lead scoring, customer clustering)
• Create documentation, user guides, and training materials for clients
• Present findings and recommendations to senior client stakeholders

Tech Stack You'll Work With

• BI Tools: Power BI, Tableau, Looker, Google Data Studio
• Data Warehousing: Snowflake, BigQuery, Redshift, SQL Server
• CRM Systems: Salesforce, HubSpot, Dynamics , Zoho
• ETL Tools: dbt, Fivetran, Talend, Alteryx

What We're Looking For

• 2 years' experience in a BI, data analyst, or similar analytics role
• Advanced SQL skills and experience querying large, complex datasets
• Experience with at least one major BI tool (Power BI, Tableau, Looker, etc.)
• Strong communication skills - you can explain data to non-technical stakeholders
• Familiarity with CRM platforms and understanding of customer lifecycle metrics
• Comfortable working in a fast-paced, client-facing environment
• Experience in a consultancy or agency environment
• Python for data wrangling or basic machine learning use cases
• Familiarity with AI/ML concepts (classification, regression, clustering, NLP)
• Exposure to dbt or other data transformation tools
• Experience with A/B testing, segmentation analysis, or forecasting models
• Knowledge of marketing or sales analytics (e.g. attribution, funnel metrics)

What They Offer

• Competitive salary performance-based bonus
• 25 days holiday your birthday off
• Hybrid/remote-first working with flexibility
• Dedicated personal development budget
• Laptop, tools & software provided
• Exposure to cutting-edge AI and CRM integration projects
• Work with a smart, collaborative team who care about making data meaningful

Apply now or reach out to our team for a chat.

Oscar Associates (UK) Limited is acting as an Employment Agency in relation to this vacancy.

To understand more about what we do with your data please review our privacy policy in the privacy section of the Oscar website.