Business Intelligence Developer and Data Engineer

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