Business Intelligence Developer and Data Engineer

Key Appointments (UK) Ltd; Runcorn; Hybrid; GBP 60,000 - 90,000; Full time

Benefits offered by this job

Hybrid working

Generous holiday allowance

Contributory pension

Private health insurance

Discretionary bonus

Career development

Mental health support

Team-building activities

Job summary

2M Group of Companies is seeking a highly motivated Business Intelligence Developer and Data Engineer in the Cheshire area. This hybrid, permanent role focuses on turning complex data into clear insights through robust Power BI reporting and scalable data pipelines.

You will build semantic models, work with Azure data services and Microsoft Fabric, and translate business needs into practical BI solutions. A hands-on role requiring ownership, collaboration with stakeholders, and a proactive

Qualifications

• 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.

Responsibilities

• 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.

Skills

Power BI

SQL

Data modelling

Data engineering

Data pipelines

Tools

Python

PySpark

Spark

Azure data services

Microsoft Fabric

Job description

Business Intelligence Developer and Data Engineer

Cheshire

• TBC,
• Permanent / Full Time

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