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

Birmingham
1 year ago
Applications closed

Related Jobs

View all jobs

Data Engineer

Senior Data Engineer - Azure, BI & Data Strategy

Data Engineer

Data Engineer (Azure Data Platform)

Data Engineer

Data Analyst Training Course (Excel, SQL & Power BI)

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

Subscribe to Future Tech Insights for the latest jobs & insights, direct to your inbox.

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

Industry Insights

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

New Data Engineering Employers to Watch in 2026: UK and Global Companies Driving the Data Revolution

Data engineering is at the heart of the digital economy, transforming raw data into actionable insights, powering analytics, AI systems, and cloud infrastructure. As the UK and global markets continue to invest heavily in data platforms, pipelines, and real-time analytics, demand for skilled data engineers is growing rapidly. For professionals exploring opportunities on www.DataEngineeringJobs.co.uk , the critical question is: which companies are expanding, hiring, and shaping the future of data-driven business? This article highlights new data engineering employers to watch in 2026, including UK startups, scale-ups, and international firms expanding in the UK.

How Many Data Engineering Tools Do You Need to Know to Get a Data Engineering Job?

If you’re aiming for a career in data engineering, it can feel like you’re staring at a never-ending list of tools and technologies — SQL, Python, Spark, Kafka, Airflow, dbt, Snowflake, Redshift, Terraform, Kubernetes, and the list goes on. Scroll job boards and LinkedIn, and it’s easy to conclude that unless you have experience with every modern tool in the data stack, you won’t even get a callback. Here’s the honest truth most data engineering hiring managers will quietly agree with: 👉 They don’t hire you because you know every tool — they hire you because you can solve real data problems with the tools you know. Tools matter. But only in service of outcomes. Jobs are won by candidates who know why a technology is used, when to use it, and how to explain their decisions. So how many data engineering tools do you actually need to know to get a job? For most job seekers, the answer is far fewer than you think — but you do need them in the right combination and order. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable and employable rather than overwhelmed.

What Hiring Managers Look for First in Data Engineering Job Applications (UK Guide)

If you’re applying for data engineering jobs in the UK, the first thing to understand is this: Hiring managers don’t read every word of your CV. They scan it. They look for signals of relevance, credibility, delivery and collaboration — and if they don’t see the right signals quickly, your application may never get a second look. In data engineering, hiring managers are especially focused on whether you can build and operate reliable, scalable data systems, handle real-world data challenges and work effectively with analytics, BI, data science and engineering teams. This guide breaks down exactly what they look at first in your application — and how to shape your CV, portfolio and cover letter so you stand out.