Client Relationship Manager Analytics Lead - Vice President

JPMorgan Chase & Co.; City of Rochester (NY); On-site; USD 120,000 - 160,000; Full time

Job summary

JPMorganChase Workplace Solutions seeks a CRM Analytics Lead to drive reporting automation and data analytics for the Client Relationship Management team. The role combines project management with hands-on technical work in Python and VBA, advanced Excel, and compelling PowerPoint storytelling for senior stakeholders.

You will build scalable data pipelines, governance for KPI definitions, and executive-ready decks that translate complex data into actionable recommendations across client

Qualifications

• Bachelor’s degree inBusiness, Finance, Analytics, Information Systems, or related field preferred.
• 2+ years of experience in business management, analytics, business transformation, project management, consulting, or a similar role in a fast-paced environment.
• Advanced Excel and PowerPoint skills (Pivot Tables, complex formulas, structured models, executive-ready slide design).
• Demonstrated experience building reporting automation and repeatable analytics solutions using Python and/or VBA.

Responsibilities

• Design and maintain automated reporting solutions for CRM leadership and client teams, improving speed, accuracy, and consistency of recurring deliverables (weekly/monthly/quarterly business reviews).
• Build and enhance analytics dashboards and KPI frameworks (e.g., client health, revenue/growth performance, adoption trends, service metrics, pipeline activity) with clear definitions and governance.
• Develop repeatable data pipelines and analysis workflows using Python and/or VBA (as well as Excel Power Query/Pivot Tables), with strong documentation and controls.
• Identify data quality gaps and partner with stakeholders to improve source-of-truth alignment, metric definitions, and reporting processes.
• Produce high-quality, data-driven PowerPoint materials for senior leadership updates, client strategy discussions, and business reviews, translating quantitative insights into an executive narrative.
• Create compelling visualizations and “story-first” decks that connect results, drivers, risks, and recommended actions.
• Manage presentation timelines in a fast-paced environment, ensuring accuracy, design excellence, and message discipline.
• Project manage key workstreams that support the CRM operating model, including strategic initiatives, process improvements, and rollout of new tools/workflows.
• Maintain core project artifacts (plans, RAID logs, status reporting, stakeholder updates, post-implementation reviews) and drive timely decision-making and escalation.
• Partner with CRM leadership, product partners, operations, and technology teams to define future-state workflows and support implementation of enabling platforms.
• Coordinate business rhythms (monthly/quarterly reviews, leadership readouts, planning sessions) including agenda setting, content development, and follow-ups.
• Identify, escalation, and help mitigate operational risks related to reporting, data handling, and recurring deliverables; implement sustainable controls and documentation.
• Drive continuous improvement through simplification, standardization, and automation—reducing manual work and increasing transparency for stakeholders.

Skills

Python

VBA

Excel

PowerPoint

Project management

Education

Bachelor's degree

Tools

Power BI

Tableau

Alteryx

Job description

About JPMorganChase Workplace Solutions (JPMWS)

J.P. Morgan Workplace Solutions (JPMWS) has a diverse client base of over 2000 corporate clients, ranging from early-stage start-ups to established multinational corporations, JPMWS manages nearly $370 billion in assets for 1.8 million corporate employee participants. Our team has over 600 experienced professionals in 17 locations worldwide.

Role Summary

As a CRM Analytics Leadwithin the Workplace Solutions Client Relationship Management team, you will help drive business performance by leading reporting automation, data analytics, and executive-ready presentations that enable the team to deliver exceptional outcomes. You will act as a trusted partner to CRM leadership by bringing structure, governance, and a data-driven mindset to high-impact initiatives, while building scalable tools and insights across client satisfaction, revenue and growth, pipeline activity, and operational performance. You will also work closely with the broader Client Service leads to bring a holistic picture of our clients to a wider audience.

This role is ideal for a candidate who blends strong project management and stakeholder influence with hands‑on technical capability (Python and/or VBA), advanced Excel skills, and the ability to translate complex data into clear narratives via PowerPoint.

Key Responsibilities

Reporting Automation & Analytics

• Design and maintain automated reporting solutions for CRM leadership and client teams, improving speed, accuracy, and consistency of recurring deliverables (weekly/monthly/quarterly business reviews).
• Build and enhance analytics dashboards and KPI frameworks (e.g., client health, revenue/growth performance, adoption trends, service metrics, pipeline activity) with clear definitions and governance.
• Develop repeatable data pipelines and analysis workflows using Python and/or VBA (as well as Excel Power Query/Pivot Tables), with strong documentation and controls.
• Identify data quality gaps and partner with stakeholders to improve source-of-truth alignment, metric definitions, and reporting processes.

Executive & Client-Facing Presentations

• Produce high-quality, data-driven PowerPoint materials for senior leadership updates, client strategy discussions, and business reviews, translating quantitative insights into an executive narrative.
• Create compelling visualizations and “story-first” decks that connect results, drivers, risks, and recommended actions.
• Manage presentation timelines in a fast-paced environment, ensuring accuracy, design excellence, and message discipline.

Business Management, Project Delivery & Governance

• Project manage key workstreams that support the CRM operating model, including strategic initiatives, process improvements, and rollout of new tools/workflows.
• Maintain core project artifacts (plans, RAID logs, status reporting, stakeholder updates, post-implementation reviews) and drive timely decision-making and escalation.
• Partner with CRM leadership, product partners, operations, and technology teams to define future-state workflows and support implementation of enabling platforms.
• Coordinate business rhythms (monthly/quarterly reviews, leadership readouts, planning sessions) including agenda setting, content development, and follow-ups.

Risk, Controls & Continuous Improvement

• Identify, escalation, and help mitigate operational risks related to reporting, data handling, and recurring deliverables; implement sustainable controls and documentation.
• Drive continuous improvement through simplification, standardization, and automation—reducing manual work and increasing transparency for stakeholders.

Required Qualifications, Skills & Capabilities

• Bachelor’s degree (Business, Finance, Analytics, Information Systems, or related field preferred).
• 2+ years of experience in business management, analytics, business transformation, project management, consulting, or a similar role in a fast-paced environment.
• Advanced Excel and PowerPoint skills (Pivot Tables, complex formulas, structured models, executive-ready slide design).
• Demonstrated experience building reporting automation and repeatable analytics solutions usingPython and/or VBA(e.g., automating data prep, reconciliations, KPI packs, or dashboards).
• Strong project management and stakeholder management skills, including the ability to drive execution across multiple partners and competing priorities.
• Excellent written and verbal communication skills, with a proven ability to present insights and recommendations to senior audiences.
• High attention to detail, strong ownership mindset, and comfort operating in time-pressured, high-visibility situations.

Preferred Qualifications

• Experience with data visualization tools (e.g., Tableau, Power BI) and/or Alteryx.