Senior Consultant - Forensics - National - ASU - Forensics - Discovery - Hyderabad
HyderabadFull-timeSenior levelPosted 1 week ago
Senior risk role at EY in Hyderabad. Needs a B.Tech, B.E. or B.Sc.
About the role
Senior Consultant-National-Forensics-ASU - Forensics - Discovery - Hyderabad National comprises of sector agnostic teams working across industries for a well rounded experience. Successful organizations depend on their reputation for keeping promises, respecting laws and behaving ethically to maintain stakeholder trust.
What you'll do
- Extract and analyze large, complex datasets using advanced SQL across multiple databases and source systems
- Perform data profiling, cleansing, transformation, reconciliation, and quality validation to establish reliable datasets for investigations
- Develop sophisticated SQL queries using joins, CTEs, window functions, subqueries, aggregations, stored procedures, and query optimization
- Conduct forensic analytics to identify fraud indicators, unusual transactions, duplicate payments, conflicts, outliers, transaction splitting, unusual relationships
- Integrate and reconcile data from ERP systems, databases, flat files, and other structured or semi-structured sources
What you need
- Power BI
- Data analysis
- SQL
- ETL
- SQL Server
- PostgreSQL
Good to have
- Excel
- Python
- Machine learning
- Snowflake
- Reconciliation
- Capital markets