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.
#J-18808-Ljbffr