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

Power BI Specialist

Power BI Developer

Senior Analyst & Data Specialist

Science Analytics and Reporting Specialist

Oracle EBS Functional Specialist - HR/Payroll

Senior Data Architect - Databricks

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 Data Engineering Jobs (With Real GitHub Examples)

Data is increasingly the lifeblood of businesses, driving everything from product development to customer experience. At the centre of this revolution are data engineers—professionals responsible for building robust data pipelines, architecting scalable storage solutions, and preparing data for analytics and machine learning. If you’re looking to land a role in this exciting and high-demand field, a strong CV is only part of the puzzle. You also need a compelling data engineering portfolio that shows you can roll up your sleeves and deliver real-world results. In this guide, we’ll cover: Why a data engineering portfolio is crucial for standing out in the job market. Choosing the right projects for your target data engineering roles. Real GitHub examples that demonstrate best practices in data pipeline creation, cloud deployments, and more. Actionable project ideas you can start right now, from building ETL pipelines to implementing real-time streaming solutions. Best practices for structuring your GitHub repositories and showcasing your work effectively. By the end, you’ll know exactly how to build and present a portfolio that resonates with hiring managers—and when you’re ready to take the next step, don’t forget to upload your CV on DataEngineeringJobs.co.uk. Our platform connects top data engineering talent with companies that need your skills, ensuring your portfolio gets the attention it deserves.

Data Engineering Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

The world of data engineering has rapidly emerged as a critical pillar for businesses, enabling them to extract insights from vast amounts of information and power data-driven decision-making. From building scalable ETL pipelines to designing real-time streaming infrastructures and cloud data warehouses, data engineers are in high demand across every industry—from tech giants to healthcare providers to financial institutions. If you’re seeking a data engineering role, you may already know that interviews can be rigorous, spanning software development, database design, distributed systems, and cloud computing. Many organisations need engineers who can handle both traditional batch processing and cutting-edge real-time analytics frameworks, all while keeping data secure, consistent, and optimised. In this guide, we’ll explore 30 real coding & system-design questions that often come up in data engineering interviews. From classic coding challenges to architecture-focused scenarios, these questions will help you gauge your readiness and build confidence before stepping into that interview room. If you’re actively searching for new data engineering opportunities in the UK, www.dataengineeringjobs.co.uk is a fantastic resource. It features a wide range of vacancies—from junior data engineering positions to senior-level cloud architecture roles. Let’s dive in so you can approach your next interview with insight and poise.

Negotiating Your Data Engineering Job Offer: Equity, Bonuses & Perks Explained

How to Secure a Compensation Package That Reflects Your Value in the UK’s Fast-Growing Data Ecosystem Introduction Data engineering has quickly become the backbone of modern business operations. Whether powering analytics platforms, migrating data to the cloud, or building pipelines for machine learning, data engineers enable organisations to extract meaningful insights from vast datasets. With companies across every sector looking to harness data for competitive advantage, mid‑senior data engineers are in especially high demand—and that spells opportunity for you to negotiate a compelling compensation package. Yet for many professionals, negotiations around a job offer still focus primarily on salary, leading them to overlook valuable components such as equity, performance bonuses, and perks that can collectively add significant value to your overall deal. In the world of data engineering, it’s not uncommon to see advanced compensation packages involving shares, annual or quarterly bonuses, and a range of benefits that support both your technical growth and work-life balance. This guide aims to be your comprehensive manual for negotiating a data engineering job offer in the UK. We’ll cover why negotiation isn’t just about your monthly paycheck, explore how equity works in data-centric organisations, break down different bonus structures, and highlight perks that matter most for mid‑senior professionals. By the end, you’ll have the knowledge—and the confidence—to land a package that fully reflects your critical role in unlocking the power of data.