Data Engineer

Data Engineer - Data Modeling/SAP Integration

Position Summary:

Our partner, a leading manufacturing and distribution company, is rebuilding its data architecture by integrating 13+ legacy ERP systems, including SAP, into a cloud-native lakehouse environment using Databricks. This is a hands-on opportunity for a data engineer who can model ERP data the right way. You'll design validated, business-aligned data layers, sales orders, invoices, inventory, procurement, and structure them for downstream analytics and reporting. You'll work in a modern stack (Databricks, Python, SQL, GitHub, CI/CD) and collaborate closely with analysts, BI leads, and stakeholders to turn messy SAP data into governed, reusable data products. You'll be expected to understand how ERP data maps to real business flows, not just how tables join. If you’ve built bronze-silver-gold pipelines and know how to turn chaotic SAP data into usable models without needing perfect specs, you’ll make an immediate impact here.

Experience and Education:

• 5+ years working in data engineering or analytics engineering roles
• Hands-on experience modeling data from SAP or other ERP systems
• Prior work building or supporting data marts for analytics/reporting
• Exposure to business domains like supply chain, commercial, or finance
• Experience in cloud-native data environments (Databricks preferred)
• Familiarity with modern dev workflows (CI/CD, GitHub, Agile)

Skills and Strengths:

• SAP data modeling
• ERP systems understanding
• Python
• SQL
• Data marts
• Databricks
• Source-to-target mapping
• Data validation
• Cloud data platforms
• CI/CD pipelines
• GitHub
• Data warehousing
• Data discovery
• Inventory & sales order modeling
• Business process comprehension
• Ad hoc analysis support
• Bronze/Silver/Gold layer design
• Agile collaboration
• Jira
• Data pipeline troubleshooting

Primary Job Responsibilities:

• Model and consolidate SAP and ERP data for analytics use
• Partner with analysts to define usable, business-aligned data products
• Build and maintain pipelines in Databricks (bronze/silver/gold layers)
• Validate data outputs against ERP systems to ensure accuracy
• Structure data marts that support domains like sales, supply chain, and finance
• Contribute to architecture and standardization of enterprise datasets
• Document model logic and ensure reproducibility
• Work with GitHub and CI/CD workflows to manage code and releases
• Collaborate with US- and India-based teams in an Agile environment
• Support the shift from ad hoc data pulls to governed, scalable solutions