Senior BI Engineer (Fabric & PBI)

Job Title: Senior BI Engineer (Fabric & PBI)
Duration: 6-9 Months
Location: Manchester - 2days per week (3 days remote)
IR35 Status: Outside IR35
Rate: 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

• 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.

Essential Technical Skills

• 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.

Please note

• 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

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