Data Analyst (Power BI & Dashboard Design)

Job PurposesThe Data Analyst (Power BI & Dashboard Design) designs and builds dashboards that people actually want to use, for internal business teams and for our NGO and charity clients. The role turns data from our Azure Synapse data warehouse and INSIGHT's proprietary Azure SQL databases into clear, well-designed Power BI reports and web-portal visualisations, working directly with stakeholders from first conversation to final release.The role owns the full dashboard lifecycle: understanding the business question, shaping the data model, designing the layout and user journey, validating the numbers, securing access with row-level security, documenting the work, and supporting users after launch.Key ResponsibilitiesThe Data Analyst will be responsible to:Dashboard design & development (core)Design and build Power BI dashboards and reports with excellent UI and UX: clear layout, consistent visual style, intuitive navigation, and the right chart for each question.Build client-facing dashboards for NGO and charity clients, with the polish and clarity expected of an external product.Support data visualisation on web portals, such as embedded Power BI reports or charts delivered with the web team.Sketch wireframes or mock-ups (e.g. in PowerPoint or as a Power BI prototype) and agree them with stakeholders before building.Develop efficient data models (star schema, relationships) and DAX measures that keep reports accurate and fast.Build interactive features such as drill-through, bookmarks, tooltips and field parameters.Maintain and improve the INSIGHT report theme, templates and design standards so all dashboards look and feel consistent.Stakeholder engagementWork directly with internal business teams and external clients to understand their needs and translate them into dashboard requirements.Independently propose and present solutions, and demo finished reports to users and clients.Gather feedback after release and iterate to improve adoption.Data quality & validationValidate dashboard figures against Azure Synapse and INSIGHT's Azure SQL databases before release.Investigate and report data discrepancies, working with the back-end team to resolve them.Security & accessDesign and implement row-level security (static and dynamic RLS) so each internal team and each client sees only their own data.Test RLS roles before every release and manage access in line with the INSIGHT dashboard access process.Documentation, operations & supportDocument every report as part of delivery, not after: business purpose, data sources, data model, key DAX measures, RLS roles, refresh schedule and owner.Keep documentation current whenever a report changes, so any team member can support it or take it over.Publish and manage reports in Power BI Service: workspaces, apps, scheduled refreshes and permissions.Keep up to date with new Power BI features and data visualisation best practice, and share them with the team.Key RequirementsDegree in Computer Science, Information Systems, Data Analytics, Business Analytics, or a related field.Microsoft PL-300 (Power BI Data Analyst) certification is an advantage.At least 2 years of hands-on Power BI development in a business setting.A portfolio of dashboards (screenshots or sample .pbix with dummy or anonymised data) that shows design quality is required with the application.Strong Power BI Desktop and Power BI Service skills: data modelling, Power Query, publishing and refresh.Solid knowledge of row-level security, including dynamic RLS for multi-team and multi-client reports (key requirement).Good DAX skills, including time intelligence, CALCULATE and filter context.A clear eye for UI/UX: layout, colour, typography, visual hierarchy and accessibility.Sound understanding of data visualisation principles: choosing the right chart and avoiding clutter.Working SQL skills to query and check data in a data warehouse (Azure Synapse, Azure SQL).Discipline in documentation: writes clear, up-to-date notes on reports, measures, data sources and security roles.Strong attention to detail when validating numbers.Good written and spoken English; confident speaking with business users and external clients.Good to have (bonus, not required)Programming in Python, C# / .NET, or JavaScript.Experience with Azure data services: Azure Synapse Analytics, Azure SQL, Data Factory or Microsoft Fabric.Embedding or building charts in web portals (JavaScript charting libraries etc).Experience delivering dashboards to external clients.Exposure to AI features in BI tools (Claude Code, Copilot in Power BI, Q&A, smart narratives).Tabular Editor, DAX Studio or ALM Toolkit for model performance tuning.A self-starter who takes ownership of a dashboard from start to finish.Curious and keen to learn new tools and trends.Able to work independently and as part of a small team.