Analyst,SC Advanced Analytics - Data & Insights

Job Description

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 . KEY ACCOUNTABILITIES -Participate in connects with stakeholders during project requirements gathering, updates, feedback gathering, stand-ups etc. -Data and data sources exploration across multiple data sources Data Lake, Oracle, SQL, AFO, SAP etc. - Perform complex ETL (Extract-Transform-Load) operation on large data sets, Execute efficient data transformation techniques depending on the tools. -Create new reports / Tools / Automations /dashboards for business stakeholders, that drive insights and enable better decision making -Deliver time savings through internal process automations - Should possess strong knowledge of Tableau architecture (design, development), SQL, query optimization, and end user experience -Should be able to understand and navigate through the back-end data architecture and troubleshoot data issues if any -Ensure project related documentation is updated -Ensure data accuracy and quality -Support short term capabilities sustainance . -Keep project notes and projects document updated and verified -Support On-boarding of new team members -Conduct basic on boarding trainings -Proactive Participation in Technical, Soft Skill Training -Participate/Lead other engagement activities across SC Analytics team. -Demonstrate Effective written and verbal Communication MINIMUM QUALIFICATIONS -Education Full t ime graduation from an accredited university (Mandatory- Note: This is the minimum education criteria which cannot be altered) -Graduation in - BSc./ MSc., B.E. , B.Tech. , Engineering, MBA Operations/SC, BCA/MCA -Specific Job Experience or Skills Needed: -SQL Intermediate Queries, Procedures -Advanced MS Excel Pivots, Array Formulas, Formulas (E.g.: SUMIFS; VLOOKUP; HLOOKUP; MAXIF etc ), Conditional Formatting and other concepts. -VBA Functions, Procedures, Macro Development, Error Handling -Visualization Tableau Dashboard Development -Project Management Basic at execution level. Analytical and prioritization skills -Problem solving skill Competencies/Behaviors required for job: -Agility -Understands quality and strives to deliver on time. -Thrives in working on couple of projects at one time. -Has curiosity to learn -Works with less / minimum supervision -Executes one key expertise independently -Deliver Results: -Assume personal initiative and accountability for results, performance and behaviors. -Be comfortable with ambiguity. PREFERRED QUALIFICATIONS -Masters -SQL Certification -Advanced Excel & VBA Certification -MIS Reporting Certification