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

London
1 week ago
Create job alert

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

Related Jobs

View all jobs

Senior Data Architect - Databricks

IT Manager

Lead Data Engineer

Senior Azure/Dynamics 365 Technical Lead

Data Engineer (Asset Management)

IT Support Engineer

Get the latest insights and jobs direct. Sign up for our newsletter.

By subscribing you agree to our privacy policy and terms of service.

Industry Insights

Discover insightful articles, industry insights, expert tips, and curated resources.

Portfolio Projects That Get You Hired for Cloud Jobs (With Real GitHub Examples)

As cloud computing becomes the de facto choice for businesses of all sizes, cloud professionals are in high demand. From infrastructure automation to container orchestration and serverless architecture, cloud roles require a blend of technical expertise and practical, hands-on skills. Whether you’re aiming to be a Cloud Engineer, Solutions Architect, DevOps Professional, or any role involving AWS, Azure, or Google Cloud Platform (GCP), a well-curated portfolio of projects is often the deciding factor for hiring managers. In this comprehensive guide, we’ll explore: Why a portfolio matters more than ever in the cloud computing job market. Which types of projects align with different cloud roles. Real GitHub examples that exemplify best practices in cloud development and deployment. Actionable project ideas to help you stand out from the crowd. Best practices for structuring and presenting your repositories for maximum impact. By the end, you’ll have a clear blueprint to build an impressive portfolio that resonates with potential employers. And when you’re ready to make your move, don’t forget to upload your CV on Cloud-Jobs.co.uk so that top companies seeking cloud talent can see your experience firsthand.

Cloud Computing Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

The world of cloud computing has rapidly evolved into a critical backbone for modern businesses. From running microservices on containerised infrastructure and automating continuous deployments, to architecting highly available, secure solutions at global scale—the cloud domain offers endless career opportunities. Whether you aim to become an AWS Solutions Architect, an Azure DevOps Engineer, or a GCP Cloud Developer, your expertise in designing, coding, and managing cloud‑native services can open doors across every industry. However, cloud job interviews can be challenging. Employers typically probe a wide array of topics, from traditional software engineering and system design to security, scalability, and cost optimisation in cloud environments. For many candidates, this means a broad but in-depth skillset, along with hands‑on demonstrations of your knowledge. In this guide, we’ll walk you through 30 real coding & system-design questions you might face when interviewing for cloud roles. Each question or scenario is designed to test both fundamental programming skills and the architectural insight needed for building, deploying, and maintaining cloud platforms. If you’re seeking new opportunities in the UK’s thriving cloud sector, www.cloud-jobs.co.uk is an excellent place to start. You’ll find roles spanning everything from core infrastructure engineering to hybrid cloud consulting. Let’s begin your interview prep journey now.

Negotiating Your Cloud Job Offer: Equity, Bonuses & Perks Explained

How to Secure a Compensation Package That Reflects Your Value in the UK’s Booming Cloud Computing Sector Introduction Cloud computing has become the backbone of modern enterprise infrastructure. From small start-ups deploying microservices to multinational corporations scaling complex data analytics, the demand for cloud-savvy professionals continues to accelerate. If you’re working in cloud architecture, DevOps, infrastructure security, or any other mid‑senior role in the cloud domain, your expertise is in high demand—and so is your ability to negotiate a well-rounded compensation package. While an attractive base salary is essential, limiting your focus to that figure alone can mean missing out on substantial financial and lifestyle gains. Cloud-focused employers, including both tech giants (AWS, Microsoft Azure, Google Cloud) and smaller cloud-native consultancies, often layer their offers with equity, bonuses, and a host of perks to stand out in a competitive market. By delving deeper into these compensation components, you can maximise your earnings and ensure your new role supports both your career growth and personal well-being. In this comprehensive guide, we’ll explore every dimension of negotiating a cloud job offer. Whether you’re an established Cloud Solutions Architect eyeing a role at a cutting-edge start-up or a mid‑senior DevOps engineer seeking a leadership position at a global corporation, you’ll find insights on how to evaluate, compare, and negotiate all elements—from salary and equity to perks like flexible working and training budgets. Read on to discover how to turn a standard job offer into a holistic package that truly reflects your impact in the cloud computing arena.