Job Search

Role - BI Specialist (SQL / Azure)

Industry - Automotive

Type - Fixed term contract (3 months, extension thereafter)

Rate - £75,000 per annum, pro rata

Location - Hybrid, 50% of the month in the office (London, Victoria)

PURPOSE OF POST:

Experienced Microsoft / Azure Business Intelligence (BI) Specialist to design, build, and support BI solutions across the Microsoft stack, including SSAS, SSRS, and Power BI. The post holder will play a key role in delivering high-quality, enterprise-grade analytics for platforms, while also enabling integration with third-party reporting tools such as Tableau and Amazon QuickSight. The successful candidate will have strong proficiency in SQL and DAX, a solid understanding of Azure data architecture, and experience working in a cross-functional team comprising engineers, analysts, and product stakeholders.

QUALIFICATIONS / SKILLS / ATTRIBUTES

Microsoft BI Stack

Strong hands-on experience with SSAS (both multidimensional and tabular model development)Experience developing and maintaining SSRS data models and paginated reportsExpertise with Power BI, including Power Query, DAX, measures, and visual design

Azure Data Platform

Familiarity with Azure SQL DB, Synapse Analytics, Data Factory, and Azure Analysis ServicesExperience managing data refresh strategies, gateways, and Power BI service deploymentsAbility to design secure reporting environments with row-level security, role-based access, and Azure AD integration

Integration & Interoperability

Experience connecting Microsoft BI tools with Tableau, Amazon QuickSight, or similar platformsUnderstanding of REST APIs, Power BI Embedded, and programmatic data access patterns

Data Engineering & Modelling

Strong T-SQL skills for data retrieval and performance tuningKnowledge of dimensional modelling, star/snowflake schemas, and data warehouse best practices

Preferred Qualifications

Microsoft certifications such as DA-100, DP-500, or MCSE: BIFamiliarity with CI/CD for BI assets (e.g. Git integration for SSAS/Power BI)Exposure to DevOps pipelines for automated deploymentsAwareness of data cataloguing, data lineage, and governance standards

MAIN DUTIES INCLUDE:

BI Development & Reporting

Design, develop, and maintain SSAS cubes (tabular and multidimensional) aligned to reporting requirementsBuild SSRS data models and reports, ensuring scalability and performanceDevelop interactive Power BI dashboards using complex business logic in DAX

Integration & Interoperability

Enable interoperability with third-party tools like Tableau and Amazon QuickSightManage secure integrations between Power BI and Azure-hosted data sources

Platform Support & Governance

Configure row-level security, user access roles, and workspace settingsMonitor performance across data models and reports; implement best practices for query optimisationContribute to the creation of documentation, data standards, and governance artefacts

Collaboration & Continuous Improvement

Work closely with data engineers and analysts to define and evolve reporting architectureSupport continuous delivery of BI assets via automated pipelines and DevOps toolingDrive improvements in data quality, usability, and user self-service

GCS is acting as an Employment Agency in relation to this vacancy.

Read less