Job Description

Job Overview: Briefly describe primary function/purpose of job in no more than 2-3 sentences. SC Reporting and Analytics group is responsible for development of the reports, tools & dashboards which support and aid in decision making process in Supply Chain. This team provides exposure to Demand Planning, Supply Planning, Deployment, Transportation, Inbound Logistics and Sourcing function. This team works directly with Supply Chain, Business teams and IT for developing solutions which aid decision making and drive business value. This team drives step-change innovation and improvements in business practices by delivering actionable insights through advanced analytics and Supply chain expertise. % of Time Primary Duties/Responsibilities 70 % Operational Responsibilities - Development of Reports / Tools / Visualization dashboards . Participate in business meetings to understand their requirements . Participate / lead connects with stakeholders during project execution for updates, feedback gathering etc. . Data and data sources exploration across multiple data sources - Data Lake, Oracle, SQL, AFO, SAP etc. . Perform ETL (Extract-Transform-Load) operation on large data sets, Execute efficient data transformation techniques depending on the tools. . Create new reports / Tools / Automatio ns /dashboards for business stakeholders . Deliver time savings through process automations . Look for opportunities to identify and execute Automate existing reports / dashboards . Self-service tool developments as per business requirements 30 % Other Responsibilities . On-boarding of new team members o Buddy new team member o Conduct basic on boarding trainings . Participate in Technical, Soft Skill Training . Participate/Lead other engagement activities across SC Analytics team. Education and Experience Minimum Degree Requirements: Bachelors Preferred Degree Requirements: Masters Preferred Major Area of Study: BSc./MSc., B.E., B.Tech. , Engineering, MBA Operations/SC, BCA/MCA Required Professional Certifications: Preferred Professional Certifications: SQL, Tableau Minimum years of related experience required: 1.5 Years Preferred years of related experience: 2 Years Specific Job Experience or Skills Needed MS Excel - Pivots, Array Formulas, Formulas (E.g: SUMIFS VLOOKUP HLOOKUP MAXIF etc), Conditional Formatting and other concepts. MS Excel VBA - Functions, Procedures, Macro Development, Error Handling MS Access - Intermediate Access Knowledge, VBA, Forms etc. SQL - Basic/Intermediate Queries, Procedures Visualization -Tableau Project Management - Basic at execution level Competencies/Behaviors required for job - Agility o Understands quality and strives to deliver on time. o Thrives in working on couple of projects at one time. o Has curiosity to learn o Works with less / minimum supervision o Executes one key expertise independently - Deliver Results: o Assume personal initiative and accountability for results, performance and behaviors. o Be comfortable with ambiguity. o Engage in cross functional collaboration to identify innovative solutions and optimization - Integrity and Candour o Engenders Trust at all levels and demonstrates unquestionable integrity.

foundit