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
1. 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.
-Proactively identify and resolve data quality issues, ensuring data accuracy and consistency internally or via cross team collaboration.
-Execute data governance activities for data models developed within projects.
-Create database queries and scripts using SQL and BigQuery for data manipulation and analysis.
2. Business Intelligence
-Develop and maintain advanced BI solutions, including interactive tools, automation, and data visualizations independently with minimum supervision.
-Refine data models and improve BI assets in collaboration with internal team members, adhering to solution frameworks and guidelines of the team.
-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.
3. Delivery Execution
-Independently execute and deliver project milestones, ensuring all deliverables are met within the established timelines and project scope.
-Effectively communicate complex technical information & proactively identify and mitigate potential risks.
-Participate in requirement gathering, solutioning activities under the guidance of senior team members.
-Act as a subject matter expert in business intelligence and data modelling, supporting junior team members.
-Demonstrate a deeper understanding of supply chain principles, processes, and key performance indicators (KPIs).
4. Guidance & Mentoring
-Mentor junior analysts in best practices for ETL processes and data quality management.
-Guide and mentor junior analysts in the development of BI solutions, providing guidance and ensuring adherence to best practices and internal frameworks.
-Delivering internal technical trainings to junior team members
5. Process Improvement & Automation
-Identify opportunities for process automation and optimization to improve efficiency and accuracy.
-Drive continuous improvement by enhancing data workflows, reporting structures.
Minimum Qualifications
Education:
Bachelor s degree from an accredited university (Mandatory).
Experience:
3+ years of experience in data development, analysis, or visualization, with demonstrated technical acumen.
Skills:
-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
-Master s 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
