BI Specialist (SQL/Azure) - Perm (FTC) - Hybrid
Posted 7 days ago by GCS on JobServe
£75,000 Per year
Fixed-Term
Hybrid
London, UK
Summary: The BI Specialist (SQL/Azure) role is focused on designing, building, and supporting Business Intelligence solutions within the automotive industry, utilizing the Microsoft BI stack and Azure data architecture. The position requires strong SQL and DAX skills, along with experience in integrating third-party reporting tools. The role is a fixed-term contract for three months with potential for extension, and it involves a hybrid working arrangement based in London. The successful candidate will collaborate with cross-functional teams to deliver high-quality analytics and reporting solutions.
Key Responsibilities:
- Design, develop, and maintain SSAS cubes 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.
- Enable interoperability with third-party tools like Tableau and Amazon QuickSight.
- Manage secure integrations between Power BI and Azure-hosted data sources.
- 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.
- 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.
Key Skills:
- 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.
- 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.
- Experience connecting Microsoft BI tools with Tableau, Amazon QuickSight, or similar platforms.
- Understanding of REST APIs, Power BI Embedded, and programmatic data access patterns.
- Strong T-SQL skills for data retrieval and performance tuning.
- Knowledge of dimensional modelling, star/snowflake schemas, and data warehouse best practices.
- 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.
Salary (Rate): £75,000
City: London
Country: UK
Working Arrangements: hybrid
IR35 Status: fixed-term
Seniority Level: Mid-Level
Industry: Automotive