This role is pivotal in leading the design and development of a recent generation of Power BI dashboards and reports that support the business in making informed, data-driven decisions. Utilizing the organisation’s first consolidated data warehouse, the Power BI Architect will collaborate closely with business stakeholders and data engineering resources to deliver secure, scalable, and insightful reporting solutions.
The Power BI Architect will bridge the gap between business needs and data capability, ensuring reporting requirements are clearly defined, technically feasible, and delivered following best practices in Power BI governance, DevOps, and structured testing. This is a high-impact, business-facing role that combines hands-on dashboard/report creation with strategic influence over our business intelligence roadmap.
Requirements
- Lead the end-to-end design and delivery of Power BI reports and dashboards that provide actionable insight across all areas of the business.
- Engage with business stakeholders to gather, validate, and refine reporting requirements and KPIs.
- Translate business needs into structured reporting specifications aligned with medallion architecture (Bronze/Silver/Gold layers).
- Work closely with the Analytics Engineer to ensure data structures support required reporting outcomes.
- Champion and implement Power BI best practices for report lifecycle management, workspace architecture, security, and usage monitoring.
- Establish and manage processes for peer review, testing, release management, and stakeholder sign-off of reports.
- Develop reusable templates, components, and DAX logic to support consistency and efficiency in report delivery.
- Embed DevOps principles into Power BI development, enabling controlled deployments and change tracking.
- Serve as the subject matter expert for Power BI internally, mentoring others and promoting data visualization best practices.
- Contribute to the overall business intelligence strategy, advocat