Analyst - TAG FS

Alvarez & Marsal's Transaction Advisory Group (TAG) works with strategic players across industries and PE community. TAG focuses on providing potential clients with an understanding of Company's

(i)Sustainable economic earnings

(ii)Historical sales and operating expense trends

(iii)Working capital needs

(iv)Key assumptions used in management's forecast

(v)Key personnel and accounting information systems

TAG covers quality of earnings (over/understated assets and liabilities, post-closing cost structure changes), trend analysis (key market drivers, sales strategies, customer relationships and customer churn) and qualitative observations like company's internal control structure, management and accounting team, and accounting information system.

TAG team closely works with other Business Units like Business Transformation Services (CDD and Performance Improvement) and Corporate Finance and Restructuring.

Roles & Responsibilities:

• Data processing and structuring of data in prescribed formats
• Consolidation of multiple excel worksheets in single workbook
• Classifying documents across different data sets and comparing the data sets
• Assisting team in conducting research on companies, preparing research data sets

Skills Required:

• Basic knowledge of Microsoft PowerPoint and proficiency in Microsoft Excel (Using formulas / functions such as Pivot, VLOOKUP, sumifs etc.)
• Ability to work well with a team and have focus on quality
• Strong interpersonal and communication skills
• Ability to work under stringent timelines

Preferred Qualifications /experience:

• Graduate (BCom, BAF, or any other degree) with basic knowledge of accounting and financial statements
• Prior experience of working on excel workbooks
• Candidates with certification courses such as data analytics/ data visualization, prior experience of working on Power BI, Alteryx or in a similar role would be preferred.