Senior Forensics Data Analyst – SQL & Discovery

EY; Hyderabad City Taluka; On-site; PKR 2,000,000 - 3,600,000; Full time

Job summary

EY is seeking a Senior Consultant for Forensics - Discovery in Hyderabad to support national ASU Forensics initiatives, focusing on data analytics, investigations and risk assessments within EY's Forensic & Integrity Services.

You will extract, cleanse and analyze large datasets using SQL, develop dashboards in Power BI, and collaborate with cross-functional teams to deliver actionable insights while maintaining audit trails and regulatory compliance.

Responsibilities

• Extract and analyze large datasets using 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, and behavioural patterns.
• Integrate and reconcile data from ERP systems, databases, flat files, and other structured or semi-structured sources.
• Develop dashboards and management reports using tools such as Power BI or similar visualization platforms.
• Document analytical logic, data lineage, assumptions, exceptions, and findings to maintain an appropriate audit trail.

Job description

EY is seeking a Senior Consultant for Forensics - Discovery in Hyderabad to support national ASU Forensics initiatives, focusing on data analytics, investigations and risk assessments within EY's Forensic & Integrity Services.

You will extract, cleanse and analyze large datasets using SQL, develop dashboards in Power BI, and collaborate with cross-functional teams to deliver actionable insights while maintaining audit trails and regulatory compliance.