BI Analyst

BI Analyst

Nottingham

Negotiable

The role focuses on interpreting data and presenting it to support strategic decision-making and supporting internal reporting automation using tools such as VBA, Power Query, and other scripting-based process improvements.

The job.

• Design, build, and maintain Power BI dashboards for business users.
• Use DAX to develop calculated fields, KPIs, and metrics.
• Understand and navigate SQL-based data structures and schemas.
• Gather and interpret business requirements for reporting and analysis.
• Ensure data accuracy and consistency in reporting outputs.
• Collaborate with stakeholders across departments to optimize data use.
• Provide support and troubleshooting for BI tools and dashboards.
• Assist with ad hoc analysis where needed.
• Build and maintain automation scripts and tools using VBA (e.g., Excel macros for data transformation or report preparation).
• Create reusable templates and report logic for future automation and scalability.

The candidate.

• Practical experience with Power BI, including dashboard development.
• Strong working knowledge of DAX and Power Query.
• Good understanding of data relationships, schemas, and reporting logic.
• Strong analytical thinking and attention to detail.
• Ability to translate data into clear, visual narratives.
• SQL coding experience whilst not necessarily needed would be beneficial
• Proficiency in VBA (Excel macros) for process automation and report scripting.
• Excellent verbal and written communication skills and the ability to negotiate and influence effectively with all levels.
• Ability to deal tactfully and diplomatically and maintain confidentiality with internal and external stakeholders.