Securities Services Analytics/p&a Associate

JPMorgan Chase JPMorgan Chase · Banking · Mumbai, Maharashtra, India · Commercial & Investment Bank

This role focuses on data analysis, business intelligence, and dashboarding within the Securities Services P&A Finance Analytics team at JPMorgan Chase. The Associate will be responsible for designing, developing, and enhancing analytics solutions using platforms like Databricks and BI tools such as Tableau/Sigma/Power BI, with a focus on CFO-ready decisioning. Key responsibilities include data preparation, reconciliation, financial reporting, metric monitoring, and supporting special projects. Proficiency in SQL, data warehousing concepts, ETL, data modeling, and reporting automation is required, along with experience in tools like Python or R.

What you'd actually do

  1. Responsible for designing, developing, architecting, restructuring and defining the data (and metadata) needed to drive business execution and analytics.
  2. Planning , managing and implementing end to end solutions for data infrastructure and data products
  3. Analyze, prepare, and reconcile accounting and technical data; investigate anomalies and ensure alignment to source systems and finance controls.
  4. Creating financial business cases supporting business initiatives
  5. Reporting on and monitoring key metrics, driving data quality initiatives across the product area, and helping define future needs of the product area

Skills

Required

  • SQL query writing
  • Data warehousing concepts
  • Business Intelligence toolsets
  • Database platforms (AWS or Databricks, Oracle/SQL Server/Teradata)
  • BI tools (Tableau/Cognos/BO)
  • SAS/R
  • ETL
  • Data Modeling
  • Reporting Automation
  • Dashboarding
  • Data analysis tools
  • Programming languages (SQL, Python, R)
  • Excel
  • PowerPoint

Nice to have

  • Financial analysis domain experience
  • ThoughtSpot
  • Migration of BI projects
  • Cloud Data Warehouse experience (AWS, Databricks, Snowflake)
  • LLM/AI solutions

What the JD emphasized

  • Must be proficient in SQL query writing.
  • Demonstrated knowledge of data warehousing concepts and exposure to one or more Business Intelligence toolsets and database platforms: AWS or Databricks, Oracle/SQL Server/Teradata, Tableau/Cognos/BO, SAS/R
  • Must be proficient in one or more data & business intelligence concepts including ETL, Data Modeling, Reporting Automation, and/or Dashboarding.
  • Apply strong proficiency in data analysis tools and programming languages (e.g., SQL, Python, R).