Power BI Developer
Perspective Financial Group Ltd / Group BI
Job Description
We are looking for a technically strong Power BI Developer to join the Central BI team. This role is focused on designing, building, and optimising robust Power BI semantic models, reports, and dashboards, with strong emphasis on financial and business performance data.
The role requires deep hands-on expertise in Power BI development, DAX, data modelling, and SQL, alongside the ability to translate business requirements into scalable, high-quality reporting solutions.
Location: Home-based
Hours: Monday – Friday 9am to 5pm with a one hour break (35 hours)
Salary: Competitive dependant on experience and qualifications. Available upon request.
Please note: any offer of employment is subject to satisfactory criminal record background checks.
Job Requirements
Technical Skills
- Strong commercial experience (3+ years) developing Power BI reports and semantic models in a business environment.
- Advanced Power BI skills, including DAX, data modelling, filter context, row context, and performance optimisation.
- Strong SQL skills for data querying, validation, and data analysis.
- Strong understanding of star schema design and data modelling best practices for BI.
- Experience working with financial data, metrics, and KPI reporting.
- Ability to troubleshoot data, model, and visual-level issues independently.
Other Skills
- Strong analytical and problem-solving skills, with the ability to work directly with stakeholders and turn requirements into technical solutions.
- Excellent attention to details.
- Ability to present findings and technical concepts to non-technical stakeholders.
- Ability to stay self-motivated and ability to manage multiple priorities in a fast-paced environment.
- Continuous desire to develop skills & competence
Desirable
- Experience with Power BI Service, deployment, workspace & audience management, security, and governance.
- Understanding of data warehousing concepts and upstream data structures.
Job Responsibilities
- Design, build, and maintain Power BI semantic models, dashboards, and reports.
- Develop complex DAX measures, calculations, and logic to support business and financial reporting.
- Create and maintain efficient data models, including relationships, hierarchies, and reusable reporting structures.
- Work with stakeholders to gather requirements and translate them into robust technical reporting solutions.
- Collaborate with data engineers and other subject matter experts in the company to deliver effective BI solutions
- Use SQL to validate source data, investigate issues, and support report development and troubleshooting.
- Perform detailed analysis of financial and operational data, including trend, variance, and exception analysis.
- Optimise report performance, usability, and maintainability in line with Power BI best practice.
- Identify and drive improvements in reporting standards, data quality, and BI development approaches.
- Develop & maintain documentation for reports, datasets, and data transformation logic.
Due to the nature of the business, the role may also include additional responsibilities considered reasonable.
Job Benefits
25 days holiday (rising with length of service) plus Bank Holidays, Birthday Leave, Holiday Purchase Scheme, Life Assurance, Pension, Corporate Eyecare and Extras Discount shopping discounts.
