Job Title: Data Engineer – Data Integration & Automation

Location: New Delhi, India

Experience: 3-6 years

About MARS Cosmetics:

MARS Cosmetics is a globally recognized beauty brand that thrives on innovation, diversity, and empowering individuals through high-quality beauty solutions. Headquartered in Recent Delhi, MARS Cosmetics is committed to offering groundbreaking products that meet the ever-evolving needs of consumers worldwide.

About the Role:

We are looking for a hands-on Data Engineer to build and maintain the data infrastructure powering analytics, AI and automation at MARS Cosmetics.

You will be responsible for integrating data from multiple business systems, developing reliable data pipelines, structuring datasets and ensuring seamless data availability for automated analytics and AI applications.

You will work closely with the Analytics Lead – Data, AI & Automation to build scalable systems that transform fragmented business data into actionable intelligence.

Key Responsibilities:

1. Data Integration & Engineering

- Build and maintain automated data pipelines connecting ERP, marketplaces, Shopify, distributor systems, marketing platforms and internal applications.
- Develop integrations using Python, SQL, REST APIs, webhooks and database connections.
- Design efficient ETL/ELT processes for data extraction, transformation and storage.
- Implement incremental data synchronisation, error handling and automated monitoring.

2. Data Architecture & Management

- Design and maintain structured databases, data warehouses and analytical datasets.
- Clean, standardise and reconcile data across multiple sources.
- Ensure data accuracy, consistency, accessibility and reliability.




- Develop reusable data models to support business analytics, reporting and AI applications.

3. Python Automation & Analytics Enablement

- Write Python and SQL scripts for automated data processing, transformation and analytical calculations.
- Develop reusable functions and data services for automated business analysis.
- Support event-driven monitoring, anomaly detection and automated reporting workflows.
- Make structured datasets accessible to AI tools and LLMs through secure APIs and controlled data interfaces.

4. Engineering & Collaboration

- Collaborate with the Analytics Lead and existing Automation & AI team to develop scalable data solutions.
- Implement automated testing, pipeline monitoring and performance optimisation.
- Maintain clear technical documentation and version-controlled code.
- Independently troubleshoot data inconsistencies, integration failures and performance issues.

Required Skills:

- Python: Strong proficiency in Pandas, scripting, API integrations and data processing.
- SQL: Advanced querying, joins, aggregations, database design and optimisation.
- Databases: Experience with PostgreSQL, MySQL, SQL Server or equivalent.
- Data Engineering: Hands-on experience developing ETL/ELT pipelines and integrating multiple data sources.
- APIs & Automation: Experience with REST APIs, authentication,



data synchronisation and scheduled workflows.
- Engineering Practices: Git, debugging, automated testing and production deployment.

Good to Have:

- Experience with Azure, Microsoft Fabric, dbt, Airflow, Dagster or equivalent tools.
- Familiarity with LLM APIs and AI-powered analytical applications.
- Experience working with e-commerce, FMCG, retail or ERP datasets.

Ideal Candidate:

- A strong hands-on engineer who enjoys building reliable data systems.
- Has independently designed, developed and deployed production data pipelines.
- Comfortable handling large, fragmented and inconsistent datasets.
- Strong problem-solving ability with attention to data accuracy and reliability.
- Resourceful, execution-oriented and comfortable working in a lean, fast-moving team.
- Interested in leveraging AI and modern development tools to accelerate engineering workflows.

What Success Looks Like: Within the first 90 days, you should have:

- Integrated priority business data sources into a centralised analytical platform.
- Built reliable, automated data pipelines with appropriate monitoring and error handling.
- Developed clean, standardised and reusable datasets supporting business analytics.
- Enabled the Analytics Lead to build automated, AI-powered insights on top of trustworthy data.

Why Join MARS?

- Opportunity to build the data infrastructure for a rapidly growing Indian cosmetics brand.
- Work on real-world engineering challenges across e-commerce, sales, supply chain and finance.
- Significant technical ownership and freedom to adopt modern tools and technologies.
- Be part of a lean team building AI-native business intelligence capabilities.

📌 Data Engineer – Data Integration & Automation (Delhi)
🏢 MARS Cosmetics
📍 Delhi