Business Intelligence and Database Lead

London
3 days ago
Create job alert

Job Title: Business Intelligence and Database Lead
Reporting to: Professional Services Director

Purpose of the Role
The Business Intelligence and Database Lead is responsible for developing, maintaining, and enhancing the organisation's data analytics, data quality, and data governance frameworks. The role ensures that business data is accurate, reliable, and aligned with strategic objectives. You will support data‑driven decision‑making by designing insightful dashboards, maintaining data integrity, ensuring compliance with governance standards, and improving data literacy across the organisation.

You will collaborate with global data architecture and modelling teams, regional CAFM support, and operational finance. The role oversees data modelling, reporting architecture, and database governance to support scalable analytics across CAFM systems, BMS telemetry, lifecycle modelling, and operational datasets. This position plays a key role in delivering advanced dashboards and predictive insights for operational teams, asset managers, and clients.

Key Responsibilities

  • Lead and support operational performance reporting across the business and manage a pipeline of reporting requirements (Finance, Operations, P&C, IT, FM).
  • Lead the design and development of enterprise Power BI dashboards and reporting frameworks.
  • Build scalable data models using Power BI, DAX, and Power Query.
  • Lead management of enterprise data platforms including Snowflake, SQL databases, and cloud data warehouses.
  • Design ETL/ELT processes integrating CAFM, IoT, and financial systems.
  • Ensure data integrity, performance optimisation, and security compliance.
  • Implement self‑service BI capabilities for operational and client stakeholders.
  • Maintain a functional specification library for dashboards and ensure design documentation is up to date.
  • Work with the Building Performance Director on predictive and prescriptive analytics, including statistical and machine learning models.
  • Enforce BGIS data governance frameworks and standards, prioritising CAFM systems such as Joblogic and Vantify.
  • Collaborate with CMMS and CAFM Data & Operations Support to automate data quality checks.
  • Implement database migration plans for legacy data domains and ensure appropriate access control and adherence to data retention policies.
  • Document business rules, data definitions, data flows, and schemas.
  • Establish and maintain enterprise data governance frameworks, including data dictionaries, metadata standards, and access control policies.
  • Implement data quality monitoring and validation processes aligned with corporate and client reporting standards.
  • Optimise Power BI datasets for performance and scalability.
  • Deliver training and workshops to提升 data literacy across the business.
  • Support ad‑hoc tasks related to UK service technology operations.
    Additional Responsibilities
  • Oversee data import quality into relevant systems.
  • Work with the Data & BI team on data processes and governance.
    Accountabilities
  • Reports to the Professional Services Director (UK).
  • No direct budget responsibility.
    Key Performance Indicators
  • Enterprise Power BI reporting platform supporting operational and client reporting.
  • Standardised data models across FM systems.
  • Scalable data warehouse architecture.
  • Business‑wide performance analytics dashboards.
  • Strong data governance and security frameworks.

    Person Specification
    Education (Essential)
  • Degree in Data Science, Computer Science, Engineering, or Information Systems.
  • Certifications in Power BI, Microsoft Data Analytics, or Cloud Data Platforms (desirable).
    Education (Desirable)
  • Master's degree in Computer Science, Engineering, IT, or related field.

    Skills & Knowledge (Essential)
  • Advanced Power BI development (DAX, Power Query, data modelling).
  • Strong SQL and relational database knowledge.
  • Experience with cloud platforms (Azure, AWS, GCP) and data lakes.
  • Experience with cloud data platforms such as Snowflake.
  • ETL/ELT pipeline and data integration experience.
  • Understanding of data warehousing architecture.
  • Knowledge of API integrations and data connectors.

    Skills & Knowledge (Desirable)
  • Technical knowledge of SFG20.
  • Experience using Python or R for analytics.
  • Understanding of data governance frameworks (e.g., DAMA‑DMBOK, DCAM).
  • Knowledge of GDPR, ISO 27001 or other data compliance standards.

    Experience (Essential)
  • Minimum 3-5 years' experience in Business Intelligence, data analysis, or data governance.

    Experience (Desirable)
  • Experience with Assets/PPM in a CMMS system.

    Aptitudes
  • Strong analytical and problem‑solving skills.
  • Excellent communication and presentation abilities.
  • High attention to detail and accuracy.
  • Ability to manage multiple priorities and deadlines.
  • Collaborative and able to work effectively across departments.

    Character
  • Enthusiastic and positive approach.
  • Strong customer service focus.
  • Calm and professional under pressure.
  • Reliable, self‑motivated, and able to prioritise effectively.

    Circumstances
  • Flexibility in working patterns is required.
  • Primarily based in BSM offices, with travel to BGIS and client sites across London, the South of England, and occasionally elsewhere.

    #BGISUK

Related Jobs

View all jobs

Analyst I, Mission Control

Finance Business Partner

Avionics Production Technician

Avionics Production Technician

Avionics Engineer

Pricing Analyst

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.

How Many Space Industry Tools Do You Need to Know to Get a UK Space Job?

If you’re pursuing a career in the space industry — whether that’s spacecraft engineering, mission operations, space software, satellite systems, ground segment integration or space data analytics — it’s easy to feel overwhelmed by the sheer number of tools, platforms and technologies mentioned in job adverts. One role wants experience with CAD and FEA software. Another asks for experience with GNSS simulation. A third mentions mission scheduling tools, RF link analysis suites, Python, C++, continuous integration — and it seems there’s always another acronym to learn. With so much listed, many candidates fall into the trap of thinking they must master every tool under the sun before they’ll be taken seriously. Here’s the honest truth most UK space hiring managers won’t say out loud: 👉 They don’t hire you because you’ve heard of every tool — they hire you because you can apply the right tools to solve real space problems, explain your reasoning clearly, and deliver results. Tools matter, but they always serve a purpose: achieving mission goals, improving reliability, reducing risk, delivering data, or enabling collaboration. Tools are enablers — not trophies. So how many tools do you actually need to know to get a space job? The answer is much fewer and far more strategic than you might think. This article breaks down: what tools employers really expect which ones are core across most space roles which ones are role-specific how to present your tool proficiency on your CV and in interviews

What Hiring Managers Look for First in Space Sector Job Applications (UK Guide)

The space industry is one of the most exciting and multidisciplinary sectors in technology and engineering today. Whether you’re applying for roles in spacecraft design, aerospace systems, robotics, satellite communications, mission operations, payload engineering, space software, ground systems, or scientific research, your application must quickly show hiring managers that you are relevant, technically credible and ready to deliver. In the UK space jobs market — spanning organisations from startups to defence primes, agencies, research labs and commercial constellations — hiring managers do not read every word of your CV. They scan applications rapidly, often making a judgement about whether to read further within the first 10–20 seconds. This guide breaks down exactly what hiring managers look for first in space sector applications, how they assess CVs and portfolios, why specific signals matter, and how you can position your experience to stand out on www.ukspacejobs.co.uk .

The Skills Gap in UK Space Jobs: What Universities Aren’t Teaching

The UK space sector is one of the most exciting and fastest-growing high-tech industries in the world. From Earth observation and satellite communications to space robotics, launch systems and deep-space exploration, the breadth of opportunity is enormous. The UK Government’s ambition to capture a significant share of the global space economy has driven investment, policy support and a wave of innovative companies — both established and start-up. Yet despite strong academic programmes and a pipeline of graduates with relevant degrees, employers in the UK space sector consistently report a persistent problem: Many graduates are not prepared for real-world space industry jobs. This is not a matter of intelligence or motivation. Rather, it reflects a growing skills gap between what universities are teaching and what employers actually need from space professionals. In this article, we’ll explore why that gap exists, what universities are doing well, where they fall short, what employers want, and how jobseekers can bridge the divide to build thriving careers in the UK space sector.