Analyst VBA

About the Company:
Antuit is an early stage big data analytics company, headquartered out of Singapore with offices in New York and Bangalore. Antuit is in the business of using data analytics to generate intuitive insights that helps enterprises build business advantage. Our domains of expertise are in Marketing, Sales and Supply Chain analytics. Our problem solving teams comprise a mix of domain experts, decision scientists and engineers that works closely with clients to create relevant, actionable and scaled solutions and help implement them.

Website: http://www.antuit.com/

Desired Experience: 1-3 years of experience in Reporting & Automation domain

Salary: INR 3 - 5 LPA

Tentative date of Interview: will be communicated post registration window

Job Description:
- Understand internal and client requirements and consolidating and analysing data from spreadsheets and build reports based on raw data
- Create Excel/Word reports, dashboards & charts based on the data from spreadsheets
- Develop macros in VBA (Visual Basic Applications)
- Automatize the reports by using macros
- Perform statistical analysis on the data gathered

Skill Set Required:
- Must have good command on VBA and should be able to create macros from scratch in MS Excel.
- In-depth knowledge of MS Excel is a must. Must know how to execute Pivot table, Conditional formatting, Statistical and Logical functions in Excel, Dynamic linking of sheets etc.
- Knowledge of PowerPoint Presentations
- Knowledge of database management tool SQL will be an added advantage
- Must have exposure to either Office 2007 or Office 2010 in Windows 7 environment
- Good analytical and communication skills.
- Highly organized, responsible, handle stress and ability to work under pressure

Interview Process:
-Written Test
-Face to Face Interview
-HR Round