Data Engineer
Indexed description
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.
Create a free Caio profile to unlock more results and save your role and location preferences.
Unlock free search