BI Data Analyst

PEI Group; City Of London; On-site; GBP 35,000 - 55,000; Full time

Job summary

A leading business intelligence company is seeking a skilled Business Intelligence Data Analyst in London. The role involves utilizing SQL, DataBricks, and Tableau to provide analytics insights that support business decisions across various teams. Ideal candidates will have a STEM degree and experience in data analysis, with a focus on enhancing data quality and delivering tailored insights.

Qualifications

• Strong proficiency in SQL for data extraction and analysis.
• Experience with DataBricks or similar datalake technology.
• Knowledge of Google Analytics 4 and Tableau is a plus.

Responsibilities

• Develop reports and dashboards using BI software.
• Conduct in-depth analysis of web analytics data.
• Collaborate with cross-functional teams to identify trends.

Skills

SQL

DataBricks

Tableau

Google Analytics

Statistical analysis

Education

Degree in Science, Technology, Engineering & Mathematics (STEM)

Tools

Google Data Studio

Power BI

Job description

About The Role

We are seeking a skilled and enthusiastic Business Intelligence Data Analyst to join our team in London. Main skills will be to focus on SQL, DataBricks cloud and Tableau for visualisation. As a key member of our Business Intelligence team, you will play a crucial role in providing analytics insights to support business decisions across sales, marketing, editorial, and product management teams globally. You will work closely with marketing, sales, product, web developers, UX designers, and stakeholders to ensure effective and insightful reporting. Additionally, you will collaborate with data engineering and technical teams to enhance data quality and deliver tailored insights aligned with our business objectives.

• Work with the BI Team colleagues to develop reports, dashboards, and visualisations using BI software (Tableau, Power BI etc) to monitor website performance and track progress towards goals.
• Utilise Google Analytics, GA4 and Looker / Google Data Studio, to provide scheduled and ad hoc reporting to the business.
• Collaborate with our engineers to define and validate the web analytics required for GA streams into DataBricks (our data lake platform).
• Work with cross-functional teams to identify trends, patterns, and opportunities for website optimisation and user experience improvements.
• Conduct in-depth analysis of web analytics data to gain insights into commercial performance, conversion, user journeys, and customer behaviour.
• Work with Data Engineering and technical teams to continuously improve data quality and ensure accurate and reliable data collection.
• Support the management and delivery of business intelligence initiatives, working closely with the department head.
• Stay up-to-date with industry trends and best practices in website analytics, and recommend new tools and techniques to enhance data analysis capabilities.

About You

Experience and Skills:

• Preferred degree preferably in a Science, Technology, Engineering & Mathematics (STEM) field.
• Strong proficiency in SQL for data extraction, manipulation, and analysis.
• Knowledge of DataBricks cloud or similar datalake technology is a plus
• Experience in Tableau would be a plus
• Experience in Google Analytics 4 / Adobe Analytics, or similar, Google Tag Manager, and Google Data Studio / or Looker or similar.
• Experience with statistical analysis and experimentation methodologies (e.g., A/B testing, multivariate testing).
• Understanding of data science techniques, such as predictive modelling and machine learning, is beneficial but not required.

This role would suit someone who is

• Excellent analytical skills and a track record of delivering tailored business insights.
• Good communication and collaboration skills with the ability to work closely with business stakeholders.
• Self-motivated and eager to learn and understand all aspects of the business.
• If you are a detail-oriented and analytical individual with a passion for leveraging data to drive business growth and improve user experiences, we invite you to apply for this exciting opportunity.

About Us

Who we are:

PEI Group is a subscriber-focused business intelligence company. With our multi-talented global team of over 490 people, spread across EMEA, USA & Asia, our purpose is to inform and connect investment professionals across global, specialised markets. We identify specific high growth, high value investment sectors and themes where deep insight, strong market relationships and active capital flows are critical for success.

What we do:

PEI Group provides industry-leading journalism, data, and market insight to subscribing clients via a wide portfolio of specialist brands supported by our robust and scalable digital publishing, analytics, and database platform. We also track the firms and individuals who shape markets and bring client-communities together to enable knowledge sharing, profile building and relationship development through professional networks and events. Wherever our markets are active – in New York, Los Angeles, Tokyo, Sydney, Hong Kong, Singapore, London and elsewhere – PEI is hard at work examining crucial market forces and shifting investment themes, identifying active investors and their capital allocations, and scanning ahead for regulatory changes, new compliance requirements and other risk factors.

At PEI we value diverse talent and welcome applications from everyone – regardless of background. We are an equalopportunity employer and our inclusive culture at PEI is reflected in every stage of the recruitment journey. Please inform us at initial stages of the recruitment process if you require any reasonable adjustments and we can accommodate this.

PEI Group supports flexible working arrangements, and we welcome career returners.