Lead Data Engineer

Aptean India; Bengaluru; On-site; INR 1,400,000 - 2,400,000; Full time

Job summary

Aptean is seeking a hands-on, results-driven Data Engineer to design, build, and maintain scalable Enterprise data lakehouse using Microsoft Fabric, following the medallion architecture. This role advances our data platform for analytics, reporting, and AI-driven insights.

The ideal candidate will have 7-10 years of data engineering experience, strong modeling skills, and hands-on work with lakehouse architectures, data governance, and CI/CD in a modern cloud environment.

Qualifications

• 7-10 Years of data engineering experience building scalable platforms.
• Deep expertise in data modeling, data lakehouse patterns and medallion architecture.
• Experience with governance, RBAC, and data lineage for secure, compliant data.
• Proficiency in DevOps, CI/CD, monitoring and data pipeline reliability.

Responsibilities

• Design, build and maintain scalable Enterprise data lakehouse using Microsoft Fabric.
• Develop and troubleshoot large-scale data pipelines integrating multiple data sources.
• Ensure AI/ML readiness of data models and optimize semantic layers for reporting.
• Collaborate with cross-functional teams and manage data governance and quality checks.

Skills

Data engineering

Medallion architecture

Data modeling

Data governance

DevOps practices

Data quality

Communication

Tools

Microsoft Fabric

Delta Lake

OneLake

Power BI

CI/CD pipelines

Job description

Overview

Aptean is seeking a hands-on, results-driven Data Engineer to design, build, and maintain scalable Enterprise data lakehouse using Microsoft Fabric, following the medallion architecture. This role is key to advancing our enterprise data platform, enabling analytics, Enterprise reporting, and AI-driven insights. The ideal candidate will have strong experience in data modeling, data lakehouse technologies, and a passion for leveraging AI to optimize and enrich data processes wherever possible.

Job Description

Work Experience

7-10 Year’s

Knowledge, Skills, Abilities & Competencies

• Deep expertise in data engineering with hands-on experience in designing and implementing large-scale data platforms, including data warehouses, lakehouse, and modern ETL/ELT pipelines.
• Proven ability to build, deploy, and troubleshoot highly reliable, distributed data pipelines integrating structured and unstructured data from various internal systems and external sources.
• Strong technical foundation in data modeling, database architecture, and data transformation techniques using medallion architecture (bronze/silver/gold layers) within Microsoft Fabric or similar platforms.
• Solid understanding of data lakehouse patterns and Delta Lake / OneLake concepts, with the ability to structure data models that are AI/ML-ready and support semantic modeling.
• Experience implementing data quality frameworks including checks for nulls, duplicates, schema drift, outliers, and slowly changing dimensions (SCD types).
• Familiarity with data governance, including schema versioning, data lineage, access controls (RBAC), and audit logging to ensure secure and compliant data practices.
• Working knowledge of data visualization tools such as Power BI with the ability to support and optimize semantic layers and KPI definitions.
• Strong communication and collaboration skills, with the ability to articulate complex data engineering solutions to both technical and non-technical stakeholders, and to lead cross-functional initiatives.
• Experience with DevOps practices, including version control, CI/CD pipelines, environment management, and performance monitoring in a data engineering context.

Shift Details

• Required to work in shift: YES
• If Yes Shift Timing: 1pm to 10pm.

About Aptean

At Aptean, our mission is to solve tomorrow’s unique challenges today with unrivaled, purpose-built software and superior customer experiences from people who care. Aptean is a global provider of mission-critical, industry-specific software solutions. Aptean’ s purpose-built ERP and supply chain management solutions help address the unique challenges facing process and discrete manufacturers, distributors and other ocused organizations. Aptean’ s compliance solutions are built for companies serving specific markets such as finance, healthcare, biotech and pharmaceuticals, over10,000 highly specialized organizations in more than 20 industries and 80 countries rely on Aptean to streamline their everyday operations.

“At Aptean, our global and diverse employee base is our greatest asset. It is through embracing and understanding our differences that we are able to harness our individual power to maximize the success of our customers, our employees and our company.” - TVN Reddy

Aptean pledges to promote a company culture where diversity, equity and inclusion are central. We are committed to applying this principle as we interact with our customers, build our teams, cultivate our leaders and shape a company in which any employee can succeed, regardless of race, color, sex, national origin, sexuality and gender identity, religion, disability or age. Celebrating our diverse experiences, opinions and beliefs allows us to embrace what makes us unique and to use this as an asset in bringing innovative solutions to our customer base.