About the Role
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.
Responsibilities
•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.
Requirements
•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.
Conditions / Benefits
•Hybrid working policy: flexibility to work from home two days a week, with opportunities to collaborate in modern offices across the UK.
•Virtual GP service giving access to an NHS or Irish Medical Council GP at a time and place that suits you.
•Reasonable workplace adjustments for those in need.
•Gymflex scheme offering up to 40% off annual gym memberships through the WSP flexible benefits program.
•Comprehensive menopause support package.
•"WSP My Hour" — one hour each day for personal activities, with flexibility to make up the time earlier or later that day.
•Part-time and flexible working arrangements.
•Option to purchase additional leave.
•Ability to use bank holiday entitlement flexibly.
•Supportive environment investing in growth through training, mentoring, or Chartership.
