BI Analyst - MS Stack

Insight Talent Partners; Manchester; Hybrid; GBP 55,000 - 60,000; Full time

Benefits offered by this job

Pension matched 4.5%

Private medical & dental cover (Vitaly

Life assurance 4× salary

23 days annual leave (up to 25)

Buy/sell 3 days annual leave

Festive close‑down

Annual company events

Hybrid work 2 days from home

Cycle to work scheme

Maternity policy

Eye test £50 for new glasses

Job summary

Insight Talent Partners partners with a central Manchester professional services organisation to hire a BI Analyst with strong Power BI and Microsoft Fabric capabilities. This role offers ownership of data modelling, Fabric development, and modernising a complex reporting estate.

You will consolidate SQL scripts and reporting logic into governed analytics assets, collaborating with the Analytics Manager to establish data standards and governance within a Data & Analytics Centre of Excellence.

Qualifications

• Strong Power BI development and governance.
• Experience with data modelling and DAX.
• Ability to translate requirements into scalable analytical solutions.

Responsibilities

• Optimise and rationalise the Power BI estate with governance and performance improvements.
• Design and build Fabric data solutions including Lakehouses and Dataflows.
• Create shared semantic models and reusable datasets for consistent reporting.

Skills

Power BI

DAX

Data Modelling

SQL

Tools

Microsoft Fabric

Snowflake

Databricks

Synapse

Job description

£55-60k basic salary + 5% quarterly bonus

Hybrid working (3 days in office, 2 from home)

We are supporting a well‑established professional services organisation based in central Manchester in their search for a BI Analyst with strong Power BI and Microsoft Fabric capability. This is an integral hire within a growing analytics function, offering genuine ownership of data modelling, Fabric development, and the modernisation of a complex reporting estate.

The successful candidate will play a key role in consolidating disparate SQL scripts, datasets, and reporting logic into governed, reusable analytical assets. You will work closely with the Analytics Manager and wider technical teams to establish best practice, shape data standards, and support the organisation’s journey toward a more mature Data & Analytics Centre of Excellence.

Benefits Package

• Pension contribution matched up to 4.5%
• Private medical, optical, audiological and dental cover (Vitality)
• Life assurance (4× basic salary)
• 23 days annual leave, rising with service (up to 25)
• Buy or sell up to 3 days annual leave
• Festive close‑down without using annual leave
• Annual company events
• Extended lunch break for gym‑goers
• Hybrid working (2 days from home)
• Cycle to work scheme
• Competitive maternity policy
• Eye test and £50 contribution towards new glasses

Key Responsibilities

• Optimise and rationalise the existing Power BI estate, improving governance, performance, and maintainability.
• Design and build data solutions within Microsoft Fabric, including Lakehouses, Warehouses, Pipelines and Dataflows.
• Create shared semantic models and reusable datasets to support consistent reporting across the business.
• Consolidate SQL scripts, business logic and reporting processes into governed analytical datasets.
• Establish and promote data modelling standards, Power BI best practices and governance frameworks.
• Improve report performance through optimisation of data models, DAX, refresh processes and source queries.
• Support data quality initiatives and ensure consistency of business logic across reporting assets.
• Collaborate with analysts and data engineers to implement reporting standards and governance processes.
• Mentor junior team members and manage stakeholder communication with a high degree of independence.
• Contribute to the development and execution of the wider Data & Analytics Strategy.

Technical Requirements

• Strong Power BI development, data modelling and DAX skills.
• Hands‑on experience with Microsoft Fabric, or transferable experience from platforms such as Snowflake, Databricks or Synapse.
• Understanding of Lakehouse and warehouse concepts, medallion architecture, pipelines, dataflows and dev/test/prod environments.
• Experience building shared semantic models and reusable datasets.
• Solid grounding in dimensional modelling, relational databases and ETL/ELT principles.
• Ability to gather requirements and translate them into scalable analytical solutions.

Personal Qualities

• Analytical and methodical, with strong attention to detail.
• Confident communicator able to engage and influence stakeholders.
• Proactive, organised and able to prioritise effectively.
• Curious, innovative and enthusiastic about modernising analytics.
• Comfortable mentoring others and promoting best practice.
• Microsoft Fabric or Power BI certifications.
• Experience with Azure Data Factory, Synapse, Databricks, Purview, REST APIs or CI/CD.
• Familiarity with Agile methodologies, Azure DevOps or Jira.