Data Warehouse Engineer

Pando

  • Chennai, Tamil Nadu
  • Permanent
  • Full-time
  • 1 month ago
Job Description :Pando is a global leader in supply chain technology, building the world's quickest time-to-value Fulfillment Cloud 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 OverviewAs 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.

Pando