SQL/ Python Developer
Role details
Job location
Tech stack
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.
Requirements
Do you have experience in Visual Studio?, 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.