Business Intelligence Developer (SQL / ETL / PowerBI)

Birmingham
1 year ago
Applications closed

Related Jobs

View all jobs

Business Intelligence Developer

Business Intelligence Developer

Business Intelligence Developer

Business Intelligence Developer

Business Intelligence Developer

Business Intelligence Developer

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.

Careers

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

If you’re trying to break into data science — or progress your career — it can feel like you are drowning in names: Python, R, TensorFlow, PyTorch, SQL, Spark, AWS, Scikit-learn, Jupyter, Tableau, Power BI…the list just keeps going. With every job advert listing a different combination of tools, many applicants fall into a trap: they try to learn everything. The result? Long tool lists that sound impressive — but little depth to back them up. Here’s the straight-talk version most hiring managers won’t explicitly tell you: 👉 You don’t need to know every data science tool to get hired. 👉 You need to know the right ones — deeply — and know how to use them to solve real problems. Tools matter, but only in service of outcomes. So how many data science tools do you actually need to know to get a job? For most job seekers, the answer is not “27” — it’s more like 8–12, thoughtfully chosen and well understood. This guide explains what employers really value, which tools are core, which are role-specific, and how to focus your toolbox so your CV and interviews shine.

Jobs

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

If you’re applying for data science roles in the UK, it’s crucial to understand what hiring managers focus on before they dive into your full CV. In competitive markets, recruiters and hiring managers often make their first decisions in the first 10–20 seconds of scanning an application — and in data science, there are specific signals they look for first. Data science isn’t just about coding or statistics — it’s about producing insights, shipping models, collaborating with teams, and solving real business problems. This guide helps you understand exactly what hiring managers look for first in data science applications — and how to structure your CV, portfolio and cover letter so you leap to the top of the shortlist.

Education

The Skills Gap in Data Science Jobs: What Universities Aren’t Teaching

Data science has become one of the most visible and sought-after careers in the UK technology market. From financial services and retail to healthcare, media, government and sport, organisations increasingly rely on data scientists to extract insight, guide decisions and build predictive models. Universities have responded quickly. Degrees in data science, analytics and artificial intelligence have expanded rapidly, and many computer science courses now include data-focused pathways. And yet, despite the volume of graduates entering the market, employers across the UK consistently report the same problem: Many data science candidates are not job-ready. Vacancies remain open. Hiring processes drag on. Candidates with impressive academic backgrounds fail interviews or struggle once hired. The issue is not intelligence or effort. It is a persistent skills gap between university education and real-world data science roles. This article explores that gap in depth: what universities teach well, what they often miss, why the gap exists, what employers actually want, and how jobseekers can bridge the divide to build successful careers in data science.

🍪 We use cookies to enhance your browsing experience on our website. By continuing to use this site, you consent to the use of cookies as described in our Cookie Policy. You can review our Cookie Policy for more information.