This role focuses on enhancing organizational reputation and integrity through forensic investigations and data analysis. Professionals in EY's Forensic & Integrity Services assist clients and legal counsel in uncovering facts, resolving disputes, and navigating regulatory challenges.

The team provides comprehensive solutions, from improving governance and controls to implementing full organizational designs. Their goal is to safeguard and restore financial and brand reputations, fostering trust in capital markets globally.

Extract and analyze large, complex datasets using advanced SQL across multiple databases. Perform data profiling, cleansing, transformation, and validation to ensure reliable datasets for investigations. Develop sophisticated SQL queries, including joins, CTEs, and window functions, for in-depth analysis.

Conduct forensic analytics to identify fraud indicators, unusual transactions, and suspicious patterns. Integrate and reconcile data from various sources like ERP systems and databases. Create dashboards and reports using visualization tools, and meticulously document analytical logic and findings for audit trail purposes.

A strong foundation in data analysis is essential, with at least 2 years of experience. Proficiency in SQL, including complex querying and performance optimization, is a must. Candidates should possess a solid understanding of relational databases, data models, ETL processes, and data quality principles.

Experience with high-volume transactional datasets, a keen analytical mindset for identifying patterns and anomalies, and strong skills in Excel are required. Familiarity with databases such as SQL Server, Oracle, or PostgreSQL is beneficial. Exposure to Python for data analysis and automation, and experience with Power BI for visualization, are considered desirable.