Description

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