Data Engineering Lead

Job Description

Purpose of the Role

The Azure Data & Integration Architect will lead enterprise-wide data and integration initiatives, leveraging Microsoft Azure and Databricks to drive digital transformation, operational efficiency, and data-driven decision-making. This role focuses on architecting scalable data pipelines, designing a unified lakehouse platform, enabling advanced analytics, and integrating enterprise systems across SAP and non-SAP landscapes.

Key Responsibilities

Data Architecture & Analytics

\n
• Implement Unity Catalog for governance, data lineage, and access control.
\n
• Design and deploy enterprise data models and analytical layers using Azure.
\n
• Enable enterprise reporting and self-service analytics through Power BI integration.
\n
• Manage both structured and unstructured data using Azure Blob Storage and Azure Data Lake Storage Gen2.
\n
• Collaborate with data scientists and business teams to enable machine learning and predictive analytics use cases.
\n
• Define and enforce data architecture standards, naming conventions, and performance best practices.
\n

Integration & Enterprise Connectivity

\n
• Design and implement integrations between SAP and non-SAP systems using SAP CPI, Azure API Management, and REST/SOAP APIs.
\n
• Ensure secure and scalable data flow across on-premises, cloud, and hybrid environments.
\n
• Implement API authentication and security protocols (OAuth 2.0, JWT, SAML).
\n
• Integrate enterprise applications with Azure Entra ID for identity and access management.
\n
• Establish reusable integration patterns and frameworks for enterprise-wide adoption.
\n

Governance, Security & Compliance

\n
• Ensure data quality, lineage, and governance across the analytics ecosystem.
\n
• Implement security and compliance controls aligned with GxP, 21 CFR Part 11, and corporate IT policies.
\n
• Monitor cost and performance optimization across Azure services.
\n
• Oversee DevOps and CI/CD pipelines for automated deployment and testing using Azure DevOps.
\n

Leadership & Collaboration

\n
• Collaborate closely with cross-functional IT, data, and business teams.
\n
• Conduct technical design reviews, mentor developers, and ensure adherence to architectural standards.
\n
• Support vendor evaluations, solution assessments, and proof-of-concept initiatives.
\n
• Communicate complex technical concepts effectively to senior management and business stakeholders.
\n

Education & Qualifications

\n
• Bachelors or Masters degree in Computer Science, Information Technology, or related field.
\n
• MBA is a plus.
\n

Mandatory Requirements

\n
• Minimum 6+ years of experience in data analytics, engineering, and enterprise integration.
\n
• Proven experience architecting enterprise-scale data platforms on Azure.
\n
• Strong hands-on expertise in Azure Databricks (PySpark, Delta Lake, Unity Catalog).
\n
• Proficiency in Azure Data Factory, Azure Synapse Analytics, Power BI, Blob Storage, and Data Lake Gen2.
\n
• Experience integrating SAP systems (S/4HANA, SuccessFactors, MES, LIMS, CRM) with Azure and other platforms.
\n
• Proficient in integration technologies (SAP CPI, Azure API Management, middleware platforms).
\n
• Deep understanding of data security and identity protocols (OAuth, JWT, SAML) and Azure Entra ID.
\n
• Familiarity with GxP-compliant data handling and governance practices.
\n
• Strong proficiency in Python, PySpark, and SQL, hands on experience in writing clean, efficient and scalable code
\n

Desirable Requirements

\n
• Experience in pharmaceutical manufacturing and regulatory environments. Exposure to Azure DevOps, Terraform, or ARM templates for infrastructure automation.
\n
• Knowledge of modern data architecture principles (Lakehouse, Data Mesh, ELT).
\n
• Experience with Agentic AI, preferably using Microsoft AI technologies
\n

Preferred Certifications

\n
• Microsoft Certified: Azure Solutions Architect Expert
\n
• Microsoft Certified: Data Engineer Associate
\n
• Microsoft Certified: Identity and Access Administrator Associate
\n
• Preferred Industry Experience
\n
• Pharmaceutical Manufacturing
\n
• Regulated Environments (GxP, FDA, ISO)
\n