Power BI Developer — Hybrid, Dashboards & Data Insights

McLaughlin & Harvey Ltd; Bellshill; Hybrid; GBP 42,000 - 60,000; Full time

Benefits offered by this job

Flexible and hybrid working options

Competitive salary and benefits

Career development opportunities

Job summary

McLaughlin & Harvey Ltd is seeking a BI Developer to design, develop and maintain Power BI models, reports and dashboards across multiple sectors. You will write SQL for data preparation, work with the data warehouse, and translate business requirements into technical BI solutions.

The role requires hands-on Power BI, strong DAX and SQL skills, and the ability to collaborate with colleagues across the business while ensuring data quality and security in line with UK GDPR.

Qualifications

• Hands-on Power BI Desktop experience with data modelling and report development.
• Strong knowledge of DAX, measures, filter context and relationships.
• Solid SQL development skills, including joins, aggregations and window functions.
• Understanding of dimensional modelling with facts and dimensions and star schemas.
• Experience with relational databases and data warehouse environments.
• Attention to detail and ability to validate data accuracy and consistency.
• Able to translate business requirements into technical solutions and communicate clearly.
• Good collaboration within a team and with non-technical stakeholders.

Responsibilities

• Design, develop and maintain Power BI semantic models, star schemas and DAX measures.
• Create clear Power BI reports and dashboards; enhance existing solutions.
• Write and optimise SQL for data prep, transformation and reporting.
• Gather requirements from across the business and translate into technical solutions.
• Present findings clearly to technical and non-technical colleagues.
• Test reports and data solutions; validate against source systems.
• Investigate and resolve data quality and performance issues.
• Document BI solutions, data models and reporting processes.
• Follow source control and deployment processes before releasing to production.
• Handle sensitive data securely in line with company policies and UK GDPR.
• Support in-house web applications and collaborate with IT/development teams.

Skills

Power BI

DAX

SQL

Data modelling

Relational databases

Data warehouse

Attention to detail

Communication skills

Requirements gathering

Team player

Tools

Git & Azure DevOps

Job description

McLaughlin & Harvey Ltd is seeking a BI Developer to design, develop and maintain Power BI models, reports and dashboards across multiple sectors. You will write SQL for data preparation, work with the data warehouse, and translate business requirements into technical BI solutions.

The role requires hands-on Power BI, strong DAX and SQL skills, and the ability to collaborate with colleagues across the business while ensuring data quality and security in line with UK GDPR.