Business Intelligence Developer (SQL / ETL / PowerBI)

Michael Page
Birmingham
1 week ago
Create job alert

This Large Government Body is 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

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:

  1. Identify opportunities for improving the way data is sourced and stored in the data warehouse.
  2. 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.
  3. 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).
  4. Assess requirements, design solutions, document models, and deliver ETL solutions using SSIS and Azure Data Factory.
  5. Develop and modify existing ETL models to support changes to the business process or emerging business needs.
  6. Maintain and develop further the data warehouse in line with changing business MI needs.
  7. Identify and articulate opportunities to put further query and reporting capabilities in the hands of business users.
  8. Support data quality across the organisation by working with users to identify and rectify data capture errors.

Essential Key Skills / Experience:

  1. A great communicator, able to communicate effectively with all levels of the organisation.
  2. Good understanding of best practice in Data Warehouse Implementation.
  3. Strong critical thinking / problem solving / troubleshooting and decision-making with the ability to work to deadlines.
  4. Adapt to changes and re-evaluate priorities to meet changing priorities.
  5. Advanced ETL, SQL programming / SSIS skills.
  6. Skills in data mapping and modelling.
  7. 3-5 years' experience in SQL language.
  8. Knowledge of Kimball methodology / Star Schema modelling in Data Warehousing.
  9. Experience of SSIS and SSMS.
  10. Good understanding and experience of building ETL processes including extracting data via APIs.
  11. Advanced understanding and ability to build and develop Power BI reports and dashboards to a high standard fulfilling business needs.
  12. Preparing and communicating reports and management information.

Desirable Skills / Experience:

  1. Management of Azure PaaS and IaaS instances.
  2. Experience of Azure Data Factory.
  3. Experience of SSRS.
  4. Experience of PowerApps and Power Automate.

Job Offer

Opportunity to deliver enhanced analytics and reporting services.

Opportunity to influence and enhance insight & analytics strategy.

#J-18808-Ljbffr

Related Jobs

View all jobs

Business Intelligence Developer

Business Intelligence Developer (SQL / ETL / PowerBI)

Business Intelligence Developer

Graduate BI Developer

Senior BI Developer - Edinburgh/Glasgow Hybrid - 52K plus Bonus

SQL 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.

10 Essential Books to Read to Nail Your Data Science Career in the UK

Data science continues to be one of the most exciting and rapidly evolving fields in tech. With industries across the UK—ranging from finance and healthcare to e-commerce and government—embracing data-driven decision-making, the demand for skilled data scientists has soared. Whether you're a recent graduate looking for your first role or a professional aiming to advance your career, staying updated through books is crucial. In this article, we explore ten essential books every data science job seeker in the UK should read. Each book provides valuable insights into core concepts, practical applications, and industry-standard tools, helping you build skills employers are actively looking for.

Navigating Data Science Career Fairs Like a Pro: Preparing Your Pitch, Questions to Ask, and Follow-Up Strategies to Stand Out

Data science has taken centre stage in the modern workplace. Organisations rely on data-driven insights to shape everything from product innovation and customer experience to operational efficiency and strategic planning. As a result, there is a growing need for skilled data scientists who can analyse large volumes of data, build predictive models, communicate findings effectively, and collaborate cross-functionally. If you are looking to accelerate your data science career—or even land your first role—attending data science career fairs can be a game-changer. Unlike traditional online applications, face-to-face interactions let you showcase your personality, passion, and communication skills in addition to your technical expertise. However, to stand out in a busy environment, you need a clear strategy: from polishing your personal pitch and asking thoughtful questions to following up with a memorable message. In this article, we’ll guide you through every step of making a strong impression at data science career fairs in the UK and beyond.

Common Pitfalls Data Science Job Seekers Face and How to Avoid Them

Data science has become a linchpin for decision-making and innovation across countless industries, from finance and healthcare to tech and retail. The demand for data scientists in the UK continues to climb, with businesses seeking professionals who can interpret complex datasets, build predictive models, and communicate actionable insights. Despite this high demand, the job market can be extremely competitive—and many applicants unknowingly fall into avoidable traps. Whether you’re an aspiring data scientist fresh out of university, a professional transitioning from a quantitative role, or a seasoned analyst looking to expand your skill set, it’s crucial to navigate your job search effectively. In this article, we explore the most common pitfalls data science job seekers face and provide pragmatic advice to help you stand out. By refining your CV, portfolio, interview strategies, and communication skills, you can significantly increase your chances of landing a rewarding data science role. If you’re looking for your next data science job in the UK, don’t forget to explore the listings at Data Science Jobs. Read on to discover how to avoid critical mistakes and position yourself for success.