Consultant - Forensics - National - ASU - Forensics - Discovery

EY

New Delhi

On-site

INR 1,200,000 - 1,800,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's Forensic & Integrity Services invites applications for a Forensics Data Analyst role in New Delhi. The position focuses on extracting, transforming, and analyzing large datasets with SQL across ERP and other sources to support investigations, fraud reviews, and risk analytics.

You will develop dashboards using Power BI, document data lineage, and work with cross-functional teams to deliver actionable insights while upholding data governance and audit trails.

Qualifications

  • Bachelor’s degree in Computer Science or equivalent.
  • Masters in Data Science or MCA or related field required.
  • Certification in Data Analytics preferred.
  • Experience with data analytics and forensic data environments is a plus.

Responsibilities

  • Extract and analyze large datasets using advanced SQL across multiple data sources.
  • Profile data quality, cleanse, transform, and reconcile data for investigations.
  • Develop dashboards and reports using Power BI or similar tools.
  • Document data lineage, assumptions and findings for audit trails.

Skills

SQL queries
Relational DBs
ETL processes
Data quality
Excel & Power BI
Python
Data analytics

Education

B.Tech CS
MSc Data Science
MCA
Data Analytics Certification

Tools

Power BI
SQL Server
Oracle
PostgreSQL
Snowflake

Job description

Job Summary

The opportunity: Consultant-National-Forensics-ASU - Forensics - Discovery - New Delhi

National comprises sector agnostic teams working across industries for a well rounded experience.

ASU - Forensics - Discovery :

Successful organizations depend on their reputation for keeping promises, respecting laws and behaving ethically to maintain stakeholder trust. EY Forensic & Integrity Services professionals help organizations protect and restore enterprise and financial reputation. We assist companies and their legal counsel to investigate facts, resolve disputes and manage regulatory challenges. We put integrity at the heart of compliance programs to help better manage ethical and reputational risks.

Our integrated approach ranges from enhancements in areas of perceived weakness or issues including governance, controls, culture and data insights to full organizational design and structural implementation. We want to help companies safeguard and restore financial and brand reputations. The insights and quality services we deliver help build trust and confidence in the capital markets and in economies the world over.

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.
What you must have
Qualification
  • Bachelor of Technology in Computer Science
  • Master of Science in Data Science
  • Master of Computer Applications
  • Certification in Data Analytics
Experience
  • Data Analysis (2+ years)
  • Business Intelligence (3+ years)
What we look for

People with the ability to work in a collaborative manner to provide services across multiple client departments while following the commercial and legal requirements. You will need a practical approach to solving issues and complex problems with the ability to deliver insightful and practical solutions. We look for people who are agile, curious, mindful, and able to sustain positive energy, while being adaptable and creative in their approach.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

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 - National - Discovery
Senior Consultant - Forensics - National - Discovery

EY • Hyderabad

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

EY • Hyderabad

On-site
INR 1,500,000 - 2,100,000
Senior Consultant - Forensics - Discovery
Senior Consultant - Forensics - Discovery

EY • Hyderabad

On-site
INR 1,500,000 - 3,000,000
Senior Analyst - Forensics - National - ASU - Forensics
Senior Analyst - Forensics - National - ASU - Forensics

EY • Hyderabad

On-site
INR 350,000 - 520,000
Associate Consultant - Forensics - National - ASU
Associate Consultant - Forensics - National - ASU

EY • Mumbai

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

EY • Gurugram District

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

EY • Gurugram District

On-site
INR 1,000,000 - 1,600,000
Forensics Project Analyst
Forensics Project Analyst

EY • Bengaluru

On-site
INR 1,200,000 - 2,000,000