Senior Consultant - Forensics - National - Discovery
Ernst Young · Hyderabad · onsite · Posted today
Undisclosed3–8 yrsfulltimeSourced from
About a minute. You'll make an account on the way through.
About this role
Job Summary
Your key responsibilities
Required Skills
Skills and attributes
Qualification
Experience
The opportunity: Senior Consultant-National-Forensics-ASU - Forensics - Discovery - Hyderabad
Your key responsibilities
- Role Overview We are looking for a Forensics Data Analyst with strong SQL and data analytics capabilities to support forensic investigations, fraud reviews, compliance assessments, and risk analytics. The role will involve extracting, transforming, validating, and analyzing large datasets to identify anomalies, suspicious patterns, control gaps, and potential misconduct. Key Responsibilities
- 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, and behavioral 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.
Required Skills
- Excellent SQL skills, including complex querying and performance optimization.
- Strong understanding of relational databases, data models, ETL processes, and data quality concepts.
- Hands-on experience analyzing high-volume transactional datasets.
- Strong analytical mindset with the ability to identify patterns, anomalies, relationships, and exceptions.
- Proficiency in Excel and preferably Power BI.
- Exposure to Python for data analysis and automation is desirable.
- Familiarity with databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar platforms.
Skills and attributes
To qualify for the role you must have
Qualification
- Bachelor of Technology in Computer Science
- Bachelor of Computer Applications
- Master of Engineering in Electronics
- Master of Science in Data Science
- Master of Computer Applications
- Certification in Data Analytics
Experience
- Data Analysis (2+ years)
- Machine Learning (3+ years)
- Business Intelligence (3+ years)
Sourced from naukri
Skills
data qualityAutomationAgileData lineageerp systemscounseladvanced sqldata analystdata profilingAnalyticsdata modelsCapital MarketsData AnalyticsERPdata analysiscomplianceETLBusiness IntelligenceData Science
About Ernst & Young

Ernst Young
Management Consulting
44k+
employees
2002
24 years old
Gurgaon / Gurugram, Haryana
India
₹15.3L PA avg
Avg at Ernst & Young
About
At EY, our purpose is Building a better working world. The insights and quality services we provide help build trust and confidence in the capital markets and in economies the world over.
Industries
Management Consulting
Employee ratings
10 reviews
3.4/ 5
Culture
1.9
Career growth
2.3
Work-life
2.5
Employees rate it well for
Job Security36Skill Development35
Find them on