Business Intelligence Developer

BI Developer / Power BI

Location: Guildford (Onsite 1-2 days a week)
Salary: £45,000 - £60,000

The Opportunity

An exciting opportunity has arisen for an experienced Business Intelligence Developer to join a growing Business Intelligence and Automation function.

This role sits at the heart of the organisation's digital transformation strategy, helping to drive automation, data integration, business intelligence and self-service reporting capabilities across the business. You'll be responsible for developing innovative solutions that improve efficiency, reduce manual processes and provide stakeholders with meaningful insights to support decision-making.

Working with technologies includingPower BI, Power Automate, SQL, Python and R, you'll play a key role in developing enterprise-level reporting and automation solutions while helping shape future data architecture and governance standards.

Key Responsibilities

Business Intelligence & Reporting

• Design, develop and maintain enterprise-level Power BI dashboards and reports.
• Create semantic models, datasets and data pipelines to support self-service analytics.
• Build compelling visualisations that provide actionable business insights.
• Develop calculated measures and data models using DAX and Power Query.
• Implement Row-Level Security and governance controls across reporting environments.
• Analyse legacy reporting solutions and design modern Power BI alternatives.

Automation & Advanced Analytics

• Develop automation solutions that streamline business processes and administrative functions.
• Create predictive models and analytical solutions using Python or R.
• Support automation initiatives using technologies such as Power Automate and Blue Prism.
• Identify opportunities to improve efficiency through the application of data and automation technologies.

Stakeholder Engagement

• Gather and document reporting and analytical requirements from stakeholders.
• Facilitate workshops, user interviews and requirements sessions.
• Present findings, recommendations and solutions to senior stakeholders.
• Act as the organisation's subject matter expert for Power BI and data analytics.
• Support and train business users in self-service reporting capabilities.

About You

You will be a technically strong BI professional with experience delivering enterprise reporting and data solutions. You'll be equally comfortable discussing technical architecture with developers as you are presenting business insights to senior stakeholders.

You'll have a genuine passion for data, automation and continuous improvement, with the ability to translate complex requirements into practical solutions.

Essential Skills & Experience

• Proven experience as a BI Developer, Power BI Developer, Data Engineer, Analytics Developer or Data Scientist.
• Extensive hands-on experience with Power BI development and administration.
• Strong SQL development skills, including views, stored procedures and database querying.
• Experience developing dashboards, reports and data models using:
  
  • Power BI
  • DAX
  • Power Query
  • SQL

Desirable:

• Experience developing ETL and data integration processes.
• Experience gathering requirements and working closely with stakeholders.
• Ability to design and document technical solutions and data architectures.
• Strong communication and presentation skills.
• Oracle Database
• Python or R for predictive modelling and data science
• Data Warehousing and Dimensional Modelling