Assistant Manager- Data Analyst-CPG021217
Develop VBA Programs to Automate existing manual process
Optimization of processes using Excel
Identify and suggest cross program workflows
Maintain good Coding Standards
Create macros to work with huge amount of data and for Excel reports
Keen analytical, Logical and Trouble Shooting Skills
Can single handedly work on Advanced Excel/ VBA Automation related projects
Develop robust architectures with clearly defined inputs, calculations, and final output.
Strive for Customer Delight every time and minimize/eliminate scope for Customer Dissatisfaction
Collaborates with clients and team in the design and development of automation projects using Advanced Excel and VBA.
Makes recommendations based, suggest or ideate compelling visuals that cater to the needs of customers
Utilize VBA in new and existing Excel-based tools to automate recurring work processes.
Provide documentation including data flow maps for As-is and To-Be Process.
Develop automated and reusable routines for extracting information from client data sources.
Undergo self-development training modules Attending Training Programs (Soft Skill / Technical)
Continuous improvement Initiatives resulting in significant productivity gains Automation and Standardization of reports for self and Team members
Ensuring 100% Compliance on Tracker Adherence / Appraisal form submission, leave attendance any process related documentation/Genpact Data Privacy, Information Security, and Integrity Certification
Able to conduct calls and clearly communicate with clients on challenges, understanding the requirements, etc.
Troubleshoots technical details / issues.
Conduct RCA (Root Cause Analysis) in case of any failure or quality issue leading to impact client metrics
Exhibit willingness to provide support by mentoring other analysts
Buddy QC and eye to detail checks to identify potential failure mode
Participation in team activity/Meetings
Academic Degree in Business, Computer Science, Information Systems – Capable to handle VBA related projects single handedly
Proficiency with VBA
Advanced level knowledge of MS Excel application Pivot, Power Pivot, Power Query
Working experience finance domain KPI reporting, Nielsen Market share analysis etc.
Working experience in process automation, continuous improvement, process management and people management
Personal drive and positive work ethic to deliver results within tight deadlines and in demanding situations
Flexibility to adapt to a variety of engagement types, working hours and work environments and locations
Education LevelMaster's / Equivalent
Job PostingMar 26, 2021, 3:27:27 AM
Master Skills ListOperations
Job CategoryFull Time