Business Intelligence Developer (SQL / ETL / PowerBI)

Birmingham
2 months ago
Applications closed

Related Jobs

View all jobs

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

Business Intelligence Developer

Business Intelligence Developer

Business Intelligence Developer

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

Senior 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

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.

Jobs

Portfolio Projects That Get You Hired for Data Science Jobs (With Real GitHub Examples)

Data science is at the forefront of innovation, enabling organisations to turn vast amounts of data into actionable insights. Whether it’s building predictive models, performing exploratory analyses, or designing end-to-end machine learning solutions, data scientists are in high demand across every sector. But how can you stand out in a crowded job market? Alongside a solid CV, a well-curated data science portfolio often makes the difference between getting an interview and getting overlooked. In this comprehensive guide, we’ll explore: Why a data science portfolio is essential for job seekers. Selecting projects that align with your target data science roles. Real GitHub examples showcasing best practices. Actionable project ideas you can build right now. Best ways to present your projects and ensure recruiters can find them easily. By the end, you’ll be equipped to craft a compelling portfolio that proves your skills in a tangible way. And when you’re ready for your next career move, remember to upload your CV on DataScience-Jobs.co.uk so that your newly showcased work can be discovered by employers looking for exactly what you have to offer.

Jobs Careers

Data Science Job Interview Warm‑Up: 30 Real Coding & System‑Design Questions

Data science has become one of the most sought‑after fields in technology, leveraging mathematics, statistics, machine learning, and programming to derive valuable insights from data. Organisations across every sector—finance, healthcare, retail, government—rely on data scientists to build predictive models, understand patterns, and shape strategy with data‑driven decisions. If you’re gearing up for a data science interview, expect a well‑rounded evaluation. Beyond statistics and algorithms, many roles also require data wrangling, visualisation, software engineering, and communication skills. Interviewers want to see if you can slice and dice messy datasets, design experiments, and scale ML models to production. In this guide, we’ll explore 30 real coding & system‑design questions commonly posed in data science interviews. You’ll find challenges ranging from algorithmic coding and statistical puzzle‑solving to the architectural side of building data science platforms in real‑world settings. By practising with these questions, you’ll gain the confidence and clarity needed to stand out among competitive candidates. And if you’re actively seeking data science opportunities in the UK, be sure to visit www.datascience-jobs.co.uk. It’s a comprehensive hub featuring junior, mid‑level, and senior data science vacancies—spanning start‑ups to FTSE 100 companies. Let’s dive into what you need to know.

Jobs

Negotiating Your Data Science Job Offer: Equity, Bonuses & Perks Explained

Data science has rapidly evolved from a niche specialty to a cornerstone of strategic decision-making in virtually every industry—from finance and healthcare to retail, entertainment, and AI research. As a mid‑senior data scientist, you’re not just running predictive models or generating dashboards; you’re shaping business strategy, product innovation, and customer experiences. This level of influence is why employers are increasingly offering compensation packages that go beyond a baseline salary. Yet, many professionals still tend to focus almost exclusively on base pay when negotiating a new role. This can be a costly oversight. Companies vying for data science talent—especially in the UK, where demand often outstrips supply—routinely offer equity, bonuses, flexible work options, and professional development funds in addition to salary. Recognising these opportunities and effectively negotiating them can have a substantial impact on your total earnings and long-term career satisfaction. This guide explores every facet of negotiating a data science job offer—from understanding equity structures and bonus schemes to weighing crucial perks like remote work and ongoing skill development. By the end, you’ll be well-equipped to secure a holistic package aligned with your market value, your life goals, and the tremendous impact you bring to any organisation.

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