Senior BI Engineer (Fabric & PBI)

Project overview

Job Title: Senior BI Engineer (Fabric & PBI)

Project details

6-9 Months

Manchester - 2days per week (3 days remote)

IR35 Status: Outside IR35

Competitive Market Rate (Dependent on Experience)

We are seeking a hands-on Senior BI Engineer (Fabric & PBI) to independently build and deliver an end-to-end Microsoft Fabric solution. The project involves automating the ingestion of weekly CSV files from an SFTP server, structuring the data via a pragmatic medallion architecture, and delivering a commercial, production-quality Power BI dashboard featuring robust trend and forecasting capabilities.

Key Deliverables

Essential Technical Skills

Please note

Robert Walters Operations Limited is an employment business and employment agency and welcomes applications from all candidates

• Data Ingestion: Automate secure weekly SFTP file retrieval complete with file validation, duplicate controls, automated monitoring, and failure alerts.
• Medallion Architecture: Build a Fabric-based data pipeline:
• Bronze: Retain raw source files with load metadata, audit history, and replay capabilities.
• Silver: Apply light-touch cleansing, validation, and standardisation on the largely structured source dataset.
• Gold: Create business-ready dimensional models, custom measures, and forecast-ready datasets optimised for analytics.
• Power BI & Analytics: Design and deploy executive and analytical views covering value, volume, growth, channel, region, category, product, and pack performance.
• Forecasting: Develop practical weekly trend, seasonality, and forecasting outputs, integrated with basic accuracy and bias monitoring.
• Delivery & Governance: Provide strong stakeholder communication, comprehensive technical documentation, and structured knowledge transfer.
• Data Engineering: High proficiency in Microsoft Fabric, Data Factory, Lakehouse, OneLake, and Delta Lake.
• Pipeline Orchestration: Proven experience with SFTP ingestion, incremental loads, Python/PySpark, and advanced SQL.
• Data Governance: Strong implementation of logging, monitoring, data quality checks, lineage, and access controls.
• Power BI Ecosystem: Advanced Power BI Desktop/Service, strong DAX, Power Query/M, star schemas, semantic models, and deployment pipelines.
• Applicants for this Senior BI Engineer (Fabric & PBI) role must show production-level evidence of SFTP-to-cloud ingestion, Microsoft Fabric medallion architecture, and advanced Power BI delivery
• Also applicants must live a commutable distance to Manchester
• Start: Late November 2026
• Duration: 6-9 Months
• Remote: hybrid
• Location: Manchester, UK, GB
• Languages: English