🌎
This job posting isn't available in all website languages
📁
Lead Software Engineer
📅
CREQ262766 Requisition #

We are seeking a highly skilled Data Engineer to engineer and deliver domain-
aligned data products within a centrally governed Microsoft Data Platform.
Working within established standards, CI/CD templates, and defined data contracts,
the Data Engineer will modernize SQL-driven legacy workloads and re-engineer
them into scalable Spark-based Lakehouse datasets and semantic models.
The focus is on execution extracting embedded business logic from on-prem SQL
systems, implementing robust data pipelines, and delivering reliable, high-quality
data products that support analytics, reporting, and AI use cases.

Data products are treated as managed assets — version-controlled, tested,
monitored, and continuously improved to meet defined quality and performance
expectations.
Key Responsibilities
SQL Modernization & Legacy Refactoring
 Maintain and enhance existing SQL Server workloads (stored procedures,
views, ETL processes).
 Design and optimize semantic models in Fabric for enterprise analytics.
 Engineer star schemas and dimensional models for high-performance Power
BI reporting.
 Refactor legacy SSAS logic into scalable semantic layers.
 Ensure validated KPIs and business rules are consistently implemented.
 Balance performance, usability, and maintainability in semantic design.
Data Product Ownership
 Engineer data products that are reliable, discoverable, and consumption
ready.

Core skills and knowledge  7+ years of hands-on experience in data engineering within SQL-heavy or

enterprise data environments.
 Hands-on experience with Spark (PySpark preferred) for distributed data
transformation, Python notebooks.
 Solid understanding of dimensional modeling, including star schema and
Kimball-based methodologies.
 Experience in Azure Data Factory, Databricks, MS Fabric, ADLS Gen2 ,
Databricks , Spark , Airflow, purview

Desirable Skills  Any financial services / banking / capital market experience
Leadership and
Communication Skills

 Excellent facilitation and presentation skills with the ability to lead architecture
forums and stakeholder meetings.
 Strong influencing skills to drive adoption of architectural standards and modern
technologies.

Preferred Qualifications  Microsoft certifications (Azure Data Engineer, Fabric).
 Experience in distributed data processing environments.
.

Previous Job Searches

Similar Listings

Mumbai, Maharashtra, India

📁 Lead Software Engineer

Requisition #: CREQ260471

Mumbai, Maharashtra, India

📁 Lead Software Engineer

Requisition #: CREQ258083

Mumbai, Maharashtra, India

📁 Lead Software Engineer

Requisition #: CREQ258105