Senior Consultant - Forensics - National - Discovery

EY

Hyderabad

On-site

INR 1,200,000 - 2,000,000

Full time

5 days ago
Be an early applicant

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

EY in Hyderabad is seeking a Senior Consultant- National- Forensics-ASU to support forensic investigations and risk analytics. You will extract, transform, and analyze large datasets using SQL across multiple databases and ERP sources, while building dashboards in Power BI to enable management insight.

Your role emphasizes data profiling, quality validation, and reporting, with exposure to Python and Excel for analysis and automation as desirable enhancements to the team’s capabilities.

Qualifications

  • 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

Responsibilities

  • Extract and analyze large datasets using SQL across databases and sources.
  • Perform data profiling, cleansing, transformation, reconciliation and quality validation.
  • Develop SQL queries with joins, CTEs, window functions and procedures.
  • Conduct forensic analytics to identify fraud indicators and anomalies.
  • Integrate data from ERP systems and various data sources.
  • Develop dashboards and management reports using Power BI or similar tools.
  • Document logic, data lineage, assumptions, exceptions and findings.

Skills

SQL
Data analytics
Data quality
Excel
Power BI
Python
Relational databases

Education

B.Tech CS
BCA
MEng Electronics
MSc Data Science
MCA
Data Analytics Certification

Tools

SQL Server
Oracle
PostgreSQL
Snowflake

Job description

Job Summary

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)
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Consultant - Forensics - National - ASU - Forensics - Discovery
Consultant - Forensics - National - ASU - Forensics - Discovery

EY • New Delhi

On-site
INR 1,200,000 - 1,800,000
Consultant-Forensics-Discovery
Consultant-Forensics-Discovery

Mployee.me • Delhi

On-site
INR 900,000 - 1,400,000
Consultant-Forensics-Discovery
Consultant-Forensics-Discovery

EY • New Delhi

On-site
INR 900,000 - 1,300,000
Senior Consultant - Forensics - Discovery
Senior Consultant - Forensics - Discovery

EY • Hyderabad

On-site
INR 1,500,000 - 3,000,000
Consultant-Forensics-Discovery
Consultant-Forensics-Discovery

EY • Hyderabad

On-site
INR 1,500,000 - 2,100,000
Associate Consultant – Forensics Investigations
Associate Consultant – Forensics Investigations

EY • Hyderabad

On-site
INR 600,000 - 1,000,000
Consultant - Forensics - National - ASU - Forensics - Discovery
Consultant - Forensics - National - ASU - Forensics - Discovery

EY • Hyderabad

On-site
INR 1,500,000 - 2,300,000
Associate Consultant - Forensics - National - ASU - Forensics
Associate Consultant - Forensics - National - ASU - Forensics

EY • Bengaluru

On-site
INR 1,200,000 - 1,800,000
Senior Analyst - Forensics - National - ASU - Forensics - Discovery
Senior Analyst - Forensics - National - ASU - Forensics - Discovery

EY • Hyderabad

On-site
INR 300,000 - 540,000
Consultant - National - ASU - Forensics - Discovery
Consultant - National - ASU - Forensics - Discovery

EY • Hyderabad

On-site
INR 1,700,000 - 2,500,000