Data Engineer

A little more about your role…

We are seeking a Data Engineer to help design, build and evolve enterprise and geospatial data platforms that support major infrastructure, planning, environmental and land projects across the UK. This role combines data engineering, cloud technologies, database architecture and geospatial data management within a growing digital team delivering innovative solutions to complex client challenges.

Working within a growing geospatial and data practice, you'll help build data platforms that support some of the UK's most significant infrastructure, energy, planning and land projects. You'll combine cloud data engineering, database architecture and geospatial data management to underpin decision-making at scale.

You’ll be accountable for ensuring our data platforms are resilient, secure, scalable, and aligned with business needs.

Database Ownership & Architecture

• Lead the design, construction, and optimisation of SQL Server databases that support core business applications and reporting.
• Own the database schema, data models, indexing strategies, and performance tuning.
• Manage data ingestion pipelines and integrations, ensuring reliable, accurate, and high-quality data flow into the database.
• Oversee database governance, documentation, security standards, and access controls.

Data Engineering & Reporting

• Build and maintain ETL/ELT pipelines using tools such as Azure Data Factory.

• Develop reporting and data delivery solutions using Power BI, SSRS and other business intelligence tools.

• Build robust data models for Power BI and support analysts with well-structured datasets.
• , Experience with Python or similar scripting languages for automation, data transformation, and advanced analytics.

Collaboration & Stakeholder Engagement

• Act as the primary technical owner for the database (s) within multidisciplinary project teams.
• Translate business and project requirements into scalable database solutions.
• Troubleshoot issues and proactively improve performance, reliability, and usability.
• Work closely with solution architects and technical development teams

Desirable Geospatial & Domain Data

• Manage and optimise spatial datasets within PostGIS or SQL Server spatial components.
• Work with GIS teams to ensure high quality geospatial data feeds into applications and dashboards.

Join WSP at a time of growth and transformation, where you will be part of exciting developments and innovations in GIS on landmark projects across diverse sectors such as land management, property and planning, energy and transportation.

What we will be looking for you to demonstrate…

Strong technical skills in SQL Server databases, scripting (preferably Python), SQL, data management, and strong accountability behaviours along with a proactive, resilient mindset and exceptional problem-solving abilities are required. The ideal candidate will have a customer focused mindset to deliver exceptional outcomes for our clients.

• 3-5 years’ experience in data engineering with demonstrable database ownership or administration responsibilities.

• Strong proficiency in SQL Server: schema design, indexing, optimisation, monitoring, and performance tuning.

• Experience building ETL/ELT pipelines and integrating data from multiple systems.

• Hands-on experience with SSRS, SSMS, Python, and Power BI.

• Solid understanding of data governance, data quality frameworks, and secure access management.

• Experience with spatial databases (PostGIS or SQL Server spatial) and GIS tools (QGIS, ArcGIS).

• Ability to document systems clearly and communicate effectively with non-technical stakeholders.

Desirable Skills

• Exposure to big data tools such as Spark, Hadoop, or Kafka.

• Experience with Azure (Data Factory, Synapse, Data Lake) or AWS/GCP equivalents.

• Understanding of CI/CD, Git, and automated testing processes.

• Knowledge of BIM datasets and AEC digital workflows.

• Professional certifications in cloud or data engineering (e.g., Azure Data Engineer Associate).

You'll thrive in this role if you:

• Enjoy solving complex data challenges

• Like taking ownership of platforms and solutions

• Can translate business needs into technical outcomes

• Want to work on projects with visible real-world impact

BGV:

• Employment with WSP India is subject to the successful completion of a background verification (“BGV”) check conducted by a third-party agency appointed by WSP India.

• Candidates are advised to ensure that all information provided during the recruitment process - including documents uploaded - is accurate and complete, both to WSP India and its BGV partner”.