Senior BI & Analytics Architect | Power BI, SQL, Azure

Harnham; West Midlands; Hybrid; GBP 60,000 - 70,000; Full time

Benefits offered by this job

Hybrid working (3 days onsite)

Career progression opportunities

Exposure to enterprise-scale analytics

Job summary

Harnham is recruiting a Senior BI Developer / Senior Data Analyst for a leading UK automotive parts business undergoing a data and reporting transformation. The role sits between BI development and commercial analytics, blending technical delivery with stakeholder engagement.

You will design and maintain Power BI dashboards, build semantic models, and drive adoption of self-service analytics across Finance, Sales, Marketing and Operations. Hybrid role with 3 days onsite at client sites.

Qualifications

• 5+ years' experience in BI, Data Analytics, or BI Development.
• Strong Power BI experience including DAX, Power Query, Data modelling and Performance optimisation.
• Strong SQL skills.
• Experience designing dimensional data models and semantic layers.
• Strong stakeholder management and communication skills.
• Ability to translate business requirements into scalable reporting solutions.

Responsibilities

• Design, develop and maintain Power BI dashboards and reporting solutions.
• Build scalable semantic models and reusable datasets.
• Improve and automate existing reporting processes.
• Develop dimensional models and reporting structures.
• Create DAX measures, Power Query transformations, and KPI frameworks.
• Analyse commercial and operational performance and identify opportunities for improvement.
• Work closely with Finance, Sales, Marketing, Commercial, and Operations teams.
• Gather requirements and identify reporting gaps.
• Present insights and recommendations to senior stakeholders.
• Help drive adoption of self-service analytics across the business.
• Support development of the Microsoft Fabric platform.
• Contribute to Lakehouse, Warehouse and semantic model design.
• Support ETL / ELT processes and data integration improvements.

Skills

Power BI

DAX

Power Query

Data modelling

Performance optimisation

SQL

Stakeholder management

Communication skills

Requirements translation

Microsoft Fabric

Azure data platform

Retail/Distribution experience

Mentoring

Tools

Microsoft Fabric

Azure

Job description

Harnham is recruiting a Senior BI Developer / Senior Data Analyst for a leading UK automotive parts business undergoing a data and reporting transformation. The role sits between BI development and commercial analytics, blending technical delivery with stakeholder engagement.

You will design and maintain Power BI dashboards, build semantic models, and drive adoption of self-service analytics across Finance, Sales, Marketing and Operations. Hybrid role with 3 days onsite at client sites.