Senior BI Developer

Join a globally recognised group company with a portfolio of reputable international brands as a Senior BI Developer based in London. This is an exciting opportunity for an experienced BI professional to lead enterprise-level Power BI architecture, ERP data integration, and business-critical reporting solutions across multiple functions.

We are seeking a highly skilled candidate with 10+ years’ experience in Power BI development, advanced SQL Server expertise, strong ERP and ETL knowledge and proven experience building scalable semantic models and data infrastructure. The ideal candidate will combine strong technical capability with excellent problem-solving, communication, and stakeholder management skills.

Essential Skills and Experience

• 5 plus years UK based BI experience
• 10+ years in Power BI development with strong backend/data engineering focus.
• Advanced SQL Server expertise, including query optimisation, views, stored procedures, and performance tuning.
• Strong experience managing ERP data structures and integrations.
• Experience building and managing semantic models and enterprise datasets in Power BI.
• Strong knowledge of ETL processes, data transformation, and data modelling principles.
• Advanced DAX development and optimisation experience.
• Experience with Power BI gateways, dataflows, workspace management, and deployment pipelines.
• Strong understanding of BI governance, security models, version control, and documentation standards.
• Excellent troubleshooting and problem-solving skills.
• Advanced Excel and PowerPoint skills; experience working with ERP systems and large datasets.
• Strong communicator, good presentation skills, cross-functional collaborator, detail oriented and able to deliver strategic insights.

Key Roles and Responsibilities

• Power BI Architecture & Data Infrastructure
• Own and manage the end-to-end Power BI environment, including datasets, semantic models, gateways, dataflows, and reporting infrastructure.
• Design, build, and maintain scalable Power BI data models that support enterprise-wide reporting and analytics.
• Develop and manage ODBC connections and integrations between ERP systems, SQL Server databases, and Power BI environments.
• Control, optimise, and maintain SQL queries, stored procedures, and backend logic feeding the Power BI semantic layer.
• Ensure data models are performant, scalable, maintainable, and aligned with evolving business requirements.
• ERP Data Management & ETL Ownership
• Manage ERP data extraction processes and ensure reliable movement of data into reporting environments.
• Design and maintain ETL processes, data transformation pipelines, and data validation procedures.
• Develop robust data cleansing, mapping, and transformation logic to ensure data accuracy and consistency across systems.
• Troubleshoot and resolve data integrity, refresh, connectivity, and performance issues across the BI stack.
• Work closely with internal stakeholders to understand ERP structures, business logic, and reporting dependencies.
• SQL Development & Semantic Model Management
• Write, optimise, and maintain complex SQL queries and views supporting reporting and analytics.
• Build and manage enterprise semantic models within Power BI, ensuring consistency in KPI definitions and business logic.
• Develop and maintain advanced DAX calculations, measures, and performance optimisation strategies.
• Implement incremental refresh, partitioning, and other best-practice optimisation techniques where appropriate.
• BI Governance, Security & Best Practices
• Establish and maintain standards for BI governance, documentation, version control, testing, and deployment.
• Manage user access, row-level security, workspace structure, and data governance policies.
• Ensure reporting environments follow best practices for scalability, maintainability, and auditability.
• Create technical documentation covering data models, ETL processes, SQL logic, and reporting architecture.
• Reporting & Business Intelligence Support
• Support and enhance reporting capabilities across Sales, Operations, Finance, and Supply Chain teams.
• Partner with business stakeholders to translate reporting requirements into scalable technical solutions.
• Work alongside front-end dashboard/report developers to ensure reliable and efficient backend data delivery.
• Provide technical leadership and act as the internal subject matter expert for Power BI infrastructure and BI data architecture.

What’s in It for You?

• £55,000 to £60,000 per annum (depending on qualifications & experience)
• 25 days of annual leave + bank holidays
• Additional days holiday between Christmas and New Year if the Directors decide to close the business
• Standard working hours 9 to 5:30 - 30 min lunch = 40 hours a week
• 1-day WFH after probation and training at the company’s sole discretion (non-contractual)
• Workplace Pension Scheme
• 60% Discount on our products that we have on Ecommerce
• Sample sales 2+ times a year
• Short Leave – with pre-approval from Line Manager to take up to 2 hours off without deduction from holiday allowance
• Statutory sick pay
• Annual pay review and/or bonus at the Directors discretion

If you have all the essential requirements and are ready for your next challenge, contact Louise at 121 Personnel.