Business Intelligence Developer and Data Engineer

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

Are you passionate about turning complex data into meaningful insight that helps businesses make better decisions?, * 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

• 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