Deal Analytics - Consultant

Job details
• Proposed designation
Consultant
• Role type
Individual contributor
• Reporting to
Manager
• Geo to be supported
US
• Work timings
Normal Shift

Roles & responsibilities
— Work with large volumes of transactional data to analyse
underlying performance trends and identify insights
— Combine data from multiple sources (SQL databases, MS
Access, Excel files, flat files, etc.) into integrated views that can be
used to drive analysis and decision making;
— Build dashboards and applications in Power Bi/Tableau/Qlik
Sense.
— Partner with internal business customers to develop analyses that
lead to actionable insights;
— Review financial statements / management accounts to analyse
business performance;
— Benchmark financial KPIs against peer groups and quantify the
improvement opportunity;
— Ensure consistency of client models with project documentation
and data books;
— Prepare client presentations and reports.
— Support with Independent business reviews on things like cash
flow forecasting, scenario modelling, creating data books in excel,
etc.
— Going through detailed internal and external company reports
and write commentary on the business overview and its outline.
— Adhoc research involving working on CapIQ, Debtwire, Fame,
Amadeus, etc.
— Web scraping using technologies like python/power automate

Mandatory technical & functional skills
• Experience of Data analytics, Financial Analysis, Business
Modelling or Financial Modelling;
• A good Understanding working knowledge of accounting,
financial statements, and financial analysis, financial ratios;
• Understanding of working capital process
• Experience in Working Capital Optimization analysis(Account
Payables & Receivables and Inventory Optimization)
• Strong analytical and problem-solving skills;
• Data wrangling and data processing skills
• Advanced knowledge of Alteryx, Tableau, Power Bi, Excel and T-
SQL
• A commercial outlook and a good understanding of the general
business and economic environment; and

Preferred technical & functional skills
• Knowledge of R/Python would be a plus but not mandatory.
• Knowledge of research databases like CapIQ, Debtwire would be
a plus but not mandatory

Key behavioural attributes/requirements 
• Excellent communication and presentation skills both written
and verbal and the ability to articulate key points clearly and
succinctly in your analysis and reasoning.
• Ability to build effective networks internally and externally
A natural curiosity about business and a passion for business
improvement; and strong attention to details

Other information
• Interview process: 2-3 rounds
• Does the job role involve travelling: No