Designs, builds, and operationalizes scalable enterprise data solutions using Azure, Databricks, PySpark, and SQL. Responsibilities include architecting data pipelines, modeling lakehouse layers, automating integrations and testing, optimizing workloads, managing metadata and governance, and enabling BI and advanced analytics. The role leads technical reviews, mentors engineers, gathers stakeholder requirements, supports self-service analytics, and contributes to data platform roadmaps while ensuring compliance with GxP, HIPAA, and GDPR.
The Lead Data Engineer will design, build, and operationalize scalable data solutions to support enterprise analytics and AI/ML initiatives. This role requires expert-level proficiency in Databricks, Azure Fabric, PySpark, SQL, and the Azure ecosystem, with deep experience across data warehouses, data lakes, and real-time integration. The Lead Data Engineer will architect end-to-end pipelines using industry-standard tools, drive automation, and move solutions effectively into production. The incumbent will ensure compliance with data governance requirements (including GxP and HIPAA/GDPR) while building reusable, integrated pipelines and analytical models that promote self-service analytics. This role provides technical leadership across the team, mentors junior engineers, and partners with business stakeholders to align data engineering with organizational objectives.
About the Role
- Architect, design, and implement end-to-end data solutions using Azure Databricks, PySpark, Azure Data Factory, and Azure SQL.
- Design, build, and maintain data pipelines from data sources through integration to consumption for specific use cases.
- Implement robust data modeling standards across bronze, silver, and gold layers in the data lake.
- Develop data models (conceptual, logical, and/or physical) as required.
- Optimize Spark and SQL workloads for performance, scalability, and cost efficiency.
- Manage metadata using data preparation, integration, and AI-enabled tools and techniques.
- Drive automation in data integration; recommend and lead implementation of techniques to automate repeatable data preparation and integration tasks.
- Build API-based integrations (REST/JSON) and real-time ingestion frameworks.
- Automate data workflows using Azure DevOps pipelines and Git-based CI/CD practices.
- Implement parameterized, reusable pipeline templates for ingestion and transformation.
- Develop automated unit, regression, and integration testing frameworks for data jobs.
- Prepare and curate high-quality datasets for BI, reporting, and advanced analytics.
- Partner with analytics teams using Power BI, Tableau, or similar platforms to define semantic models and KPIs.
- Implement performance-optimized data models for self-service analytics.
- Will occasionally provide support to end users on the use of data visualization solutions.
- Lead technical design reviews, mentor junior engineers, and promote best practices.
- Assist cross-functional groups, business analysts, and stakeholders to gather, define, and refine data requirements.
- Collaborate with business and IT stakeholders to align data engineering with organizational objectives.
- Propose innovative data ingestion, preparation, and integration techniques to address stakeholder requirements.
- Contribute to architectural roadmaps and technology evaluations for the data platform.
- In collaboration with functional leaders, identify inefficiencies and recommend improvements to the executive team.
. Data Architecture & Engineering
. Data Integration & Automation
. Analytics & Data Enablement
Stakeholder Engagement & Leadership
About You
- Expert-level proficiency in Databricks, Azure Fabric, PySpark, SQL, and Azure DevOps.
- Proven experience with Azure Data Factory, ADLS Gen2, and Azure SQL Server.
- Strong experience with Microsoft Azure data management architectures including Data Warehouse, Data Lake, and Data Catalogue, and supporting processes such as Data Integration, Governance, and Metadata Management.
- Experience with Power BI required; Tableau or Looker a plus.
- Working knowledge of CI/CD automation, version control (Git), and infrastructure as code (ARM, Bicep, or Terraform).
- Experience in life sciences or healthcare industries is a strong plus.
- Good understanding of GxP, GDPR/HIPAA, and applicable CFR/CTR/CTD regulations.
- Demonstrated success working with both IT and business stakeholders while integrating analytics and data science output into business processes and workflows.
- Must have excellent written and verbal communication skills.
- Proven ability to work independently and as part of a team and meet important deadlines.
- Statistical analysis skills are an asset.
Job Experience & Education Requirements:
Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field (Master’s preferred)
And
5–8 years of experience designing and developing enterprise-scale data solutions (data warehouses, data lakes, operational databases)
Other:
Similar Jobs
Logistics • Transportation
Designs, builds, and maintains ETL/ELT pipelines feeding Microsoft Fabric Lakehouse platforms. Responsibilities include data ingestion, bronze/silver/gold layer development, CDC, incremental loading, data quality, metadata governance, performance tuning, monitoring, automation, and low-level design documentation. The role collaborates with architects, data modelers, and business analysts to deliver reliable, reusable datasets and promote self-service analytics while applying security, resilience, compliance, and cost-optimization standards.
Top Skills:
SparkAWSAzureAzure Event HubsCi/CdDelta LakeFabric Dataflows Gen2KafkaMicrosoft FabricMicrosoft PurviewOnelakeParquetPythonScalaSpark NotebooksSQLSql NotebooksVersion Control
Big Data • eCommerce
Build and maintain end-to-end data pipelines using PySpark and SQL on Databricks/Delta. Establish data modeling and pipeline best practices, create AI-ready analytical datasets, troubleshoot pipeline issues, and collaborate with stakeholders to embed business logic and optimize reliability, efficiency, and performance.
Top Skills:
AirflowDatabricksDbtDeltaDelta LakeETLPysparkSnowflakeSparkSQL
Other
As a Data/ML Engineer, you will design and implement data pipelines, optimize workflows for unstructured data, and integrate LLM frameworks to power analytics and BI solutions.
Top Skills:
SparkAWSAzure Machine LearningHadoopHugging Face TransformersKafkaLangchainLlamaindexPlsqlPythonRedshiftSnowflakeSQL
What you need to know about the Pune Tech Scene
Once a far-out concept, AI is now a tangible force reshaping industries and economies worldwide. While its adoption will automate some roles, AI has created more jobs than it has displaced, with an expected 97 million new roles to be created in the coming years. This is especially true in cities like Pune, which is emerging as a hub for companies eager to leverage this technology to develop solutions that simplify and improve lives in sectors such as education, healthcare, finance, e-commerce and more.
