Senior Consultant-Forensics-Discovery (Hyderabad)

Senior Consultant-Forensics-Discovery (Hyderabad)

18 Nov
|
EY
|
Hyderabad

18 Nov

EY

Hyderabad

Job Summary The opportunity: Senior Consultant-National-Forensics-ASU - Forensics - Discovery - Hyderabad

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

- 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)

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.

📌 Senior Consultant-Forensics-Discovery (Hyderabad)
🏢 EY
📍 Hyderabad

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior consultant-forensics-discovery (hyderabad) / hyderabad