Senior BI Engineer (Fabric & PBI)

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., * 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

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