BI Specialist (SQL / Azure) - Perm (FTC) - Hybrid

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 reports
• Expertise 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 Services
• Experience managing data refresh strategies, gateways, and Power BI service deployments
• Ability 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 platforms
• Understanding of REST APIs, Power BI Embedded, and programmatic data access patterns

Data Engineering & Modelling

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

Preferred Qualifications

• Microsoft certifications such as DA-100, DP-500, or MCSE: BI
• Familiarity with CI/CD for BI assets (e.g. Git integration for SSAS/Power BI)
• Exposure to DevOps pipelines for automated deployments
• Awareness 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 requirements
• Build SSRS data models and reports, ensuring scalability and performance
• Develop interactive Power BI dashboards using complex business logic in DAX

Integration & Interoperability

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

Platform Support & Governance

• Configure row-level security, user access roles, and workspace settings
• Monitor performance across data models and reports; implement best practices for query optimisation
• Contribute 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 architecture
• Support continuous delivery of BI assets via automated pipelines and DevOps tooling
• Drive improvements in data quality, usability, and user self-service

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