Analyst - Data

A little more about your role…

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

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

What we will be looking for you to demonstrate…

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.

Desirable Skills

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