Business Intelligence Developer (Power BI)

TL;DR

Business Intelligence Developer (Power BI/SQL Server): Design, build and maintain high-quality reporting and data solutions across the organisation with an accent on paginated reporting, production-grade datasets, and modern analytics platforms. Focus on developing ETL pipelines, complex SQL queries, dimensional data models, and scalable reporting solutions in Azure or AWS environments.

Location: Remote

Company

Global multi award-winning business travel company making travel straightforward through cutting-edge technology and exceptional customer service, top 10 UK-based Travel Management Company part of The Portman Travel Group.

What you will do

• Design, build and maintain paginated reports using Power BI Report Builder and semantic models for operational and finance reporting.
• Develop and support ThoughtSpot content including Liveboards, worksheets and search-driven analytics.
• Design, build and maintain ETL/ELT pipelines to ingest, transform and model data from multiple sources.
• Develop and optimise complex SQL queries, procedures, views and dimensional data models in SQL Server.
• Work within Azure or AWS environments to deploy BI solutions and contribute to architecture, standards and governance.
• Translate business requirements into scalable reporting solutions with documentation and data quality controls.

Requirements

• 4+ years’ experience in a BI / Data role with hands-on development responsibility.
• Strong SQL Server experience (T-SQL, performance tuning, stored procedures, indexing).
• Demonstrable experience building ETL pipelines (e.g. SSIS, Azure Data Factory).
• Strong experience developing paginated reports (Power BI Report Builder / SSRS).
• Hands-on experience with ThoughtSpot, Power BI datasets and semantic models (DAX).
• Experience in Azure or AWS cloud environments and dimensional modelling principles.

Culture & Benefits

• Mon-Fri 37.5hrs work week.
• Generous holiday entitlement and day off for your birthday.
• Refer a friend bonus £1000 (unlimited).
• Staff awards, hotel and airline discounts, Employee Assistance Programme.
• Bright, energetic, fast-paced and rewarding culture focused on diversity and inclusion.