Junior Technical Consultant

Thoucentric Technology Private Limited; Bengaluru Urban; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Thoucentric Technology Private Limited in Bengaluru is seeking Senior and Mid-to-Junior Technical Consultants with hands-on experience in SQL, PySpark, Python, Airflow, and API development to design, optimize, and implement scalable data solutions for the supply chain domain.

The role emphasizes data warehousing concepts (fact and dimension) and collaboration with cross-functional teams to deliver reliable analytics platforms. 4–6 years experience required.

Qualifications

• Proficient in SQL, PySpark, and Python.
• Experience with Airflow for scheduling.
• Experience with APIs integration.
• Knowledge of fact and dimension data models.
• Experience in supply chain domain preferred.
• Cloud platforms (AWS/Azure/GCP) a plus.

Responsibilities

• Design, develop, and optimize data pipelines using PySpark, SQL, and Python.
• Implement Airflow DAGs for workflow automation.
• Work with APIs to integrate data sources.
• Develop data models based on fact and dimension tables.
• Optimize query performance for large datasets.
• Collaborate with analysts, data engineers, and stakeholders to capture requirements.
• Ensure data quality, reliability, and scalability of solutions.
• Mentor junior team members for the Senior role.

Skills

SQL

PySpark

Python

Airflow

API development

Data warehousing

Supply chain domain

Cloud platforms

Job description

Bangalore North, India | Posted on 04/09/2025

• Corporate Office Thoucentric, The Hive, Mahadevapura
• Country India

About Us

At Thoucentric, we offer end-to-end consulting solutions designed to address the most pressing business challengesacross industries. Leveraging deep domain expertise, cutting-edge technology, and a results-driven approach, wehelp organizations streamline operations, enhance decision-making, and accelerate growth. We are headquartered in Bangalore with presence across multiple locations in India, US, UK, Singapore & Australia Globally.

We help clients with Business Consulting, Program & Project Management, Digital Transformation, Product Management, Process & Technology Solutioning and Execution including Analytics & Emerging Tech areas cutting across functional areas such as Supply Chain, Finance & HR, Sales & Distribution across US, UK, Singapore and Australia. Our unique consulting framework allows us to focus on execution rather than pure advisory. We are working closely with marquee names in the global consumer & packaged goods (CPG) industry, new age tech and start-up ecosystem.

We have been certified as "Great Placeto Work" by AIM and have been ranked as "50 Best Firms for Data Scientists to Work For".

We have an experienced consulting team of over 500+ world-class business and technology consultants based across six global locations, supporting clients through their expert insights, entrepreneurial approach and focus on delivery excellence. We have also built point solutions and products through Thoucentric labs using AI/ML in the supply chain space.

Job Description

Job Overview:
We are looking for highly skilled Senior and Mid-to-Junior Technical Consultants with expertise in SQL, PySpark, Python, Airflow, and API development . The ideal candidates will have hands‑on experience in data warehousing concepts (Fact & Dimension) and a strong understanding of supply chain domain processes. You will work closely with cross‑functional teams to develop, optimize, and implement scalable data solutions.

Senior Technical Consultant: 4-6 years

Key Responsibilities

• Design, develop, and optimize data pipelines using PySpark, SQL, and Python .
• Implement and manage Airflow DAGs for workflow automation.
• Work with APIs to integrate data sources and ensure seamless data exchange.
• Develop and maintain data models based on fact and dimension tables for efficient reporting and analytics.
• Optimize query performance and data processing for large datasets.
• Collaborate with business analysts, data engineers, and stakeholders to understand business requirements and translate them into technical solutions.
• Ensure data quality, reliability, and scalability of solutions.
• Provide mentorship to junior team members (for the Senior Technical Consultant role).

Requirements

Required Skills & Qualifications

• Strong proficiency in SQL, PySpark, and Python .
• Hands‑on experience with Airflow for scheduling and orchestrating workflows.
• Expertise in working with APIs (development and integration).
• Solid understanding of data warehousing concepts (Fact & Dimension modeling).
• Experience in the supply chain domain is highly preferred.
• Knowledge of cloud platforms (AWS, Azure, or GCP) is a plus and not mandatory.
• Excellent problem‑solving skills and ability to work in an agile environment.
• Strong communication skills to effectively collaborate with cross‑functional teams

What a Consulting role at Thoucentric will offer you?

• Opportunity to define your career path and not as enforced by a manager
• A great consulting environment with a chance to work with Fortune 500 companies and startups alike.
• A dynamic but relaxed and supportive working environment that encourages personal development.
• Be part of One Extended Family. We bond beyond work - sports, get-togethers, common interests etc. Work in a very enriching environment with Open Culture, Flat Organization and Excellent Peer Group.
• Be part of the exciting Growth Story of Thoucentric!