Data Engineer

Data Engineer

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.

Responsibilities

We are seeking a Data Engineer with a strong focus on database management to join our growing geospatial and data team. This role is ideal for someone 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.

Key responsibilities include:

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

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.

Qualifications

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

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

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.