Data Engineer

WSP
Mumbai, Bengaluru
Workplace: HybridFull timeFunction: Software EngineeringExperience: 7-10 yearsSkills: ["Multitasking","Independent work","Quality focus","Interpersonal skills"]

Design, build, and maintain the data engineering layer for a Microsoft Fabric platform, owning end-to-end pipelines from API/file ingestion through to clean, modeled, AI-ready datasets. Create and optimize Data Factory pipelines, Python ETL, Spark/Python notebooks, and Dataflows Gen2 transformations. Build Bronze-to-Silver and Silver-to-Gold modeling, implement incremental/CDC patterns, ensure data quality, and develop Power BI Direct Lake semantic models to support reporting and decisions.

Loading

Loading job details...

Preparing the role view and application actions.

FursaFursa
WSP
WSP
1 month ago

Data Engineer

✓ Verified Job

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

Source: Company careers pageValidated by: Fursa AI
Last checked: 4 hours agoStatus: Live
Reposted: similar role first listed 3 months ago

Job Summary

Design, build, and maintain the data engineering layer for a Microsoft Fabric platform, owning end-to-end pipelines from API/file ingestion through to clean, modeled, AI-ready datasets. Create and optimize Data Factory pipelines, Python ETL, Spark/Python notebooks, and Dataflows Gen2 transformations. Build Bronze-to-Silver and Silver-to-Gold modeling, implement incremental/CDC patterns, ensure data quality, and develop Power BI Direct Lake semantic models to support reporting and decisions.
Location: Mumbai, Bengaluru
Workplace: Hybrid
Employment Type: Full time
Job Function: Software Engineering
Seniority: Mid level

Key Responsibilities

  • •Build and maintain Data Factory pipelines for API-based ingestion using REST and OData.
  • •Develop Python ETL scripts and Spark/Python notebooks for custom extraction, transformation, and SQL-based logic.
  • •Create Dataflows Gen2 (Power Query) pipelines to handle messy Excel/CSV data.
  • •Implement incremental loads, watermarking, and CDC patterns; integrate data sources into Fabric and manage Bronze-to-Silver and Silver-to-Gold transformations.
  • •Build and optimize Power BI semantic models (Direct Lake), prepare reporting datasets, monitor pipeline/platform capacity and costs, and maintain technical documentation.

Key Requirements

  • •Must have minimum 7-10 years of experience.
  • •Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, Data Factory, Dataflows Gen2, Notebooks, OneLake).
  • •Strong ETL and transformation skills using Python and SQL, including notebook development.
  • •Experience designing star schemas with fact/dimension modeling and slowly changing dimensions (SCD).
  • •Ability to manage pipeline reliability and quality using incremental loads, watermarking, and CDC patterns.
Experience:7-10 years
Skills:MultitaskingIndependent workQuality focusInterpersonal skills
Certifications:Microsoft Fabric DP 600Microsoft Fabric DP700
Tech Stack:Microsoft FabricLakehouseWarehouseData FactoryDataflows Gen2OneLakePythonETLSparkPySparkSQLPower QueryExcelCSVMicrosoft DataversePower BIDAXDirect LakeStar SchemaSlowly Changing Dimensions (SCD)

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