Business Intelligence and Database Lead

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 organisations 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 datadriven decisionmaking 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 selfservice 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 adhoc 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.
Businesswide 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)
Masters 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. DAMADMBOK DCAM).
Knowledge of GDPR ISO 27001 or other data compliance standards.

Experience (Essential)
Minimum 35 years experience in Business Intelligence data analysis or data governance.

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

Aptitudes
Strong analytical and problemsolving 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 selfmotivated 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