Job Specifications
Role- BI Specialist (SQL/Azure)
Industry - Automotive
Type -Fixed term contract (2 months, extension thereafter)
Rate - PS75,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 (eg 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.
About the Company
For over 30 years, GCS has been at the forefront of digital transformation, building vast global communities of innovators and placing them in businesses shaping tomorrow's world. Whether it’s the next step on your journey or if you are looking for an industry luminary, we are your partner of choice.
Proud of our specialist service and passionate about our people, our customers only deal with true industry experts. Whether you are looking to add to your team or find a new contract or permanent position, GCS will ensure you...
Know more