Employee Conduct Analyst - Data Analytics Solutions

Testing Site - JPMC; Hyderabad; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Testing Site - JPMC seeks a data analytics professional to design intelligent analytics solutions, build dashboards from multiple sources, and automate reporting for risk management.

You will combine Python and SQL expertise with ServiceNow IRM and Alteryx to create auditable pipelines, translate risk policies into rules, and present insights to stakeholders with clear documentation. Collaboration and continuous improvement are encouraged.

Qualifications

• 2 years of data analytics experience with Python (pandas, numpy).
• Advanced SQL skills including joins, subqueries, window functions, and tuning.
• Experience with ServiceNow IRM/GRC and App Engine Studio.
• Proficient in Alteryx Designer for ETL and automation.
• Experience building analytics pipelines and dashboards.
• Strong analytical and problem-solving abilities.
• Excellent written and verbal communication for documentation.

Responsibilities

• Design rich data visualizations to communicate complex ideas and automate reporting and controls.
• Collaborate with stakeholders to share information on trends and issues.
• Execute special projects as assigned by management.
• Build auditable analytics pipelines and dashboards from multiple data sources.
• Translate policies into rules-based logic.
• Explain analytical findings to non-technical audiences and produce clear documentation.
• Document business requirements and generate SOPs for handover of automation to testing team for BAU activity.
• Contribute to continuous improvement by bringing new ideas and perspectives.
• Manage multiple projects focused on process automation and efficiency.
• Design MIS and reports for senior management.
• Maintain confidentiality and professionalism when handling sensitive information.

Skills

Python

SQL

ServiceNow IRM

Alteryx

Analytics pipelines

Communication

Documentation

Education

Bachelor's degree

Tools

Databricks

PySpark

Delta Lake

Flow Designer

Job description

Job summary:

You will be responsible for creating intelligent solutions using data analytics, working with specialized applications to pull data from databases and other sources, and identifying patterns and trends. You will present data in charts, graphs, and tables, designing and developing relational databases, and building data input screens. You will implement measures to contain compliance risk, identifies gaps in risk models, and delivers value through concrete analytical solutions to business problems using advanced tech tools and techniques.

Job responsibilities:

• Design rich data visualizations to communicate complex ideas and automate reporting and controls.

• Collaborate with stakeholders to share information from process-related activities and initiatives (e.g., trends, systemic issues, control weaknesses).

• Execute special projects as assigned by management.

• Build robust, auditable analytics pipelines and dashboards from multiple data sources.

• Translate policies and risk typologies into rules-based logic.

• Explain analytical findings to non-technical audiences and produce clear documentation.

• Document business requirements and generate SOPs for handover of automation to the Testing team for BAU activity.

• Contribute to continuous improvement by bringing new ideas and perspectives.

• Manage multiple projects focused on process automation and efficiency.

• Design MIS and reports for senior management.

• Maintain confidentiality and professionalism when handling sensitive information

Required qualifications, capabilities, and skills:

• Qualified graduate with 2 yrs of relevant experience in Data Analytics with hands-on proficiency with Python (pandas, numpy; packaging, logging, error handling).

• Advanced SQL (complex joins, subqueries, window functions, performance tuning).

• ServiceNow IRM/GRC and App Engine Studio: custom apps, data models, forms/UI policies, record producers, catalog items, workflows with Flow Designer, IntegrationHub, ACLs, basic scripting (GlideRecord).

• Alteryx Designer for ETL, data prep, and automation.

• Experience building analytics pipelines and dashboards.

• Strong analytical problem-solving skills.

• Excellent communication skills for explaining findings and producing documentation.

Preferred qualifications, capabilities, and skills:

• UiPath Studio for RPA workflows and orchestration basics.
• ThoughtSpot (Liveboards, Answers, TML).
• Databricks ecosystem (PySpark, Delta Lake, job scheduling, repos); experience scaling analytics on large datasets