Consultant - Forensics - National - ASU - Forensics - Discovery - New Delhi

EY; New Delhi; In loco; INR 1.500.000 - 2.300.000; Tempo pieno

Descrizione del lavoro

EY is seeking a Consultant - Forensics - Discovery in New Delhi to support forensic investigations, fraud reviews, and risk analytics. You will extract, cleanse, and analyze large datasets, build robust SQL queries, and develop dashboards to provide actionable insights for investigations.

The role requires strong data analytics capabilities, proficiency with SQL and relational databases, and familiarity with Power BI and Python for automation. Collaborative work across client teams is essential.

Competenze

• Degree in Computer Science or related field and relevant analytics certifications.
• Strong SQL and data analytics capabilities with experience in high-volume datasets.
• Experience with Power BI, Excel, and Python for data analysis is desirable.

Mansioni

• Extract and analyze large datasets using SQL across multiple databases.
• Perform data profiling, cleansing, transformation, and validation.
• Develop SQL queries with joins, CTEs, window functions, and optimization.
• Create dashboards and reports using Power BI or similar tools.
• Document data lineage, assumptions, and findings.

Conoscenze

SQL

Data analytics

Relational databases

ETL processes

Data quality

Excel

Power BI

Python

SQL Server

Oracle

PostgreSQL

Snowflake

Formazione

Bachelor of Technology in Computer Science

Master of Science in Data Science

Master of Computer Applications

Certification in Data Analytics

Strumenti

Power BI

SQL Server

Oracle

PostgreSQL

Snowflake

Descrizione del lavoro

Consultant - Forensics - National - ASU - Forensics - Discovery - New Delhi

Other locations: Primary Location Only

Requisition ID: 1759064

Requisition Id: 1759064

As a global leader in assurance, tax, transaction and advisory services, we hire and develop the most passionate people in their field to help build a better working world. This starts with a culture that believes in giving you the training, opportunities and creative freedom. At EY, we don't just focus on who you are now, but who you can become. We believe that it’s your career and ‘It’s yours to build’ which means potential here is limitless and we'll provide you with motivating and fulfilling experiences throughout your career to help you on the path to becoming your best professional self.

The opportunity

Consultant-National-Forensics-ASU - Forensics - Discovery - New Delhi

National

National comprises of 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

Technical Excellence

• 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
• 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.

What we offer

Fuelled by the brilliance of our people, EY has emerged as the strongest brand and the most attractive employer in our field, with market-leading growth over competitors. Our people work side-by-side with market-leading entrepreneurs, game-changers, disruptors, and visionaries. As an organization, we are investing more time, technology, and money than ever before in skills and learning for our people. At EY, you will have a personalized Career Journey and also the chance to tap into the resources of our career frameworks to better know about your roles, skills, and opportunities.

EY is equally committed to being an inclusive employer, and we strive to achieve the right balance for our people—enabling us to deliver excellent client service while allowing our people to build their careers as well as focus on their wellbeing.

EY refers to the global organization, and may refer to one or more, of the member firms of Ernst & Young Global Limited, each of which is a separate legal entity. Ernst & Young Global Limited, a UK company limited by guarantee, does not provide services to clients.