Analyst - Data

WSP
Noida, Bengaluru, Mumbai
Full timeFunction: Data Analytics & Business IntelligenceExperience: 3-5 yearsSkills: ["Problem-solving","Customer focus","Accountability","Proactive mindset","Clear communication"]

Own and optimize SQL Server databases that power analytics, reporting, and data-driven solutions across major land and infrastructure projects. Build and maintain ETL/ELT pipelines (including Azure Data Factory), develop SSMS/SSRS custom reports, and deliver Power BI datasets. Partner with solution architects and technical teams to translate requirements into scalable database solutions, ensuring data governance, secure access, reliability, and performance. Support geospatial data workflows using PostGIS/SQL Server spatial and GIS tools.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
WSP
WSP
2 days ago

Analyst - Data

✓ Verified Job

Canonical indexed version, validated from employer's careers page.

Source: Company careers pageValidated by: Fursa AI
Last checked: 13 hours agoStatus: Live

Job Summary

Own and optimize SQL Server databases that power analytics, reporting, and data-driven solutions across major land and infrastructure projects. Build and maintain ETL/ELT pipelines (including Azure Data Factory), develop SSMS/SSRS custom reports, and deliver Power BI datasets. Partner with solution architects and technical teams to translate requirements into scalable database solutions, ensuring data governance, secure access, reliability, and performance. Support geospatial data workflows using PostGIS/SQL Server spatial and GIS tools.
Location: Noida, Bengaluru, Mumbai
Employment Type: Full time
Job Function: Data Analytics & Business Intelligence
Seniority: Mid level

Key Responsibilities

  • •Lead the design, construction, and optimization of SQL Server databases supporting core applications and reporting.
  • •Own database schema, data models, indexing strategies, and performance tuning.
  • •Manage data ingestion pipelines and integrations to ensure reliable, accurate, high-quality data flow.
  • •Oversee database governance, documentation, security standards, and access controls.
  • •Build ETL/ELT pipelines and reporting solutions (SSMS/SSRS) and support Power BI data models for analysts; troubleshoot and improve performance and reliability.

Key Requirements

  • •3–5 years’ experience in data engineering with demonstrable database ownership or administration responsibilities.
  • •Strong proficiency in SQL Server (schema design, indexing, optimization, 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:3-5 yearsData engineeringData managementGISGeospatialBig dataAEC
Skills:Problem-solvingCustomer focusAccountabilityProactive mindsetClear communication
Certifications:Azure Data Engineer Associate
Languages:US
Tech Stack:SQL ServerSQLPythonRPower BISSRSSSMSETLELTAzure Data FactoryAzure SynapseAzure Data LakePostGISQGISArcGISSparkHadoopKafkaGISCI/CD

Company Brief

WSP
Global professional services firm providing engineering, consulting, and technical services across infrastructure, environment, buildings, transportation, and energy sectors for public- and private-sector clients worldwide.
Industry: Professional Services
Company Size: Enterprise (1,001+ employees)
Revenue: USD 1B+
Growth: Public Company
Valuation: Public Company (Market Cap in USD)
Funding: IPO / Publicly Listed
Headquarters: Montreal, Canada
Founded: 1959
WebsiteLinkedIn