BI Analyst

Role overview

Key responsibilities

• Translate stakeholder reporting needs and business questions into practical data solutions.
• Write and maintain SQL queries using pre-built databases and reporting views.
• Build and maintain Workday Adaptive Planning sheets, models, and reporting structures.
• Create and enhance reports and dashboards using Workday, Power BI, and other reporting tools.
• Work with Data Engineers to understand datasets and map data into Workday and other business applications.
• Support APIs, integrations, and onboarding of new systems and data sources.
• Extract, analyse, and present information across databases and systems; validate outputs and investigate discrepancies.
• Explore data, test assumptions, and provide evidence-based insight for business projects.
• Identify reporting automation and improvement opportunities, and document reports, queries, definitions, and logic.

Essential skills and experience

• Strong SQL skills, including querying, joining, transforming, and analysing data.
• Good understanding of relational databases such as Microsoft SQL Server, PostgreSQL, or similar.
• Experience building reports, dashboards, or analytical outputs from business requirements.
• Experience with BI or reporting tools such as Workday or Power BI.
• Experience using Microsoft Excel for data analysis.
• Comfort working across multiple databases, systems, and data sources.
• Strong analytical, investigative, and problem-solving skills; able to explain limitations in messy or incomplete data.
• Confident stakeholder communication and ability to explain findings to people without a technical background.

Desirable experience

• Jira or similar project/work management tools.
• Data warehouses or reporting databases.
• Workday, Power BI, or similar BI tools.
• Retail, healthcare, optical, or audiology experience.

Benefits and development

• Employee health plan, rewards portal, and a calendar of team events.
• Supportive and growing team, company culture, and progression opportunities.