Business Intelligence Developer (SQL / ETL / SSIS / PowerBI)

Birmingham
2 weeks ago
Create job alert

This Large Government Body are looking for a Business Intelligence Developer to play a crucial role in maintaining and enhancing their Business Intelligence solutions and automated tools. You will work with Customer Service, Finance, HR, and divisions to generate valuable management information

Client Details

Large Government Body

Description

This Large Government Body are looking for a Business Intelligence Developer to play a crucial role in maintaining and enhancing their Business Intelligence solutions and automated tools. You will work with Customer Service, Finance, HR, and divisions to generate valuable management information.

Collaborating with a diverse team of technical and data specialists, you will improve reporting capabilities and ensure thorough documentation of any changes to reporting solutions. Your role will be vital in developing and delivering accurate, reliable, and effective management information to support the organisation's needs.

The role is Hybrid with 20% of a working month based in the office either in Leeds, Birmingham or Cardiff

Key Responsibilities:

· You will be an authoritative voice identifying opportunities for improving the way data is sourced and stored in the data warehouse.

· Work closely with the Performance Analysts, Lead BI Developer, CRM and SharePoint specialists to ensure that new and changed reporting requirements are properly captured prior to analysis and development.

  • Lead in the design and support of robust routines for the production and delivery of reliable, accurate, agreed Management Information from key systems (case management, telephony, finance and HR)

  • Assess requirements, design solutions, document models, and deliver ETL solutions using SSIS and Azure Data Factory.

    · Develop and modify existing ETL models to support changes to the business process or emerging business needs.

  • Maintain and develop further the data warehouse in line with changing business MI needs.

  • Identify and articulate opportunities to put further query and reporting capabilities in the hands of business users.

  • Support data quality across the organisation by working with users to identify and rectify data capture errors.

    Essential Key Skills / Experience:

  • A great communicator, able to communicate effectively with all levels of the organisation.

  • Good understanding of best practice in Data Warehouse Implementation

  • Strong critical thinking / problem solving / trouble shooting and decision making with the ability to work to deadlines.

  • Adapt to changes and re-evaluate priorities to meet changing priorities.

  • Advanced ETL, SQL programming / SSIS skills

  • Skills in data mapping and modelling.

  • 3-5 years' experience in SQL language

  • Knowledge of Kimball methodology / Star Schema modelling in Data Warehousing.

  • Experience of SSIS and SSMS.

  • Good understanding and experience of building ETL processes including extracting data via APIs.

  • Advanced understanding and ability to build and develop Power BI reports and dashboards to a high standard fulfilling business needs.

  • Preparing and communicating reports and management information

    Desirable Skills / Experience:

  • Management of Azure PaaS and IaaS instances.

  • Experience of Azure Data Factory.

  • Experience of SSRS

  • Experience of PowerApps and Power automate

    Profile

    Essential Key Skills / Experience:

  • A great communicator, able to communicate effectively with all levels of the organisation.

  • Good understanding of best practice in Data Warehouse Implementation

  • Strong critical thinking / problem solving / trouble shooting and decision making with the ability to work to deadlines.

  • Adapt to changes and re-evaluate priorities to meet changing priorities.

  • Advanced ETL, SQL programming / SSIS skills

  • Skills in data mapping and modelling.

  • 3-5 years' experience in SQL language

  • Knowledge of Kimball methodology / Star Schema modelling in Data Warehousing.

  • Experience of SSIS and SSMS.

  • Good understanding and experience of building ETL processes including extracting data via APIs.

  • Advanced understanding and ability to build and develop Power BI reports and dashboards to a high standard fulfilling business needs.

  • Preparing and communicating reports and management information

    Desirable Skills / Experience:

  • Management of Azure PaaS and IaaS instances.

  • Experience of Azure Data Factory.

  • Experience of SSRS

  • Experience of PowerApps and Power automate

    Job Offer

    Opportunity to deliver enhanced analytics and reporting services

    Opportunity to influence and enhance insight & analytics strategy

Related Jobs

View all jobs

Business Intelligence Developer (SQL / ETL / SSIS / PowerBI)

Senior Business Intelligence Developer

Business Intelligence Team Leader

Dynamics CRM Developer

PowerApps Developer (Engineering, Construction)

Data Analyst

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.

Contract vs Permanent Data Science Jobs: Which Pays Better in 2025?

Data science sits at the intersection of statistics, machine learning, and domain expertise, driving crucial business decisions in almost every sector. As UK organisations leverage AI for predictive analytics, customer insights, and automation, data scientists have become some of the most in-demand professionals in the tech job market. By 2025, data scientists with expertise in deep learning, natural language processing (NLP), and MLOps are commanding top-tier compensation packages. However, deciding whether to become a day‑rate contractor, a fixed-term contract (FTC) employee, or a permanent member of an organisation can be challenging. Each path offers a unique blend of earning potential, career progression, and work–life balance. This guide will walk you through the UK data science job market in 2025, examine the differences between these three employment models, present sample take‑home pay scenarios, and offer strategic considerations to help you determine the best fit for your career.

Data Science Jobs for Non‑Technical Professionals: Where Do You Fit In?

Beyond Jupyter Notebooks Ask most people what a data‑science career looks like and they’ll picture Python wizards optimising XGBoost hyper‑parameters. The truth? Britain’s data‑driven firms need storytellers, strategists, ethicists and project leaders every bit as much as they need statisticians. The Open Data Institute’s UK Data Skills Gap 2024 places demand for non‑technical data talent at 42 % of all data‑science vacancies—roles focused on turning model outputs into business value and trustworthy decisions. This guide highlights the fastest‑growing non‑coding roles, the transferable skills many professionals already have, and a 90‑day action plan to land a data‑science job—no pandas required.

McKinsey & Company Data‑Science Jobs in 2025: Your Complete UK Guide to Turning Data into Impact

When CEOs need to unlock billion‑pound efficiencies or launch AI‑first products, they often call McKinsey & Company. What many graduates don’t realise is that behind every famous strategy deck sits a global network of data scientists, engineers and AI practitioners—unified under QuantumBlack, AI by McKinsey. From optimising Formula One pit stops to reducing NHS wait times, McKinsey’s analytics teams turn messy data into operational gold. With the launch of the McKinsey AI Studio in late 2024 and sustained demand for GenAI strategy, the firm is growing its UK analytics headcount faster than ever. The McKinsey careers portal lists 350+ open analytics roles worldwide, over 120 in the UK, spanning data science, machine‑learning engineering, data engineering, product management and AI consulting. Whether you love Python notebooks, Airflow DAGs, or white‑boarding an LLM governance roadmap for a FTSE 100 board, this guide details how to land a McKinsey data‑science job in 2025.