Job highlights
- Bachelor's in CS, Data Science or related; 2+ years in Data Analysis, 3+ years in AI/ML; expertise in Python, SQL, AI-assisted coding, and generative AI
- Clean, transform, analyze datasets; write and optimize SQL queries; develop reusable scripts; validate AI-generated code; document workflows and findings
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 quick-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
📌 Project Analyst - Forensics - National - ASU - Forensics (Gurugram)
🏢 EY
📍 Gurugram