Associate Vice President- Vba & Macro Job in Crisil Limited

Coalition is a leading business intelligence provider to leading global Investment Banks. We are a company firmly established as a premium brand in the Investment and Commercial banking markets.

We deliver deep analytical research on market peers, revenue opportunities, client wallets and the overall market size and conditions that enable and inform the strategy of high-margin, fast-moving, opaque businesses.

In June 2012, Coalition, reached an agreement to be acquired by CRISIL, a subsidiary of Standard & Poor's and a leading provider of ratings, research and risk and policy advisory services.

When the worlds leading Financial Services providers need clear insight to their position in the market they turn to Coalition. For over 10 years Coalition has provided the Investment Banking and Markets Industry with reliable analytics across key performance indicators.

• Develop efficient and scalable excel based solutions using data extracted from any source system
• Streamline and automate of existing processes with the help of macros and VBA
• Develop basic understanding of Financial Institutions and their hierarchys and map the information
• Analyze financial data and create database models

• Strong knowledge on various commands, string operations associated with VBA
• Strong client engagement with project development experience using Agile methodologies

• Provide guidance/suggestions to others where needed
• Ensure all documentation is recorded and maintained

• To manage Python/VBA excel proposal, timeline, review process flow, programming, UAT and roll out as per project plan
• Work with other teams as a lead and/or member
• Responsible for managing several Individual Contributors

• To be responsible for the quality of assigned VBA application and should be capable for providing guidance for first level of support

• BE /B. Tech/ BSc IT/ BCA/ MCA

• Strong MS Excel (2007/2010/2013), VBA and VB.NET background; experience in writing macros will be an added advantage
• Excellent working skills with MS office tools, especially good at advanced Excel and PowerPoint
• Fluency in spoken and written English is essential
• Strong quantitative skills and an ability to work with significant amounts of data
• Basic understanding of financial products
• Working knowledge of professional information services like Bloomberg, Thomson Reuters etc. preferred
• Past experience in VBA coding preferred