E

Ernst & Young

Provides consulting, assurance, and tax services

Consultant - Forensics, National, Asu, Forensics, Discovery, New Delhi

Data AnalysisUpdated on Nov 14
Full-timeNew Delhi, Delhi, IndiaNo salary listedIn-person

About the Job

Requirements

  • Bachelor of Technology in Computer Science, Master of Science in Data Science, Master of Computer Applications, or Certification in Data Analytics.
  • At least 2 years of experience in data analysis and 3 years of experience in business intelligence.
  • Excellent SQL skills, including complex querying and performance optimization.
  • Strong understanding of relational databases, data models, extract, transform, and load processes, and data quality concepts.
  • Hands-on experience analyzing high-volume transactional datasets.
  • Proficiency in Excel; Power BI proficiency is preferred.
  • Familiarity with databases such as SQL Server, Oracle, PostgreSQL, Snowflake, or similar platforms.
  • Ability to identify patterns, anomalies, relationships, and exceptions through data analysis.
  • Ability to collaborate across multiple client departments while following commercial and legal requirements.

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 SQL queries using joins, common table expressions, 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 enterprise resource planning systems, databases, flat files, and other structured or semi-structured sources.
  • Develop dashboards and management reports using Power BI or similar visualization platforms.
  • Document analytical logic, data lineage, assumptions, exceptions, and findings to maintain an audit trail.
  • Support forensic investigations, fraud reviews, compliance assessments, and risk analytics.

Desired Qualifications

  • Exposure to Python for data analysis and automation.

About the Company

Ernst & Young

Provides consulting, assurance, and tax services

EY (Ernst & Young) is a global professional services firm that provides consulting, assurance, tax, and transaction advisory services across industries such as energy, healthcare, financial services, and real estate. Its work centers on helping clients solve critical business challenges by offering high-value advisory support in areas like supply chain, cybersecurity, sustainability, and digital transformation; revenue comes from fees for consulting, audit, and advisory services. What sets EY apart is its breadth of services across multiple disciplines, deep industry knowledge, and emphasis on thought leadership and research to inform clients’ strategic decisions. The firm aims to help organizations improve operational efficiency, navigate regulatory environments, and stay ahead of market trends by delivering practical, evidence-based guidance and execution support.

Company size
10,001+
Company stage
Not listed
Total funding
Not listed
Headquarters
Boston, MA
Founded
1991

Recently Posted Jobs

Explore more opportunities at Ernst & Young

See more jobs