Design, develop, and maintain complex data models using advanced Excel techniques such as pivot tables, VLOOKUPs, HLOOKUPs, VBA and macros.
Analyze large datasets to identify trends, patterns, and insights using statistical methods and visualization tools like MIS reports.
Proven experience in creating and managing macros from scratch
Proficiency in VBA for automation and data handling.
Develop VBA scripts to automate repetitive tasks and improve process efficiency within the organization's existing systems.
Collaborate with stakeholders to gather requirements for reporting needs and provide solutions that meet their business needs.
Job Requirements :
3-12 years of experience in a similar role or related field (e.g., finance).
Advanced skills in Microsoft Excel including pivot tables, VLOOKUPs, HLOOKUPs, macros.
Strong analytical skills with ability to work with large datasets using statistical methods.
Experience creating MIS reports or dashboards using various software tools.
Job Classification
Industry: InternetFunctional Area / Department: Data Science & AnalyticsRole Category: Business Intelligence & AnalyticsRole: Business Intelligence & Analytics - OtherEmployement Type: Full time