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.

BI Specialist (SQL / Azure) - Perm (FTC) - Hybrid
Other similar jobs
Popular job searches
Your next job
starts here.
JOB SPECIALISMS
LATEST JOBS
TOP SEARCHES
LOCATIONS
- Project Management
- DevOps
- Software Development
- Cyber
- BI & Data Analytics
- Cloud architect
- Change & Transformation
- Business Change
- Enterprise SaaS
- Cyber Security
- .NET/C#
- Python developer
LATEST JOBS
- ERP & CRM Specialist
- Manual UAT frontendTester
- Azure Security Engineer - Cont...
- BI Specialist (SQL / Azure) -...
- L3 Infrastructure Engineer
- Digital Project Specialist/Man...
- Security Architect
- Data Analyst
- Head Of Integration/ Technical...
- Product Manager
- ERP Director
- Service Delivery Manager
TOP SEARCHES
LOCATIONS
- Engineer
- Data Scientist
- Senior Data Scientist
- Head of Data Science
- Trainee Data Scientist
- Data Science Graduate
- Senior Financial Accountant
- Management Accountant
- Cost Accountant
- Civil Engineer
- Senior Civil Engineer
- Civil Design Engineer