Lead Data Engineer
Aptean · Bangalore
Source and collection record
Last observed by our collector: . This is not a manual review or a confirmation from the employer.
Employer requisition: 6767
Job type and experience labels are automated discovery categories. The employer determines eligibility. Original experience wording was not retained separately; check the current employer page.
Your application evidence checklist
Mark the statements you can support after reading the employer source. This checklist stays on this page; it does not score your eligibility or submit an application.
0 of 2 checks marked. Keep unresolved requirements as questions for the employer.
Collected role description
Overview<br><br><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Aptean is seeking a hands-on, results-driven Data Engineering professional 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.</span></p><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>PRINCIPAL DUTIES AND RESPONSIBILITIES</strong></span></p><ul style="margin-top: 0in;"><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Develop and maintain Delta Tables using the medallion architecture (bronze/silver/gold) to systematically cleanse, enrich, and standardize data for downstream consumption.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Design and build robust, scalable data ingestion pipelines using Microsoft Fabric (Pipelines, Dataflows, Notebooks) to integrate data from Business Applications and external APIs.</span></li></ul><ul style="margin-top: 0in;"><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Perform deep source system analysis to define ingestion strategies that ensure data reliability, consistency, and observability, while applying metadata-driven design for automation</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Implement comprehensive data quality checks (nulls, duplicates, schema drift, outliers, SCD types) and ensure data integrity across all transformation layers in the Lakehouse.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Apply governance practices including schema versioning, data lineage tracking, role-based access control (RBAC), and audit trails to ensure compliance, traceability, and secure data access.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Build semantic models and define business-aligned KPIs to support self-service analytics and dashboarding in Power BI and other BI platforms.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Structure the gold layer and semantic model to support AI/ML use cases, ensuring datasets are enriched, contextualized, and optimized for AI agent consumption.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Develop and maintain AI-ready run flows and access patterns to enable seamless integration between the Lakehouse and AI agents for tasks such as prediction, summarization, and decision automation.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Implement DevOps best practices for pipeline versioning, testing, deployment, and monitoring; proactively detect and resolve data integration and processing issues.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Collaborate cross-functionally with analysts, data scientists, and business users to ensure the data platform supports evolving needs for analytics, operational reporting, and AI innovation.</span></li></ul><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>JOB SPECIFICATIONS</strong></span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Education (Indicate the minimum level of education necessary for this position. Check all that apply and indicate specific degree as applicable to the side (e.g., Bachelor’s in Computer Science)</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Required Preferred Degree/Certification</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">☒ ☐ Bachelor’s degree</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☒ Master’s degree</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☐ Ph.D.</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☐ J.D. (law)</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☐ Certification:</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☐ Registration:</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☐ Licensure:</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"> ☐ ☐ Other:</span></p><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Work Experience: </strong>7-10 Year’s</span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Knowledge, Skills, Abilities & Competencies</strong></span></p><ul style="margin-top: 0in;"><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Proven ability to build, deploy, and troubleshoot highly reliable, distributed data pipelines integrating structured and unstructured data from various internal systems and external sources.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Experience implementing data quality frameworks including checks for nulls, duplicates, schema drift, outliers, and slowly changing dimensions (SCD types).</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Familiarity with data governance, including schema versioning, data lineage, access controls (RBAC), and audit logging to ensure secure and compliant data practices.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Working knowledge of data visualization tools such as Power BI with the ability to support and optimize semantic layers and KPI definitions.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></li><li style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">Experience with DevOps practices, including version control, CI/CD pipelines, environment management, and performance monitoring in a data engineering context.</span></li></ul><p style="margin: 0in 0in 0in .5in;"> </p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Shift details: </strong></span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Required to work in shift: YES</strong></span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>Shift Timing: 1pm to 10pm</strong></span></p><p style="margin-bottom: 0in;"> </p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;"><strong>About Aptean</strong></span><br /><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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 focused organizations. Aptean’ s compliance solutions are built for companies serving specific markets such as finance, healthcare, biotech and pharmaceuticals, over 10,000 highly specialized organizations in more than 20 industries and 80 countries rely on Aptean to streamline their everyday operations. </span></p><p style="margin-bottom: 0in;"><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">“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</span><br /><span style="font-family: arial, helvetica, sans-serif; font-size: 12pt;">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.</span></p>
Collected experience requirement
Experienced Professional