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

Birmingham
5 days 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

Graduate BI Developer

Data Analytics Developer - £70,000 - London

SC Cleared Java Developer, Spring, React, Kafka

SC Cleared Java Developer, Spring, React, Kafka

SQL Developer

Backend Developer

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.

Data Engineering Apprenticeships: Your In-Depth Guide to a High-Growth Tech Career

Data sits at the heart of modern business. From predictive analytics in finance to personalised recommendations in e-commerce, virtually every sector relies on data to make informed decisions, optimise operations, and drive innovation. Yet, as data volumes grow exponentially, so does the complexity of managing and utilising it effectively. In this evolving environment, data engineering has emerged as a critical discipline—responsible for designing, building, and maintaining the pipelines that transform raw information into actionable insights. If you’re looking to break into this vibrant and future-oriented field, data engineering apprenticeships offer a hands-on, cost-effective route. Designed to fast-track your skills, apprenticeships combine formal training with practical, on-the-job learning. Whether you’re a school leaver or a professional seeking a career change, this guide will walk you through everything you need to know about data engineering apprenticeships in the UK—from the roles you might undertake, to the skills you’ll master, and the exciting career paths that await.

Tips for Staying Inspired: How Data Engineering Pros Fuel Creativity and Innovation

Data engineering stands at the core of modern business intelligence, analytics, and machine learning initiatives. As more organisations become data-driven, the demands on data engineers—everything from building robust pipelines and optimising data warehouses to cleaning and transforming petabytes of raw information—only intensify. Yet, remaining innovative and creative in this rapidly evolving space can be challenging when faced with routine maintenance, endless transformations, and the pressure of meeting tight deadlines. So, how do data engineers stay inspired and consistently generate new ideas? Below are ten actionable strategies to help data pipeline experts, ETL developers, and cloud data architects maintain an inventive outlook, even when operations are complex and the stakes are high. If you’re looking to expand your skills, tackle challenges from fresh angles, and reinvigorate your passion for data engineering, these tips can guide you toward a more fulfilling and impactful career.

Top 10 Data Engineering Career Myths Debunked: Key Facts for Aspiring Professionals

Data is the lifeblood of modern businesses. Whether it’s guiding strategic decisions, powering advanced analytics, or fuelling machine learning models, the role of data has evolved from a back-office function to a primary driver of innovation. In this ecosystem, data engineers serve as architects and builders, designing the infrastructure and pipelines that allow organisations to collect, transform, and mobilise data efficiently. Despite the importance and rapid growth of this field, plenty of myths and misconceptions continue to cloud the realm of data engineering. Are data engineers merely “ETL developers”? Does the role only exist in big tech companies? Must you be a Python guru with a master’s degree in computer science? At DataEngineeringJobs.co.uk, we see firsthand how these myths can deter aspiring professionals from stepping into one of the most dynamic fields in data. This article aims to dispel the top 10 misconceptions about data engineering careers—shedding light on the real opportunities, necessary skills, and diverse pathways that define this vital profession. Whether you’re a student considering data engineering as your future vocation or a seasoned professional seeking a career pivot, read on. You might discover that data engineering is more inclusive and wide-ranging than you ever imagined.