BI & Data Engineer – Power BI, SQL & Azure

KEY APPOINTMENTS (UK) LTD; Weston-super-Mare; Hybrid; GBP 65,000 - 90,000; Full time

Benefits offered by this job

Hybrid working

Generous holiday allowance

Pension

Private health insurance

Discretionary bonus scheme

Career development through the 2M Acad

Mental health support

Team-building activities

Job summary

2M Group of Companies seeks a Business Intelligence Developer and Data Engineer to transform complex data into actionable insights. You will build Power BI reports and robust data pipelines, leveraging SQL, Python and Spark where needed, across data warehouses, lakehouses and data lakes.

The role demands strong BI and data engineering fundamentals, good communication with stakeholders, and the ability to own technical problems while working in a hybrid setup with travel across group locations.

Qualifications

• Strong Power BI experience.
• Solid SQL skills.
• Experience with Microsoft Fabric or a comparable modern data platform.
• Understanding of data modelling and data engineering principles.
• Experience developing and maintaining data pipelines.
• Ability to communicate with technical and non-technical stakeholders.

Responsibilities

• Developing and maintaining Power BI reports, dashboards and semantic models.
• Designing and improving ETL and ELT pipelines using SQL, Python and PySpark or Spark.
• Working with Microsoft Fabric, Azure data services, data warehouses, lakehouses and data lakes.
• Translating business requirements into practical BI and data solutions.
• Building robust data models and improving data quality, documentation and governance.
• Helping consolidate reporting and data sources onto a single governed platform.
• Using version control and DevOps practices to support reliable development and deployment.
• Exploring AI, ML and automation use cases in BI.
• Investigating and resolving complex BI, data and reporting issues.

Skills

Power BI

SQL

Microsoft Fabric

Data modelling

Data pipelines

Python

PySpark

Spark

Azure data services

DevOps

Tools

PySpark

Spark

Azure Data Services

Microsoft Fabric

DevOps practices

Job description

2M Group of Companies seeks a Business Intelligence Developer and Data Engineer to transform complex data into actionable insights. You will build Power BI reports and robust data pipelines, leveraging SQL, Python and Spark where needed, across data warehouses, lakehouses and data lakes.

The role demands strong BI and data engineering fundamentals, good communication with stakeholders, and the ability to own technical problems while working in a hybrid setup with travel across group locations.