Lead BI Engineer

1.
Technical Ownership of BI Solutions Leads technical design and implementation within agreed architecture and design standards. 2.
Design Authority & Best Practice Contributes to the design authority for data modelling, visualisation, and BI patterns, contributing to standards and ensuring consistent, high-quality approaches across the team. 3.
Stakeholder & Product Leadership Works closely with product, performance, and business stakeholders to shape requirements, supports KPI definition and success criteria, and ensure BI products deliver meaningful outcomes. 4.
Delivery Leadership & Risk Management Supports reliable delivery by identifying technical risks, dependencies, and constraints early, and guiding teams to pragmatic, timely solutions. 5.
Data Quality, Trust & Governance Applies agreed validation and quality approaches and escalates data trust or security concerns through established governance routes. 6.
Coaching & Capability Development Supports BI Engineers and Junior Engineers, sharing expertise, reviewing work, and raising technical capability within the BI engineering team. 7.
Continuous Improvement & Innovation Drives ongoing improvement in BI tooling, patterns, and practices, identifying opportunities to simplify, automate, and enhance the BI estate. Key Internal Stakeholders & Relationships * Operational Stakeholders * Performance teams * Business Intelligence & Insight team * Business Finance teams * Business Planning (WFM) teams * Technology Data & Analytics team * Technology Platform teams * Senior Operational Leaders Key External Stakeholders & Relationships * Operational system providers and Platform partners * External consultants (where applicable) Essential • A degree level qualification (or equivalent practical experience) in Data Analytics, Statistics, Computer Science, or a related discipline. • Significant experience working in data or analytics roles within a complex organisation, delivering BI solutions across multiple business areas or workstreams. • Proven, in-depth experience designing and delivering enterprise-scale business intelligence solutions, ideally using Power BI. • Advanced analytical capability with strong experience in data visualisation, storytelling, and UX design for insight delivery. • Demonstrated experience producing executive-level insight, including shaping narrative, defining KPIs, and supporting strategic decision-making. • Advanced proficiency in analytics and visualisation tools (e.g.
Power BI, advanced Excel; Tableau optional). • Extensive practical experience designing dimensional data models, applying Kimball methodologies, and creating reusable semantic layers. • Strong SQL expertise, including writing and reviewing complex queries for data extraction, validation, and transformation. • Proven experience ensuring data quality, trust, and governance, including validation approaches, testing strategies, and peer review. • Experience acting as technical lead or design authority, reviewing others' work and setting best-practice patterns for BI delivery. • Strong stakeholder engagement skills, with experience shaping requirements, challenging assumptions, and translating business needs into scalable BI products. • Experience supporting reliable delivery within an Agile-oriented or hybrid delivery environment, including managing technical risks and dependencies. • Experience coaching, mentoring, or guiding BI Engineers and Junior BI Engineers, or equivalent roles, to raise overall team capability. • Experience working closely with BI Managers, senior stakeholders, or Delivery Leads to shape roadmaps, priorities, and delivery approaches. • Experience monitoring BI usage and performance metrics and driving product iteration based on adoption and feedback. • Experience with Power BI Service administration and governance, including workspace strategies, dataset endorsement, access models, and deployment pipelines. • Experience designing or contributing to BI standards, including modelling conventions, visualisation frameworks, or delivery patterns. Desirable • Advanced experience writing and optimising complex SQL (CTEs, window functions, performance tuning). • Experience with automation or orchestration tools (e.g.
Power Automate) to support BI delivery, quality, or operational efficiency. • Exposure to modern cloud data platforms (e.g.
Azure data services, Databricks, Synapse, Fabric) and their use in analytics architectures. • Exposure to designing data models that are optimised for Generative AI consumption to support natural language querying and prompt driven insight generation. Maximus Competencies • Partners Effectively • Creates Innovative Solutions • Focuses on the Customer • Demonstrates Compassion • Takes Responsibility & Acts with Integrity Individual competencies Business Understanding • Demonstrates deep understanding of business strategy, priorities, and operational drivers across multiple domains. • Frames BI products in terms of measurable business outcomes, service performance, and organisational impact. • Proactively identifies trends, risks, and opportunities in data beyond stated requirements and challenges assumptions where needed. • Guides others in focusing on value, not just outputs. Stakeholder Engagement • Maintains relationships with stakeholders for complex or high-impact BI products. • Leads discovery and requirement-shaping conversations, helping stakeholders clarify outcomes, KPIs, and success criteria. • Manages expectations confidently, balancing ambition, delivery reality, and technical constraints. • Acts as a trusted technical advisor, bringing a solution-focused and constructive approach to discussion. Analytical Thinking & Problem Solving • Leads analysis of complex, ambiguous problems and defines the analytical approach. • Investigates complex data patterns, anomalies, and edge cases with rigour and persistence. • Uses data to test hypotheses, challenge narratives, and guide strategic choices. • Supports others in applying analytical thinking effectively through collaboration. Data Modelling & Logical Design • Contributes to the design authority for data models, ensuring consistency, scalability, and reuse across products. • Designs and reviews dimensional models, grain decisions, and relationships aligned to business logic. • Anticipates downstream reporting, performance, security, and reuse implications of design decisions. • Leads and contributes to the definition and maintenance of standardised KPI definitions and semantic models. Data Visualisation & Storytelling • Designs advanced, narrative-driven dashboards aligned to personas and decision journeys. • Sets and evolves visualisation and UX standards, ensuring consistent application across the team. • Applies strong UX/UI Lead s, including progressive disclosure, accessibility, and clarity at scale. • Reviews and challenges visual design to maximise insight, trust, and usability. Technical Application • Provides technical leadership in the application of BI tools, SQL, and analytics techniques. • Selects and justifies the most appropriate technical approach for complex use cases. • Demonstrates deep understanding of refresh patterns, latency, dependencies, performance, and platform constraints. • Reviews and improves technical implementations produced by others. • Applies Generative AI tools effectively to accelerate the design, development, and refinement of BI products Data Quality & Attention to Detail • Leads on data quality and validation approaches across BI products. • Ensures accuracy, consistency, and integrity are embedded into design and delivery. • Applies appropriate handling for sensitive data, access control models, and privacy considerations. • Acts as an escalation point for data trust or security concerns. Delivery & Ownership • Provides delivery leadership from a technical perspective, identifying risks, dependencies, and constraints early. • Ensures BI solutions are delivered reliably, sustainably, and to agreed standards. • Works closely with Delivery Leads and BI Managers to support predictable delivery. • Balances short-term delivery with long-term technical health. Communication & Collaboration • Communicates complex technical and analytical concepts clearly to senior and non-technical audiences. • Provides clear direction, feedback, and constructive challenge to BI Engineers and Juniors. • Shares knowledge openly and promotes consistent best practice across teams. • Collaborates effectively with operational, delivery, platform, and performance teams. Learning Mindset & Adaptability • Supports colleagues through knowledge sharing, peer review, and collaborative problem solving. • Continuously improves standards, patterns, and approaches based on learning and feedback. • Adapts BI solutions and practices in response to changing business needs, data maturity, and technology. • Encourages experimentation and improvement while maintaining governance and quality. Travel Requirements • UK wide travel is required as needed to support business activities. EEO Statement • MAXIMUS is committed to developing, maintaining and supporting a culture of diversity, equity and inclusion throughout the recruitment process.
We know that feeling included has a dramatic impact on personal wellbeing and are working to ensure that no job applicant receives less favourable treatment due to any personal characteristic.
Advertisements for posts will include sufficiently clear and accurate information to enable potential applicants to assess their own suitability for the post.
• We are a Disability Confident Leader, thanks to our commitment to the recruitment, retention and career development of people with disabilities and long-term conditions.
The Disability Confident scheme includes a guaranteed interview for any applicant with a disability who meets the minimum requirements for a job.
When you complete your job application you will find a question asking you if you would like to apply under the Disability Confident Guaranteed Interview Scheme.
If you feel that you have a disability and apply under this scheme, providing that you meet the essential criteria for the job, you will then be invited for interview.
Your Guaranteed Interview application will only be shared with the hiring manager and the local resourcing team.
• Where reasonable, MAXIMUS will review and consider adjustments for those applicants who express a requirement for them during the recruitment process. Minimum Salary £ 45,000.00 Maximum Salary £ 58,625.00 *