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)

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