Business Intelligence Developer

We are seeking an experienced Business Intelligence Developer to design, build and maintain data solutions that enable accurate, timely and secure business insights. The successful candidate will work across the full solution lifecycle to ingest, transform, model and present data using Microsoft Fabric, Power BI, PySpark and relational database technologies. You will collaborate with business stakeholders, BI and data teams, and technical partners to deliver scalable, governed and well-documented analytics solutions.

• Design, develop and maintain Microsoft Fabric solutions including Data Factory pipelines, Dataflow Gen2, notebooks, Lakehouse and Warehouse assets, and One Lake deployment practices.
• Implement scalable data preparation, transformation and validation using PySpark and Spark SQL.
• Develop and optimise advanced T-SQL queries, stored procedures and views; troubleshoot query and performance issues.
• Author Power BI reports and semantic models using Power Query, dimensional modelling and DAX; implement row-level security and report performance optimisation.
• Apply database management fundamentals: relational design, security, indexing, monitoring, backup and recovery concepts.
• Design and operate data warehousing solutions (star schemas, slowly changing dimensions, medallion architecture) and ETL/ELT patterns with orchestration, incremental loading, error handling, audit logging and reconciliation.
• Follow Dev Ops and source control practices for versioning, peer review, release management and controlled deployments.
• Support data governance practices including data quality, metadata, lineage, access control and protection of sensitive information.
• Engage with stakeholders to translate business requirements into sustainable technical solutions and provide documentation and production support as required.

• Four to six years of professional experience in business intelligence, analytics or data development.
• Proven hands-on experience developing production solutions with Power BI and T-SQL.
• Practical experience with Microsoft Fabric and PySpark or Spark SQL for data ingestion and transformation workloads.
• Experience managing or supporting relational databases and troubleshooting data, query and performance issues.
• Experience across the full solution lifecycle: requirements, design, development, testing, deployment, documentation and support.
• Bachelor’s degree or diploma in Computer Science, Information Systems, Data Science, Engineering or a relevant field, or equivalent demonstrable BI development experience.

• Microsoft Fabric
• Azure Data Factory
• Dataflow Gen2
• Notebooks
• Lakehouse
• One Lake
• Py Spark
• Spark SQL
• T‑S‑QL
• Power BI
• Power Query
• Dimensional modelling
• DAX
• Semantic models
• Row-level security
• Report performance optimization
• Relational database design
• Database security
• Indexing
• Database monitoring
• Backup and recovery
• Data warehousing
• Star schema
• Slowly changing dimensions
• Medallion architecture
• ETL
• ELT
• Orchestration
• Incremental loading
• Error handling
• Audit logging
• Data reconciliation
• Dev Ops
• Source control
• Data governance
• Data quality
• Metadata management
• Data lineage
• Access control
• Data protection
• SQL
• Analytical thinking
• Stakeholder engagement
• Technical communication
• Agile methodologies
• Problem solving
• Attention to detail
• Independent work
• Collaboration
• Azure Dev Ops
• Azure Data Lake Storage
• SSRS
• Python
• MRI Property Management System
• Fraxion Spend Management

Hybrid working arrangement with flexibility. Busy delivery or support periods may require extended hours to meet deadlines, complete releases or restore critical services.

Internal: business stakeholders, BI and data teams, business analysts, application support,…