Data Architect

Dr Lal PathLabs; Gurugram District; On-site; INR 2,500,000 - 4,000,000; Full time

Job summary

Dr Lal PathLabs in India seeks a data engineer to own the end-to-end analytics stack on Azure, ingest and model data with ADF/Synapse/Databricks, and deliver high-impact Power BI dashboards with standardized KPIs.

The role emphasizes Azure-based data engineering, ELT/ETL pipelines, semantic models, governance, and robust BI delivery. 7–10 years of experience and a BTech/MTech qualification required.

Based in Gurugram, India, with on-site responsibilities and collaboration across business teams.

Qualifications

• 7–10 years of hands-on data engineering experience.
• BTech or MTech degree.
• Hands-on experience with Synapse/Databricks is mandatory.
• Strong Azure data platform skills including ADF, Synapse, Databricks.
• Experience designing ELT/ETL pipelines and scalable data models.

Responsibilities

• Own end-to-end analytics stack on Azure and deliver governed semantic models.
• Build and optimize ETL/ELT pipelines and dimensional models.
• Develop Power BI dashboards with fast load times and KPIs.
• Ensure governance, security, and CI/CD of BI assets.
• Collaborate with cross-functional teams and present insights.

Skills

Azure Data Factory (ADF)

Azure Synapse

Databricks

PySpark

T-SQL

Power BI

Data Modeling

Data Governance

Education

BTech/MTech

Tools

Azure Data Factory

Azure Synapse

Databricks

Power BI

ADLS

SQL Server

MySQL

MongoDB

Job description

SCOPE OF WORK:

Own the end-to-end analytics stack on Azureingest and model data (ADF/Synapse/Databricks), build governed semantic models, and deliver high-impact Power BI dashboards with rock-solid performance and standardized KPIs.

ROLE & RESPONSIBILITIES:

Data Engineering (Azure)

• Design, develop, and maintain ELT/ETL pipelines in Azure Data Factory (parameterized pipelines, datasets, dataflows).
• Perform advanced extraction and transformation from structured & unstructured sources (SQL Server, MySQL, MongoDB/NoSQL, files/APIs).
• Write and optimize T-SQL (queries, UDFs, views, indexes, CTEs, procs, triggers).
• Build and maintain dimensional models (star/snowflake) and data-warehouse layers; apply proper partitioning and indexing.
• Work with large datasets using Azure Synapse, Databricks, PySpark for processing and analysis.
• Participate in code reviews, troubleshooting, and performance tuning across data solutions.
• Collaborate with cross-functional teams to produce model-ready tables for dashboards and ad-hoc analysis.

Power BI (Semantic Layer & Dashboards)

• Design, develop, and deliver interactive Power BI datasets and reports with strong DAX and Power Query (M).
• Translate business requirements into scalable semantic models, KPIs, and effective visualizations; apply UI/UX best practices and data storytelling.
• Handle large/complex datasets with incremental refresh, composite/aggregation models, and VertiPaq optimizations for fast load times.
• Communicate insights clearly to non-technical stakeholders; proactively improve existing reporting solutions.
• Automate report operations with Power Automate; create Paginated Reports using Power BI Report Builder where needed.

Governance, Security & Operations

• Enforce dataset/report governance: certified datasets, RLS/CLS, workspace policies, usage monitoring.
• Maintain lineage, documentation, and SLA/SLO awareness; drive consistent metric definitions across teams.
• Support CI/CD (Git/ALM Toolkit/Tabular Editor/DAX Studio), gateway management, and environment promotion (Dev/Test/Prod).

COMPETENCIES:

• Strong Azure expertise: ADF, Synapse, Databricks, ADLS; solid T-SQL and PySpark/Python.
• Proven dimensional modelling, schema design, indexing, and performance tuning across data and BI layers
• Ability to convert ambiguous business asks into reliable datasets and impactful dashboards.
• Excellent communication, presentation, and data-storytelling skills; self-driven and solution oriented.

WHAT WE ARE LOOKING FOR:

• Experience: 7-10 years total in Data Engineering.
• Qualification: BTech/MTech
• Prior Experience/Background: Hands-on Synapse/Databricks experience mandatory