SQL/ Python Developer

Title:

About KBR and the Project

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.

About the Role

TheDeveloperwill report to the Lead Developerand 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. TheDeveloper 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.

Required Qualifications, Experience & Skills

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.