SQL/ Python Developer

KBR; Swindon; Hybrid; GBP 50,000 - 80,000; Full time

Job summary

KBR is recruiting a BI Developer for its Estates Intelligence team in Swindon. The role focuses on building and maintaining the Reporting Data Warehouse, developing ML algorithms within Fabric Notebooks, and creating BI datasets and pipelines.

You will ensure performance, quality, and governance across Dev/Test/Prod environments while supporting technical delivery. Based in Swindon, you will work in-office up to 3 days per week with occasional client-site travel.

Qualifications

• Strong SQL proficiency with experience in SSMS and data transformations.

Responsibilities

• Develop ML algorithms within Fabric Notebooks environment.
• Develop Power BI datasets, DAX measures and calculation logic.
• Configure and manage refresh schedules and gateway connections.
• Tune model performance and validate data across reports and dashboards.
• Support deployment and ensure governance across Dev/Test/Prod environments.
• Monitor daily pipeline runs and resolve failures.
• Provide documentation and promote changes through environments.

Skills

SQL

Python

Power BI

Fabric Notebooks

SSMS

Visual Studio

DevOps

Data analysis

Presentation

Tools

Power BI Desktop

Power BI Service

Fabric

CAFМ/Concept Evolution

Job description

The Developer will report to the Lead Developer and operate as part of the Estates Intelligence BI team. This team delivers data-driven insights across multiple projects, addressing estates and facilities challenges and enabling informed decision-making for both internal stakeholders and clients. The Developer builds onto and maintains the Reporting Data Warehouse, drives innovation projects, as well as creates and assures BI datasets and pipelines. The Developer also supports technical delivery and ensures solutions meet performance and quality standards.

Build & Configuration

• Develop machine learning algorithms within the Fabric Notebooks environment.
• Implement SQL queries, stored procedures and views for data transformations.
• Develop Power BI datasets, DAX measures and calculation logic to meet reporting needs.
• Configure and manage refresh schedules and gateway connections.

Testing & Quality Assurance

• Tune algorithm model performance, check relationships and visuals for responsiveness.
• Validate data accuracy and consistency across reports and dashboards.
• Document test results and remedy defects promptly.

Deployment & Documentation

• Prepare release notes and update technical documentation for all changes.
• Promote changes through Dev/Test/Prod environments in line with governance.

Operational Support

• Monitor daily pipeline runs and resolve failures.
• Escalate complex issues to the Lead Developer and contribute to root-cause analysis.

Continuous Improvement

• Suggest enhancements to improve efficiency, maintainability and scalability.
• Track new Power BI and Fabric features, as well as other development opportunities, and adopt best practice where relevant.

Essential

• Strong understanding of SQL using environments such as SSMS and Visual Studio.
• Profound knowledge of Python with experience in using the Fabric Notebooks environment.
• Able to identify trends and investigate underlying causes to address issues, highlight areas of concerns and identify best practice.
• Experience managing build, release, and deployment processes within a DevOps framework.
• Proven experience of Power BI - Desktop & Service - most importantly with knowledge of Fabric features such as Data Engineering, Factory & Science.
• Familiar with Power Suite.
• Proven analytical skills and utilisation of data to produce client reports.
• Skilled in presenting clear and concise information to a wide variety of audiences.
• Comfortable presenting findings to internal, external and client stakeholders at all levels.
• Hold or ability to obtain security clearance.

Desirable

• Experience in Web Development.
• Knowledge of App Development within .NET.
• Understanding of other ML languages.
• Experience of a broad scope of estates management reporting within a similar environment.
• Knowledge of Concept Evolution or other CAFM systems.

The role is based at Swindon and will be expected to be in the office up to 3 days per week. There will also be occasional travel to Client Sites required.

KBR are a global technical solutions provider with 28,000 employees worldwide, with operations in 34 countries delivering to customers in 80 countries. KBR work collaboratively with their wide customer base to deliver solutions that strive to create a better, safer and more sustainable world.

KBR's Estates Intelligence division specialise in enabling clients to make informed decisions about the operational and strategic management of their estates and asset portfolios, including the external supply chain retained to deliver asset management and maintenance services.

KBR has developed and implemented an innovative, cost-effective solution for the strategic management of estates and facilities services. The Estates Intelligence model and our 6 A methodology; Aggregation, Automation, Asset Management, Assurance, Audit and Analytics, enable the strategic management of estates and facilities services, which is an evolving model in the FM market.

As part of the ongoing growth of its Estates Intelligence, KBR is actively recruiting to expand its team to deliver current and future public sector Estates Intelligence contracts.