Project Analyst - Forensics - National - ASU - Forensics

EY

Gurugram District

On-site

INR 600,000 - 1,200,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 in Gurugram is seeking a Project Analyst for National-Forensics-ASU in Forensics - Investigations & Compliance. The role focuses on cleaning, transforming, and analyzing data using Python and SQL, building ETL pipelines, and validating data quality to support investigations and compliance efforts.

You will work with data scientists and investigators, develop reusable scripts, and document complex workflows while ensuring data security and client confidentiality in a fast-paced environment.

Qualifications

  • Bachelor's degree in CS/IT/Engineering/Data Science or related field.
  • Equivalent practical experience may be considered.
  • Strong Python and SQL fundamentals.
  • Familiarity with AI/ML concepts and Generative AI basics.
  • Ability to translate requirements into prompts and validate generated code.

Responsibilities

  • Clean, transform, analyze, and validate datasets using Python and SQL.
  • Write and optimize queries with joins, CTEs, subqueries, and window functions.
  • Use Pandas, NumPy, and OpenPyXL for analysis and Excel/CSV processing.
  • Identify trends and data-quality issues; communicate findings clearly.
  • Develop reusable scripts; support ETL, databases, reporting, and prototypes.
  • Leverage AI tools for code generation, debugging, and testing while preserving ownership and security.
  • Review, test, and explain AI-generated code; protect confidential data.
  • Document business rules, scripts, workflows, and outputs.

Skills

Python
SQL
AI/ML Theory
Generative AI
AI-Assisted Coding
Power BI
advanced Excel
REST APIs
scikit-learn
ETL pipelines

Education

Bachelor's in Computer Science/IT/Engineering/Data Science/Statistics or related
Bachelor of Technology in Computer Science
Bachelor of Computer Applications
Master of Science in Data Science
Master of Computer Applications
Certification in Data Analytics

Tools

Git
Jupyter Notebook
Microsoft SQL Server/SSMS
Azure cloud

Job description

Job Summary

The opportunity: Project Analyst-National-Forensics-ASU - Forensics - Investigations & Compliance - Gurgaon

Location: Gurugram

Your Key Responsibilities
  • Clean, transform, analyze, and validate structured or unstructured datasets using Python and SQL.
  • Write and optimize queries using joins, CTEs, subqueries, aggregations, CASE statements, and window functions.
  • Use Pandas, NumPy, and OpenPyXL for analysis, reconciliation, automation, and Excel/CSV processing.
  • Identify trends, anomalies, data-quality issues, and inconsistencies; communicate findings clearly.
  • Develop reusable scripts and support ETL, database, reporting, prototype, and proof-of-concept activities.
  • Use GitHub Copilot, Microsoft Copilot, ChatGPT, or similar tools for code generation, debugging, documentation, and testing.
  • Review, test, explain, and validate AI-generated code before use; protect confidential and client data.
  • Document business rules, assumptions, scripts, workflows, and analytical outputs.
Education & Experience

Bachelor's degree in Computer Science, IT, Engineering, Data Science, Statistics, Mathematics, or a related discipline. Equivalent practical experience may be considered.

Mandatory Skills
  • Python: Fundamentals, functions, loops, exception handling, Pandas, NumPy, file handling, data transformation, automation, and debugging.
  • SQL: DML, joins, GROUP BY, CTEs, subqueries, CASE logic, window functions, temporary tables, keys, relationships, and data reconciliation.
  • AI/ML Theory: Supervised vs. unsupervised learning, classification, regression, clustering, train/validation/test split, overfitting, features, targets, and model evaluation.
  • Generative AI: Basic understanding of LLMs, prompt engineering, limitations, hallucinations, and responsible usage.
  • AI-Assisted Coding: Ability to convert requirements into prompts, assess generated logic, detect errors, debug, test, and improve solutions independently.
Preferred Skills
  • Power BI
  • advanced Excel
  • Git
  • Jupyter Notebook
  • REST APIs
  • scikit-learn
  • ETL pipelines
  • Microsoft SQL Server/SSMS
  • Azure cloud
Desired Profile
  • Strong analytical and problem-solving ability.
  • Attention to detail and disciplined data validation.
  • Clear communication with technical and business stakeholders.
  • Curiosity about GenAI, automation, and emerging technologies.
  • Ability to work in a fast-paced, project-based environment. Success in this role: The candidate should use AI as a productivity accelerator, while retaining ownership of the logic, security, accuracy, testing and explainability of every output.
Qualifications
  • Bachelor of Technology in Computer Science
  • Bachelor of Computer Applications
  • Master of Science in Data Science
  • Master of Computer Applications
  • Certification in Data Analytics
Experience
  • Data Analysis (2+ years)
  • Data Engineering (4+ years)
  • Computer Vision (2+ years)
  • Artificial Intelligence (3+ years)
  • Natural Language Processing (2+ years)Deep Learning (2+ years)
  • Machine Learning (3+ years)
Job Type

Contract / Full-Time

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Project Analyst-Forensics-Investigations & Compliance
Project Analyst-Forensics-Investigations & Compliance

EY • Gurugram District

On-site
INR 900,000 - 1,300,000
Project Analyst
Project Analyst

EY • Gurugram District

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

EY • New Delhi

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
Project Analyst-Forensics-Investigations & Compliance
Project Analyst-Forensics-Investigations & Compliance

Mployee.me • Bengaluru

On-site
INR 600,000 - 1,200,000
Project Analyst - Forensics - National - ASU - Forensics - Investigations & Compliance - Gurgaon
Project Analyst - Forensics - National - ASU - Forensics - Investigations & Compliance - Gurgaon

EY • Haryana

Hybrid
INR 600,000 - 1,200,000
Project Analyst-Forensics-Investigations & Compliance
Project Analyst-Forensics-Investigations & Compliance

EY • Bengaluru

On-site
INR 500,000 - 700,000
Consultant - Forensics - National - ASU - Forensics - Discovery
Consultant - Forensics - National - ASU - Forensics - Discovery

EY • Hyderabad

On-site
INR 1,500,000 - 2,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 • New Delhi

On-site
INR 900,000 - 1,300,000