Business Intelligence Developer

The Opportunity:

Rimes is looking for a BI Developer to help own the Microsoft Fabric platform behind our internal reporting. It brings together data from multiple systems and feeds the Power BI reports used across the business. Reporting to the Head of BI, you will make the platform more robust, move older pipelines onto our layered architecture, and keep the semantic models on top of it healthy. As those foundations go in, you will help us move towards AI-mediated development, with more of our pipelines built by AI.

Core Responsibilities: 

• Fabric Development: Build and maintain the dataflows, pipelines and lakehouses behind the platform, and deliver new sources and fields for stakeholders. 
• Robust Ingestion: Strengthen the Power Query (M) that loads data from REST APIs, with dependable pagination, retries and incremental loads, so that failures are caught rather than passed downstream. 
• Platform Operations: Own scheduled refreshes and pipeline runs, fix failures at their root, and add alerting and data-quality checks. 
• Security and Access: Move credentials into managed connections and secret storage, and maintain workspace access and row-level security. 
• Semantic Model Upkeep: Keep the Power BI semantic models healthy as the data layer changes: fix refreshes, repoint sources, and maintain DAX measures and relationships. 
• Migration and Simplification: Move older pipelines onto our layered architecture, replace copied logic with shared components, and retire what is no longer needed. 
• Release Management: Introduce source control, deployment pipelines and separate development and production environments. 
• Documentation: Write runbooks and design notes so that anyone on the team can support the platform. 
• Platform Evolution: Help move transformation logic into SQL and Python in Fabric notebooks where it makes the platform easier to maintain. 
• AI-Mediated Development: Use AI tools in your day-to-day work, and build the standards, templates and checks that let AI build and change pipelines safely.

Requirements: 

Core Experience 

• 3–5 years in BI development or data engineering, mostly on the Microsoft data platform. 
• Experience supporting production pipelines and semantic models, including fixing failures at their root cause. 
• Experience taking over and improving solutions built by others. 
• A methodical, ownership-minded approach and clear communication. 
• A genuine interest in AI-assisted development and where it adds the most value. 

Technical Skills 

• Microsoft Fabric: Hands-on with Dataflow Gen2, Data Pipelines, Lakehouses and OneLake. 
• Power Query (M): Strong M; comfortable debugging and optimising complex queries written by others. 
• REST APIs: Pagination, rate limits, OAuth and token authentication, and incremental loads. 
• Semantic Models and DAX: Star schemas, relationships, storage modes and row-level security, with good DAX (filter context and iterators) to read, fix and extend measures.