Data Engineer

What if you could do the kind of work the world needs? At WSP, you can access our global scale, contribute to landmark projects and connect with the brightest minds in your field to do the best work of your life. You can embrace your curiosity in a culture that celebrates new ideas and diverse perspectives. You can experience a world of opportunity and the chance to shape a career as unique as you.

We are seeking a Data Engineer with a strong focus on database management to join our growing geospatial and data team. You will be ready to take responsibility for the design, maintenance, optimisation, and governance of databases that underpin critical analytics, reporting, and solutions across major land and infrastructure projects. You’ll be accountable for ensuring our data platforms are resilient, secure, scalable, and aligned with business needs.

• 
  
• 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.
  
• Build and maintain ETL/ELT pipelines using tools such as Azure Data Factory.
  
• Develop and deploy SSMS and SSRS custom reports for operational and strategic insight.
  
• Build robust data models for Power BI and support analysts with well‑structured datasets.
  
• Use Python, R and others as preferred or required, for automation, data transformation, and advanced analytics.
  
• 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.
  

• 
  
• 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.
  

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

• 
  
• 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, R, 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.
  

Don’t quite meet all the criteria? Apply, and we can see how your experience aligns to this role and other opportunities within the team.

At WSP, we understand that work is just one aspect of your life. It’s important to make time for you, your family, friends, interests and your community. 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.

We welcome applicants with varied backgrounds and experiences. We enable rewarding careers by encouraging people to bring their whole and authentic selves to work so that our work represents the fullest spectrum of society. We celebrate integrity and treat people with respect, supporting each other and embracing a culture of inclusion and belonging at WSP. We have our employee resource groups bring together employees and allies with different backgrounds to promote our culture of inclusivity.

• 
  
• We are committed to supporting our people, giving you the tools to make improvements to your health and wellbeing through our Thrive programme.
  
• 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.
  
• 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.
  

We understand the importance of development and training to you. That’s why we foster a supportive environment that invests in your growth, whether through training, mentoring, or Chartership.

We are one of the world’s leading engineering and professional services firms. Our 72,800 passionate people are united by the common purpose of creating positive, long‑lasting impacts on the communities we serve through a culture of innovation, integrity, and inclusion. With over 9,000 professionals across the UK and Ireland, we are dedicated to our local communities and propelled by international brainpower.

We positively encourage applications from suitably qualified and eligible candidates regardless of sex, race, disability, age, sexual orientation, gender reassignment, religion or belief, marital status, pregnancy or maternity/paternity. As a Disability Confident leader, we will interview all disabled applicants who meet the essential criteria; please let us know if you require any workplace adjustments in support of your application.