Business Intelligence and Database Lead

London
5 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

Recruitment Resource Specialist

Forensic Investigator

Senior Digital Technologist

Lead Data/Head of Data Engineer

Graduate Technical Engineer / Technical Consultant

Data 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 Robotics Tools Do You Need to Know to Get a Robotics Job?

If you’re pursuing a career in robotics, it can feel like the list of tools you should learn never ends. One job advert asks for ROS, another mentions Gazebo, another wants experience with Python, Linux, C++, RobotStudio, MATLAB/Simulink, perception stacks, control frameworks, real-time OS, vision libraries — and that’s just scratching the surface. With so many frameworks, languages and platforms, it’s no wonder robotics job seekers feel overwhelmed. But here’s the honest truth most recruiters won’t say explicitly: 👉 They don’t hire you because you know every tool — they hire you because you can apply the right tools to solve real robotics problems reliably and explain your reasoning clearly. Tools matter — but only in service of outcomes. So the real question isn’t how many tools you should know, but which tools you should master and why. For most robotics roles, the answer is significantly fewer — and far more focused — than you might assume. This article breaks down what employers really expect, which tools are core, which are role-specific, and how to focus your learning so you look capable, confident, and ready to contribute from day one.

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

Robotics is one of the most dynamic, interdisciplinary fields in technology — blending mechanical systems, embedded software, controls, perception (AI/vision), modelling, simulation and systems integration. Hiring managers in this space are highly selective because robotics teams need people who can solve real-world problems under constraints, work across disciplines, and deliver safe, reliable systems. And here’s the reality: hiring managers do not read every word of your CV. Like in many tech domains, they scan quickly — often forming a judgement in the first 10–20 seconds. In robotics, those first signals are especially important because the work is complex and there’s a wide range of candidate backgrounds. This guide unpacks exactly what hiring managers look for first in robotics applications and how to optimise your CV, portfolio and cover letter so you stand out in the UK market.

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

Robotics is no longer confined to science fiction or isolated research labs. Today, robots perform critical tasks across manufacturing, healthcare, logistics, agriculture, defence, hospitality and even education. In the UK, businesses are embracing automation to improve productivity, reduce costs and tackle labour shortages. Yet despite strong interest and a growing number of university programmes in robotics, many employers report a persistent problem: graduates are not job-ready for real-world robotics roles. This is not a question of intelligence or dedication. It is a widening skills gap between what universities teach and what employers actually need in robotics jobs. In this article, we’ll explore that gap in depth — what universities do well, where their programmes often fall short, why the disconnect exists, what employers really want, and how you can bridge the divide to build a thriving career in robotics.