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 designAzure 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 integrationIntegration & Interoperability
Experience connecting Microsoft BI tools with Tableau, Amazon QuickSight, or similar platforms
Understanding of REST APIs, Power BI Embedded, and programmatic data access patternsData 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 DAXIntegration & Interoperability
Enable interoperability with third-party tools like Tableau and Amazon QuickSight
Manage secure integrations between Power BI and Azure-hosted data sourcesPlatform 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 artefactsCollaboration & 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-serviceGCS is acting as an Employment Agency in relation to this vacancy
