At a Glance
- Tasks: Lead data analytics and governance to drive insightful decision-making across the organisation.
- Company: Join a forward-thinking company focused on data-driven solutions.
- Benefits: Competitive salary, flexible working, and opportunities for professional growth.
- Other info: Collaborative environment with opportunities for travel and diverse projects.
- Why this job: Make a real impact by enhancing data quality and driving business intelligence.
- Qualifications: Degree in Data Science or related field; experience in BI and data governance required.
The predicted salary is between 60000 - 75000 € per year.
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 enhance 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.
Business Intelligence and Database Lead employer: BGIS UK & Europe
As a leading employer in the field of data analytics, we offer a dynamic work environment that fosters innovation and collaboration. Our commitment to employee growth is evident through comprehensive training programmes and opportunities to work with cutting-edge technologies like Power BI and cloud platforms. Located in the vibrant South of England, our team enjoys a supportive culture that prioritises work-life balance while driving impactful data-driven decision-making across the organisation.
StudySmarter Expert Advice🤫
We think this is how you could land Business Intelligence and Database Lead
✨Tip Number 1
Network like a pro! Reach out to folks in the industry on LinkedIn or at events. A friendly chat can lead to opportunities that aren’t even advertised yet.
✨Tip Number 2
Show off your skills! Create a portfolio of your best Power BI dashboards and data models. When you get an interview, bring it along to demonstrate what you can do.
✨Tip Number 3
Prepare for those tricky questions! Brush up on your knowledge of data governance frameworks and ETL processes. Being able to discuss these confidently will set you apart.
✨Tip Number 4
Don’t forget to apply through our website! It’s the best way to ensure your application gets seen by the right people. Plus, we love seeing candidates who are proactive!
We think you need these skills to ace Business Intelligence and Database Lead
Some tips for your application 🫡
Tailor Your CV:Make sure your CV is tailored to the Business Intelligence and Database Lead role. Highlight your experience with Power BI, SQL, and data governance frameworks. We want to see how your skills align with our needs!
Craft a Compelling Cover Letter:Your cover letter is your chance to shine! Use it to explain why you're passionate about data analytics and how you can contribute to our team. Keep it concise but impactful – we love a good story!
Showcase Your Projects:If you've worked on any relevant projects, don’t hold back! Include links or descriptions of dashboards you've created or data models you've built. This gives us a taste of your hands-on experience and creativity.
Apply Through Our Website:We encourage you to apply through our website for a smoother process. It helps us keep track of applications and ensures you get all the updates directly from us. Plus, it’s super easy!
How to prepare for a job interview at BGIS UK & Europe
✨Know Your Data Inside Out
Make sure you’re well-versed in the data analytics and governance frameworks mentioned in the job description. Brush up on your knowledge of Power BI, SQL databases, and cloud platforms like Snowflake. Being able to discuss specific examples of how you've used these tools will show that you're not just familiar with them, but that you can apply them effectively.
✨Showcase Your Problem-Solving Skills
Prepare to discuss past experiences where you’ve tackled complex data challenges. Think about how you’ve optimised data integrity or implemented ETL processes. Use the STAR method (Situation, Task, Action, Result) to structure your answers, making it easy for the interviewer to see your thought process and impact.
✨Demonstrate Collaboration
This role involves working with various teams, so be ready to share examples of how you’ve successfully collaborated in the past. Highlight any experience you have with cross-departmental projects or how you’ve communicated complex data insights to non-technical stakeholders. This will show that you can bridge the gap between technical and operational teams.
✨Prepare Insightful Questions
At the end of the interview, you’ll likely have the chance to ask questions. Prepare thoughtful queries about the company’s data governance frameworks or how they envision the future of their data analytics capabilities. This not only shows your interest in the role but also your strategic thinking regarding data-driven decision-making.
