Manager - Data Analytics

1. Create/update triggers/rules or marcos to perform analysis of data for various functions/processes/activities 
2. Provide respective vertical heads with relevant inputs in the form of risk triggers in order to assist in risk assessment exercise
3. Track pre-defined triggers and update other relevant audit verticals as and when a trigger is flagged
4. Monitor trigger thresholds and discuss with relevant stakeholders if they need to be changed as a result of change in business dynamics etc
5. Create dashboards for senior management and ACB highlighting the key concern areas, grey areas within the company after running sufficient analysis on multiple queries at a predefined periodicity
6. Develop data models (regression, clustering, optimization) to work on real time machine/process data to derive actionable insights for internal audit vertical as a whole, and for DAU audit unit in particular
7. Update vertical head about new requirements/developments for data analytics unit
8. Assist respective audit verticals in preparing  final audit presentation for ACB by visualizing data points 
9. Design and develop descriptive, predictive as well as prescriptive analytics for the IA function
10. Perform portfolio analytics, segmentation and hypothesis testing necessary sampling etc.
11. Perform regular updation of internal audit tools to ensure minimum downtime
12. Ensure adherence to regular process documentation practices in compliance with the process guidelines
13. Conduct audits on need basis. 
14. Query optimisation using SQL server.