VP, CRM Analytics & Client Insights Lead

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

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