Business Intelligence Developer and Data Engineer

KEY APPOINTMENTS (UK) LTD; Weston-super-Mare; On-site; 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

Business Intelligence Developer and Data Engineer

Location: Hybrid (Runcorn) with travel across the North West and Yorkshire

Job type: Full‑time, permanent

Are you passionate about turning complex data into meaningful insight that helps businesses make better decisions?

We are recruiting on behalf of the 2M Group of Companies for a Business Intelligence Developer and Data Engineer. This is a hands‑on role for someone with strong Power BI and SQL skills who can build high‑quality reporting and data solutions, solve complex problems and work confidently across business intelligence and data engineering.

What you’ll be doing

• Developing and maintaining Power BI reports, dashboards and semantic models
• Designing and improving ETL and ELT pipelines using SQL, Python and, where appropriate, 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 to consolidate reporting and data sources onto a single governed platform
• Using version control and DevOps practices to support reliable development and deployment
• Exploring practical uses of AI, machine learning and automation
• Investigating and resolving complex BI, data and reporting issues

What we’re looking for

• Strong Power BI experience
• Confident SQL skills
• Experience with Microsoft Fabric or a comparable modern data platform
• A solid understanding of data modelling and data engineering principles
• Experience developing and maintaining data pipelines
• Strong analytical and creative problem‑solving skills
• Excellent attention to detail
• The confidence to take ownership of technical problems and work independently
• The ability to communicate effectively with technical and non‑technical stakeholders

It would be beneficial if you also have

• Knowledge of data modelling practices, including star and snowflake schemas and normalisation
• Experience with Python, PySpark or Spark, Azure, DevOps or Microsoft Dynamics 365 Finance and Operations
• An understanding of business operations
• A full driving licence, as travel to Group locations will be required

What’s on offer

• Hybrid working and flexible hours
• Generous holiday allowance, paid volunteering and enhanced maternity and paternity leave
• Generous contributory pension, death-in-service cover and optional private health insurance
• Discretionary companywide bonus scheme
• Career development through the 2M Academy, including mentoring, apprenticeships and leadership programmes
• Mental health, menopause and counselling support
• Team-building activities, reservist support, complimentary refreshments and a flu vaccine