Data Warehouse Engineer at Pando – Chennai, India

Victrays; Chennai District; On-site; INR 600,000 - 800,000; Full time

Job summary

A leading technology company is looking for a Junior Data Warehouse Engineer in Chennai. This role involves supporting the design and maintenance of data pipelines, collaborating with teams to deliver high-quality analytics, and developing data models for reporting. The ideal candidate should have 2–4 years of experience in data engineering, solid SQL knowledge, and a collaborative spirit. This position offers an excellent opportunity to gain hands-on experience with large-scale data systems in a dynamic environment.

Qualifications

• 2–4 years of experience with data engineering or ETL tools.
• Solid understanding of SQL and experience with OLAP systems.
• Exposure to data lakes, preferably in Parquet format.

Responsibilities

• Assist in building and maintaining scalable data pipelines.
• Support the development and maintenance of data models for reporting.
• Write optimized SQL queries for OLAP database systems.

Skills

Data engineering

ETL tools

SQL

Problem-solving

Collaboration

Tools

PySpark

SQL

Airflow

AWS

Azure

GCP

Power BI

Looker

Tableau

Job description

Data Warehouse Engineer at Pando – Chennai, India

Pando is a global leader in supply chain technology, building the world’s quickest time-to-value FulfillmentCloud platform. Pando’s Fulfillment Cloud provides manufacturers, retailers, and 3PLs with a single pane of glass to streamline end-to-end purchase order fulfillment and customer order fulfillment to improve service levels, reduce carbon footprint, and bring down costs. As a partner of choice for Fortune 500 enterprises globally, with a presence across APAC, the Middle East, and the US, Pando is recognized as a Technology Pioneer by the World Economic Forum (WEF), and as one of the fastest growing technology companies by Deloitte.

Role Overview

As a Junior Data Warehouse Engineer at Pando, you’ll work within the Data & AI Services team to support the design, development, and maintenance of data pipelines and warehouse solutions. You’ll collaborate with senior engineers and cross-functional teams to help deliver high-quality analytics and reporting solutions that power key business decisions. This is an excellent opportunity to grow your career by learning from experienced professionals and gaining hands-on experience with large-scale data systems and supply chain technologies.

Key Responsibilities

• Assist in building and maintaining scalable data pipelines using tools like PySpark and SQL-based ETL processes.
• Support the development and maintenance of data models for dashboards, analytics, and reporting.
• Help manage parquet-based data lakes and ensure data consistency and quality.
• Write optimized SQL queries for OLAP database systems and support data integration efforts.
• Collaborate with team members to understand business data requirements and translate them into technical implementations.
• Document workflows, data schemas, and data definitions for internal use.
• Participate in code reviews, team meetings, and training sessions to continuously improve your skills.

Requirements

• 2–4 years of experience working with data engineering or ETL tools (e.g., PySpark, SQL, Airflow).
• Solid understanding of SQL and basic experience with OLAP or data warehouse systems.
• Exposure to data lakes, preferably using Parquet format.
• Understanding of basic data modeling principles (e.g., star/snowflake schema).
• Good problem-solving skills and a willingness to learn and adapt.
• Ability to work effectively in a collaborative, fast-paced team environment.

Preferred Qualifications

• Experience working with cloud platforms (e.g., AWS, Azure, or GCP).
• Exposure to low-code data tools or modular ETL frameworks.
• Interest or prior experience in the supply chain or logistics domain.
• Familiarity with dashboarding tools like Power BI, Looker, or Tableau.