Data Automation Engineer

About Us

At Lean Kitchen Network (LKN), we're not just making food—we're redefining the culinary landscape. We partner with global brands like Twisted, Heinz, Doritos, PepsiCo, and Unilever to create and scale innovative food concepts. With over 300+ locations serving our brands, we work with kitchen operators, hotels, universities, and retailers to enhance customer experiences and drive profitability.

By joining LKN, you'll be part of a fast-growing, industry-leading company that turns everyday spaces into culinary destinations.

Why Join LKN?

• Work directly with top global brands and shape food trends.
• Join a dynamic, fast-paced environment where innovation meets execution.
• Gain hands-on experience managing multiple databases and data integrity, with support and mentorship to develop your analytical skills.

The Role

We are seeking a Data Automation Engineer to strengthen our data infrastructure and streamline how Finance and Central Operations manage and exchange data.

Your initial focus will be a one-off project to modernise our current Excel/VBA-based invoicing process — replacing manual workflows with an automated and scalable data pipeline. Once this is successfully delivered, your ongoing responsibility will be to develop and maintain our wider data automation, ETL processes, and system scalability to support both Finance and Operations teams.

This is a hands-on role at the intersection of data engineering and business operations, ideal for someone who enjoys improving real-world business processes through smart automation.

Key ResponsibilitiesPhase 1 – System Modernisation (Initial Project)

• Review the existing Excel/VBA process used for partner invoicing and transaction reporting.
• Design and implement a new automated solution to generate invoices and detailed transaction reports directly from structured data.
• Rebuild existing macro-based logic into clean, maintainable code (e.g. Python + SQL).
• Collaborate with Finance to ensure that custom calculations and manual adjustments can still be applied where needed.
• Deliver a robust, documented solution that improves speed, accuracy, and scalability.

Phase 2 – Ongoing Data Automation & Scalability

• Build, manage and document data pipeline (ETL/ELT) to consolidate data from Finance, Operations, and partner systems.
• Develop and maintain automated workflows for data processing and report generation.
• Ensure data integrity, consistency, and availability for dashboards and reporting.
• Continuously identify opportunities to improve automation, reduce manual work, and enhance transparency.
• Support and train Finance and Operations teams to adopt the new tools and workflows.

Required Skills & Experience

Technical Skills

• 2-4 years of professional work experience in data engineering and automation.
• Proficient in Python (including pandas, openpyxl, and PDF/report generation libraries).
• Strong command of SQL and experience with relational databases (PostgreSQL, MySQL, BigQuery or similar).
• Experience with data automation and workflow orchestration tools (e.g. Google Sheets API, Airflow, Prefect, Power Automate).
• Understanding of ETL/ELT design and structured data modelling.
• Experience generating PDF or Excel-based reports/invoices programmatically.

Business Understanding

• Familiarity with financial or operational data such as invoicing, reconciliation, and partner performance metrics.
• Ability to interpret and translate business rules into clear technical logic.
• High attention to detail and data accuracy.

Soft Skills

• Strong communication skills, with the ability to work effectively with non-technical stakeholders.
• Organised and proactive, comfortable managing both short-term deliverables and longer-term system improvements.
• Curious and driven to identify and implement better ways of working.

Preferred Qualifications

• Experience migrating legacy Excel/VBA processes into modern automated systems.
• Familiarity with Power BI, Tableau, or other visualisation tools.
• Experience integrating with APIs or working within cloud data environments (AWS, GCP, Azure).
• Background in Finance Operations, Data Engineering, or Business Automation.

This is an exciting opportunity for a Data Engineer who is passionate about system migration and automation to make a direct impact on LKN’s business growth and operational efficiency. You will have the chance to be part of our transformative journey, integrating AI into our sales, operations, finance, and marketing workflows.

Grow with LKN!

If you're ready to take the next step in your career in a supportive and fast-growing company, we’d love to hear from you!

Apply now and start your journey with LKN!

Job Types: Full-time, Contractual / Temporary, Freelance
Contract length: 12 months

Pay: ₹600,000.00 per year

Benefits:

• Work from home

Education:

• Bachelor's (Required)

Experience:

• Data science: 2 years (Required)
• Python: 2 years (Required)
• SQL: 2 years (Required)
• Database development: 2 years (Required)
• ETL: 2 years (Required)
• VBA: 2 years (Required)

Work Location: Remote