Data and Analytics Engineer, Enablement

Zensar Technologies Limited is seeking a highly skilled Data and Analytics Engineer to enable data engineers and analysts through best‑practice data engineering in Microsoft Fabric and Databricks, and to create high‑quality Power BI visualisations. The role collaborates with stakeholders to translate business needs into robust data products, semantic models, and self‑service analytics, while driving modernisation of legacy BI assets and exploring AI‑driven insights.

• Build and maintain bronze, silver, and gold lakehouse layers in Microsoft Fabric and Databricks using notebooks and PySpark.
• Implement incremental loading and change‑data‑capture pipelines from on‑prem SQL sources to Fabric/Databricks, optimizing Delta tables for performance and cost.
• Translate business requirements into analytical specifications, define KPIs, and validate data product outputs during SQL‑to‑Lakehouse modernization.
• Design and govern Fabric semantic models and star schemas to support performant Power BI self‑service reporting.
• Develop, optimize, and maintain interactive Power BI dashboards, including complex DAX calculations, row‑level security, and usage monitoring.
• Create reusable Python scripts, CI/CD pipelines, and automation for data processing, report generation, and integration with external APIs.