Senior Power BI Developer

Advanced Resource Managers Ltd; London; Hybrid; GBP 50,000 - 60,000

Job description

Senior Power BI Developer
Permanent
Hybrid (1-2 days per week in London or Portsmouth offices)
£50 - 60K basic + benefits
Do you have a background in Power BI development and reporting, along with SQL, DAX + Power Query experience and ETL/ELT tools inc SSIS or Azure Data Factory in an MSP environment?

Responsible for:
Designing, developing, and optimising Power BI dashboards and reports to provide business insights. Working closely with stakeholders to understand data needs, integrate data sources, and build robust BI solutions that support decision-making.

Scope:
The focus of this role is to work with key business stakeholders within IT, and across the business to implement Power BI solutions and a CoE (Community of Excellence). This role will initially be focused on the processes within Finance, Lead to Cash and Hire to Retire.

Responsibilities:

• Design, develop, and maintain interactive Power BI reports and dashboards.
• Implement DAX (Data Analysis Expressions) for complex calculations and measures.
• Create visually appealing, user-friendly data visualizations for business users.
• Develop data models in Power BI using Power Query (M language).
• Optimise data transformations, relationships, and performance tuning.
• Connect Power BI with Azure Synapse, and APIs.
• Write advanced SQL queries for data extraction, transformation, and aggregation.
• Work with Stored Procedures, Views, and Query Optimisation.
• Optimize Power BI report performance (reducing load times, improving DAX efficiency).
• Ensure data governance, compliance, and security best practices are followed.
• Work closely with business analysts, data engineers, and stakeholders to define reporting needs.
• Present insights and recommendations based on Power BI dashboards.
• Provide Power BI training and best practices to business users and junior developers.
• Work with Power Automate and Power Apps for process automation.

Essential:

• Bachelor's Degree in Computer Science, Data Science, Information Systems, or a related field.
• Strong experience in Power BI development and BI reporting.
• Practical experience of leading the set up a Centre/Community of Excellence and promoting localized self-serve reporting with Power BI.
• Strong expertise in DAX, Power Query, and SQL.
• Experience with ETL/ELT tools, Synapse Analytics, Azure Data Factory or SSIS.
• Experience in building complex dashboards and performance tuning.
• Good understanding of data modelling, governance, and security.
• Microsoft Certified: Power BI Data Analyst Associate (PL-300).
• Microsoft Certified: Azure Data Fundamentals (DP-900).
• Strong problem-solving skills with attention to detail and the ability to troubleshoot complex data issues.
• Excellent communication and collaboration skills, able to work across teams to deliver solutions that meet business needs.

Desirable:

• Experience of working within an international IT Managed Services company.
• Microsoft Certified: Azure Data Engineer Associate (DP-203).

Some of the benefits include:

• Healthcare and dental insurance.
• Company pension is matched up to 5%.
• 25 days annual leave entitlement plus bank holidays and the option to purchase 5 extra days.
• Life assurance - 4 x annual salary.
• Cycle to work scheme.
• Client prioritises internal development opportunities and offer access to our Udemy training platform with over 5000 training courses.