Salary: £42,000 - 70,000 per year
Requirements
- Deep expertise in Microsoft Power BI, including Desktop, Service, gateways and workspace management, with strong DAX and data modelling skills.
- Solid experience working with large and complex data sets, writing optimised queries and understanding performance impacts.
- Strong understanding of data warehousing concepts, star schemas, ETL/data ingestion and relational database systems such as SQL Server or Azure SQL.
- Experience with role-based security and row-level security in Power BI.
- Good visualisation design sense, including UX best practices for dashboards, filters, slicers, and mobile versus desktop views.
- Familiarity with cloud platforms such as Azure and Power BI Premium or Embedded.
- Power BI or data analytics certification, such as Microsoft Certified: Data Analyst Associate, is advantageous.
Responsibilities
- Engage with business stakeholders and Business Analysts to gather and clarify reporting requirements, KPIs, data sources and user stories.
- Develop and maintain Power BI dashboards, reports and scorecards that deliver actionable insights to users across operational, tactical and executive levels.
- Build robust data models in Power BI, including tables, relationships, hierarchies and measures using DAX, with performance optimisation and data refresh strategy.
- Ensure data accuracy, consistency and integrity by reconciling Power BI outputs with source systems, data warehouses and business rules.
- Implement role-based security in the Power BI service, including row-level security and workspace permissions.
- Apply visual design best practices, including layout, interactivity, filter and slicer design, performance considerations, drill-throughs and mobile-ready views.
- Work with the Data Engineering team to ensure data pipelines, data marts and warehouses deliver appropriate and performant data.
- Monitor and optimise report performance, including data refresh, query performance, caching and incremental loads.
