Data Engineer

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

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.