Data Engineer

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

Job summary

Aptean is seeking a hands-on Data Engineer to design, build, and maintain a scalable enterprise data lakehouse using Microsoft Fabric. The role emphasizes medallion architecture, Delta Lake, and AI-ready data models to enable analytics, enterprise reporting, and AI-driven insights.

The ideal candidate will be strong in data modeling, lakehouse technologies, and have experience deploying reliable data pipelines across multiple sources.

Qualifications

• Solid understanding of SQL and data modeling.
• Experience designing data platforms, warehouses, and lakehouses with modern ETL/ELT pipelines.
• Hands-on experience with Microsoft Fabric (Pipelines, Dataflows Gen2, Notebooks, Lakehouse).
• Knowledge of medallion architecture (bronze/silver/gold) and Delta Lake/OneLake concepts.

Responsibilities

• Design, build, and maintain scalable data lakehouse platforms to enable analytics and AI-driven insights.
• Develop reliable, distributed data pipelines integrating structured and unstructured data.
• Collaborate with stakeholders to translate business requirements into data models and pipelines.

Skills

SQL

Data modeling

ETL/ELT pipelines

Data Lakehouse design

Communication

Cross-functional collaboration

Tools

Microsoft Fabric

Delta Lake

OneLake

Azure DevOps

GitHub Actions

Job description

Overview

JOB DESCRIPTION:

APTEAN JOB LEVEL: B

APTEAN JOB TITLE: Data Engineer

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.

Work Experience

• 2-5 Year’s
• Knowledge, Skills, Abilities & Competencies
• Hands‑on experience in designing and implementing data platforms, including data warehouses, lakehouse, and modern ETL/ELT pipelines.
• Working knowledge of Microsoft Fabric (Pipelines, Dataflows Gen2, Notebooks, Lakehouse) is strongly preferred.
• Proven ability to build, deploy, and troubleshoot highly reliable, distributed data pipelines integrating structured and unstructured data from various internal systems and external sources.
• Working knowledge of the medallion architecture (bronze/silver/gold) and Delta Lake / OneLake concepts; prior project experience implementing this pattern is highly desirable.

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.

Solid understanding of SQL, relational and dimensional data modeling, query tuning, and basic performance optimization.

Familiarity with data quality concepts — null/duplicate/schema‑drift checks, basic SCD handling, and validation rules in transformation pipelines.

Familiarity with Git, branching strategies, and CI/CD concepts in a data engineering context (Azure DevOps or GitHub Actions).

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.

Required to work in shift: NO

If Yes Shift Timing: N/A

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.