SR. Associate/Data Analyst - (VBA -MACROS_AUTOMATION EXPERT)

Megashop Retail Pvt Ltd

This position is for a role of an Automation and Digitization expert within Procurement department to create and maintain automated solutions leveraging Advanced excel, Macros, VBA, SharePoint and other BI tools. Individual needs to work closely along with internal & external data in opportunity identification for automations, value creation and digitization.

The desired candidate must have 1 - 4 years of relevant experience in the area of Automation, Digitization and providing solutions leveraging below skill set. Prior working knowledge in Sourcing & Procurement domain will be an advantage.

· Advanced Excel and VBA macros development & support

· Identifying automation opportunities within Procurement to support business teams to eliminate manual interventions

· Should be able to understand & explain critical excel formulas.

· Adherence to Client standards for developing code for respective processes

· Ensure 100% adherence to framework of automation with complying with all necessary documentation, approvals and data storage & maintenance of the developed solutions

· Adherence to organizational policies and prescribed Framework (RADAR) for digital solutions

· Tracking, Maintaining and Recertification of excel macros/ solutions on a regular basis / agreed frequency

· Create standard dashboards to highlight updates, issues and risks

· SharePoint skills Design and maintenance of SharePoint pages / subsites.

· UI path /automation anywhere

SKILLS

Technical:

· Proficiency in Advanced MS Excel & MS PowerPoint applications

· Strong knowledge VBA macros excel formulas

· Strong knowledge of MS Office Products, Power BI and SharePoint

· Data Analysis and preparing management presentations and presenting to them

· Excellent in identifying automation scope and should be able to understand problem statement and provide appropriate solutions.

· Good Dashboard and Report creating skills

· Prior knowledge of P2P tools or ERP systems will be an adv

• Experience

  1 - 6 Years

• No. of Openings

  2

• Education

  Any Bachelor Degree, Post Graduate Diploma

• Role

  Data Analyst

• Industry Type

  IT-Hardware & Networking / IT-Software / Software Services

• Gender

  [ Male / Female ]

• Job Country

  India

• Type of Job

  Full Time

• Work Location Type

  Work from Office