The GIC Supply Chain team manages end-to-end operations, encompassing planning, sourcing, manufacturing, logistics, and analytics. They strategically plan to meet market demands, optimize sourcing, ensure efficient production, and oversee the seamless movement of goods from production to delivery. The team employs advanced analytics throughout these processes, fostering adaptability and operational excellence. This collaborative approach ensures a we'll-coordinated supply chain that aligns with both organizational goals and dynamic market conditions. Link
Purpose of the role
The purpose of the role is to leverage data extraction, transformation, processes to ensure accurate and consistent data management, while developing advanced business intelligence (BI) solutions that enable data-driven decision-making. This position involves delivering project milestones independently, mentoring junior analysts, and improving processes through automation and optimization. Additionally, the role emphasizes effective communication of technical information, collaboration with cross-functional teams, and adherence to best practices in data governance and BI development to support organizational goals and enhance overall efficiency.
Key Accountabilities
Data Extraction, Transformation, and Loading (ETL)
- Perform data discovery, develop, and maintain low to intermediate complex ETL processes in GCP / SQL for extracting, transforming data from diverse data sources as per business problem needs.
o Proactively identify and resolve data quality issues, ensuring data accuracy and consistency internally or via cross team collaboration.
o Execute data governance activities for data models developed within projects.
o Create database queries and scripts using SQL and BigQuery for data manipulation and analysis.
Business Intelligence
o Develop and maintain advanced BI solutions, including interactive tools, automation, and data visualizations independently with minimum supervision.
o Refine data models and improve BI assets in collaboration with internal team members, adhering to solution frameworks and guidelines of the team.
o Assist consultants to support business teams with data-driven recommendations by helping with in depth data analysis, seeking guidance internally from senior team members as necessary.
Delivery Execution
o Independently execute and deliver project milestones, ensuring all deliverables are met within the established timelines and project scope.
o Effectively communicate complex technical information & proactively identify and mitigate potential risks.
o Participate in requirement gathering, solutioning activities under the guidance of senior team members.
o Act as a subject matter expert in business intelligence and data modelling, supporting junior team members.
o Demonstrate a deeper understanding of supply chain principles, processes, and key performance indicators (KPIs).
Guidance & Mentoring
o Mentor junior analysts in best practices for ETL processes and data quality management.
o Guide and mentor junior analysts in the development of BI solutions, providing guidance and ensuring adherence to best practices and internal frameworks.
o Delivering internal technical trainings to junior team members
-
Process Improvement & Automation
- Identify opportunities for process automation and optimization to improve efficiency and accuracy.
- Drive continuous improvement by enhancing data workflows, reporting structure
Minimum Qualifications
-
Education:
bachelors degree from an accredited university (Mandatory). -
Experience:
3+ years of experience in data development, analysis, or visualization, with demonstrated technical acumen. - Expertise in data ETL, SQL/BigQuery query writing, and visualization best practices.
- Proficiency in
Google Cloud Platform (GCP), Advanced Excel, Tableau, and SQL Server
. - Clearly articulate ideas in both written and verbal formats.
- Strong collaboration skills, maintaining a positive and constructive attitude.
Preferred Qualifications
- masters degree
- 4 years of related experience
- Major Area of Study : B.E., B.Tech., Engineering,
- Professional Certifications: SQL, GCP, Tableau, Excel
- Basic understanding of Supply Chain or CPG industry