Data engineer for geospatial projects

This is a senior, hands-on technical delivery role and you will have autonomy over day-to-day engineering delivery within agreed priorities, standards and assurance arrangements. This role will be part of our growing Geospatial and Data team. You will be responsible for shaping and delivering data engineering solutions that support major infrastructure, planning, environmental, energy and transportation projects across the UK.

• Contribute to the development of, and promote adherence to, agreed standards and best practice in data engineering, database architecture and data governance, working with senior technical leadership.
• Drive continuous improvement and modernisation of existing solutions, challenging legacy approaches where more effective alternatives exist.
• Identify opportunities to introduce new technologies, automation and innovative ways of working.
• Support the development of a future-ready data ecosystem that aligns with WSP's digital ambitions.
• Lead day-to-day technical delivery of assigned data engineering projects or workstreams from concept through to delivery, with oversight and assurance from senior technical leadership
• Translate business challenges into practical, scalable technical solutions.
• Take responsibility for the quality, security and performance of assigned engineering deliverables, following agreed assurance processes and escalating significant risks or design decisions to the senior technical lead.
• Ensure projects are delivered to high standards of quality, security and performance.
• Engage confidently with clients and stakeholders, communicating both technical and non-technical concepts effectively.
• Design, build and optimise enterprise data platforms and data pipelines.
• Lead development of ETL/ELT processes using Azure and related technologies.
• Develop robust data models that support analytics, visualisation and decision-making.
• Champion automation and engineering best practices through scripting, testing and deployment pipelines.
• Support the evolution of cloud-based data solutions and modern analytics capabilities.
• Mentor and support junior engineers and analysts, helping to develop technical and professional skills.
• Foster a culture of learning, collaboration and continuous improvement.
• Share knowledge, contribute to agreed technical standards and support the growth of the wider digital and data community within WSP
• Work with GIS and digital specialists to develop integrated geospatial data solutions.
• Support the adoption of innovative technologies across digital delivery workflows.
• Explore opportunities to leverage advanced analytics, automation and emerging technologies to enhance project outcomes.

• Experience in data engineering with demonstrable database ownership or administration responsibilities.
• Experience in data engineering, database architecture or enterprise data platform delivery.
• Strong expertise in SQL Server, database design, optimisation and performance tuning.
• Experience designing and implementing ETL/ELT solutions and data integration architectures.
• Strong Python development skills for automation, data transformation and analytics.
• Experience working with Azure data technologies such as Azure Data Factory, Synapse Analytics and Data Lake.
• Excellent communication and stakeholder management skills.
• Experience mentoring, coaching or developing junior colleagues.
• Strong organisational skills with the ability to manage competing priorities and deliver outcomes.
• A proactive mindset with a passion for continuous improvement and innovation.

• Our hybrid working policy offers the flexibility to work from home two days a week, while also providing opportunities to collaborate in our modern offices across the UK.
• Our Virtual GP service gives you access to an NHS or Irish Medical Council GP at a time and place that suits you – giving you peace of mind and quick access to medical advice when you need it most.
• We also provide reasonable workplace adjustments for those in need.
• Additionally, you can benefit from the Gymflex scheme, which offers up to 40% off annual gym memberships through our WSP flexible benefits program, as well as a comprehensive menopause support package.
• To enhance work-life balance, WSP offers the “WSP My Hour,” allowing you to take one hour each day for personal activities, with the flexibility to make up the time earlier or later that day.
• We also provide part-time and flexible working arrangements, the option to purchase additional leave, and the ability to use your bank holiday entitlement to suit you.
• That’s why we foster a supportive environment that invests in your growth, whether through training, mentoring, or Chartership.