Senior BI Engineer

Southern Water group; Worthing; Hybrid; GBP 50,000 - 61,000; Full time

Benefits offered by this job

Hybrid working

Office in Worthing or Brighton

Job summary

Southern Water is seeking a Senior BI Engineer to lead Databricks and Power BI initiatives, focused on Gold-layer data products, semantic models and scalable analytics across the organisation. You will work in a domain-focused agile squad with Data Modellers and Data Engineers, contributing to robust data solutions and governance.

This hybrid role offers two days in the office weekly at Durrington (Worthing) or Falmer (Brighton), with a hands-on mentoring approach and opportunities to shape data

Qualifications

• 5+ years in BI engineering or related data roles.
• Strong Databricks experience (SQL, Python, PySpark).
• Experience delivering Gold-layer data products.
• Strong Power BI semantic modeling and performance optimization.
• Relational and dimensional data modelling skills.
• Experience with ETL/ELT, Delta Lake, data lake tech.
• Knowledge of data governance, metadata, security/privacy.
• Experience with source control and automated deployments.
• Strong troubleshooting and cross-functional collaboration.
• Ability to translate KPI definitions into technical solutions.

Responsibilities

• Design and maintain Gold-layer data products in Databricks.
• Develop pipelines for Gold-layer data products.
• Create reusable semantic and dimensional models.
• Develop and optimize Power BI models, reports, dashboards.
• Translate KPI definitions into technical logic.
• Verify data availability and quality throughout development.
• Apply governance, security, privacy principles.
• Establish source control and deployment practices.
• Collaborate with Data Modellers, Engineers and stakeholders.
• Provide mentoring to BI Engineers.

Skills

Databricks

SQL

Python

PySpark

Power BI

Semantic modeling

Dimensional modeling

Version control

Data governance

Tools

Databricks

Power BI

DAX

Job description

Closing Date 2026-09-30

Job Title: Senior BI Engineer

Location: Durrington (Worthing) or Falmer (Brighton), with hybrid working requiring two days per week in the office

Hours: 37 hours per week

Salary: Around £55,000 plus benefits

Shape the future of data and analytics

We're looking for an experienced Senior BI Engineer to join our Data & Analytics team. This is a hands-on senior technical role spanning both Databricks and Power BI. You'll develop scalable Gold-layer data products in Databricks, alongside semantic models and Power BI solutions that provide trusted, reusable analytics across the organisation. Working within a domain-focused agile squad, you'll collaborate closely with Data Modellers, Data Engineers and business stakeholders. BI Engineering is responsible for Gold-layer data products, semantic models and Power BI solutions, while Data Engineering owns upstream ingestion and the Bronze and Silver layers. You'll work closely with Data Engineers where upstream design, data availability or data quality affects the analytical solution. You'll also provide technical guidance and mentoring to other BI Engineers, helping strengthen engineering practices while remaining directly involved in solution design and delivery.

What you'll be doing

Designing, building and maintaining scalable Gold-layer data products in Databricks using SQL, Python and PySpark. Developing and maintaining the supporting pipelines required to deliver Gold-layer data products, working with Data Engineering on upstream Bronze and Silver dependencies. Designing reusable semantic and dimensional models, including facts, dimensions, relationships and measures. Developing and optimising Power BI semantic models, reports and dashboards using DAX, Power Query and appropriate performance optimisation techniques. Translating agreed KPI definitions, business rules and reporting requirements into accurate, reusable and maintainable technical logic. Validating proposed solution designs, data availability and data quality before and during development. Applying appropriate data quality, governance, metadata, lineage, security, privacy and performance principles across BI solutions, including row-level security where required. Establishing effective source control, deployment, release, monitoring and troubleshooting practices for BI solutions. Working with Data Modellers, Data Engineers, QA colleagues and business stakeholders to deliver complex data and analytics requirements. Documenting Gold-layer data products, semantic models, calculations, report logic and technical dependencies. Providing technical guidance and mentoring to BI Engineers and contributing to the continuous improvement of BI engineering standards and practices.

What we’re looking for

You'll have demonstrable experience delivering complex BI and analytics solutions and be comfortable working across both the data and presentation layers of a modern analytics platform. You'll be able to take technical ownership of solutions, challenge designs where necessary and work collaboratively with engineering and business colleagues to deliver reliable, maintainable analytics.

Essential experience

• 5+ years' experience in BI engineering, analytics engineering, data development, data engineering or a related discipline, including delivery of complex BI or analytics solutions.
• Strong hands-on Databricks experience, including SQL, Python and PySpark.
• Experience designing and delivering Gold-layer data products in Databricks or a comparable modern lakehouse platform.
• Strong Power BI experience, including semantic modelling, DAX, Power Query, report development and performance optimisation.
• Strong relational and dimensional data modelling skills, including the design of reusable semantic models.
• Experience translating agreed KPI definitions, business rules and reporting requirements into robust and maintainable technical solutions.
• Experience with modern data platforms and data pipeline concepts, including ETL/ELT, Delta Lake and data lake technologies.
• Experience applying data quality, governance, metadata, lineage, security and privacy principles to BI and analytical solutions.
• Experience validating data availability, accuracy, completeness and consistency and working with Data Engineers and other colleagues to resolve issues.
• Experience using source control, code repositories, release management and automated deployment practices.
• Strong troubleshooting and diagnostic skills across data, pipelines, semantic models, refresh, security and performance.
• Experience understanding business processes and underlying source systems and translating that knowledge into appropriate technical solutions.
• Demonstrable experience providing technical guidance, mentoring colleagues and improving engineering practices.
• Strong communication skills and experience working with technical and business stakeholders.

Desirable

• Microsoft Certified: Power BI Data Analyst Associate, Fabric Analytics Engineer Associate or equivalent certification.
• Databricks Data Engineer Associate or equivalent certification.
• Experience with data governance and metadata tooling such as Microsoft Purview.
• Relevant professional training or certification in areas such as data governance, privacy, agile delivery or technical leadership.

Why join us?

This is an opportunity to join a growing BI Engineering team at a time when Southern Water is investing heavily in its Data & Analytics capabilities. We offer a flexible hybrid working model, with only two days per week in the office and the choice of working from either our Durrington (Worthing) or Falmer (Brighton) offices. Both locations offer excellent transport links. Durrington is approximately a 10-minute walk from Goring-by-Sea station, with direct rail services to Brighton and London, whilst Falmer is only a short train journey from central Brighton. Both offices are set within the South Downs, providing an attractive working environment while remaining easily accessible from across Sussex and the South Coast.

You'll join a collaborative team that values trusted data, engineering quality, continuous improvement and helping each other succeed. We believe the best solutions are delivered when people work together, share knowledge and challenge constructively. Southern Water is at the forefront of transforming Britains water industry, investing significantly to enhance resilience, sustainability, and service excellence. With £7.8bn planned investment for 2025-30, this is an unparalleled opportunity to join a business committed to delivering a generational shift in the way water services are managed.

You will be joining at a time of significant change, working alongside a highly skilled leadership team with a clear vision for the future. We offer an environment where senior professionals can make a meaningful impact, influence major strategic decisions, and drive long-term value creation.

Our Commitment to Diversity

We welcome applicants from all backgrounds, identities, and experiences. We do not discriminate based on race, ethnicity, gender, sexual orientation, age, disability, religion, or any other protected characteristic. If you need reasonable adjustments during the recruitment process, please let us know.

Additional information

In line with Southern Water’s security requirements, successful candidates will be required to provide evidence of their identity, eligibility to work in the UK, criminal record check (DBS) and verification of their employment and/or education history for the past three years. Appointment to this role is subject to the successful completion of all pre-employment checks, including security vetting. Please note that if a candidate does not meet the required security standards or fails to pass the vetting process, Southern Water reserves the right to withdraw the offer of employment. Some positions may also require higher levels of security vetting, which may involve providing additional documentation.

Our purpose is big. Our impact is huge. And we know that every single one of us has the power, through our actions, to positively change society and the environment for good. It’s why careers with us have real meaning. Because, if you’re driven and ambitious, we can offer you huge opportunities for personal growth, professional development and constant innovation.

Forever evolving. Forever focused on doing the right thing, we empower and encourage everyone to play to their strengths and to help us shape a fair and positive future for all.

We believe in Water for Life. If you do too, Dive Right In. Our customers are at the heart of everything we do, because delivering water for life is our core purpose. To achieve this, we need 24/7 support in place to resolve incidents quickly and efficiently. All our employees understand the importance of out-of-hours incident support, because when problems appear, fixing them is our top priority. That’s why our people join together and support when and however needed to make sure our customers get the service they deserve. Joining the Southern Water family means you’ll become part of our incident support team. During your interview, your manager will speak to you about any incident support rotas that apply to your position.