Junior Technical Consultant
Posted Updated
Summary
Junior/Mid-level Technical Consultant at Thoucentric (Bangalore) building and optimizing data pipelines and fact/dimension data models for supply-chain clients, using SQL, PySpark, Python, Airflow, and APIs in a consulting environment serving Fortune 500 companies.
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.
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).
- 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
- 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
Benefits
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!