Analytics Solutions [Multiple Positions Available]
About The Position
Duties: Produce monthly firmwide headcount trends analysis, identifying locations with significant changes as well as monitoring the firm's global key locations headcount movement. Responsible for the monthly workflow that provides teams with the monthly fixed asset balance report. Maintain and trouble-shoot a workflow that produces daily underlying data for Global Real Estate capital planning and execution tracking. Maintain and trouble-shoot a workflow that produces weekly reports of GRE capital data integrity, which is crucial in budget forecasting and capital planning. Responsible for analyses of our global real estate portfolio to provide insights into the current and projected age of the portfolio and areas of focus for upcoming investment decisions. Responsible for estimating the occupancy cost per seat for tenants of our office portfolio. Conduct complex analytical work, and report results to senior bank leadership. QUALIFICATIONS: Minimum education and experience required: Master's degree in Accounting, Mathematics, Statistics, Economics, or related field of study plus three (3) years of experience in the job offered or as Analytics Solutions, Accountant, Accounting Analyst, Corporate Strategy Analyst, Business Management Analyst, Data Analyst, or related occupation. The employer will alternatively accept a Bachelor's degree in Accounting, Mathematics, Statistics, Economics, or related field of study plus five (5) years of experience in the job offered or as Analytics Solutions, Accountant, Accounting Analyst, Corporate Strategy Analyst, Business Management Analyst, Data Analyst, or related occupation. Skills Required: This position requires experience with the following: automating the production and delivery of recurring data- driven reports using Alteryx, SQL, Excel, and VBA frameworks; applying advance Excel techniques including index match, xlookup functions, advanced macros, to enhance data manipulation and reporting efficiency; designing interactive Excel workbooks with array-based formulas and advanced macros to support data analysis; utilizing Alteryx to process and analyze large datasets, enabling robust data integration across systems; leveraging SQL for querying, managing, and analyzing datasets; creating insightful data visualizations and dashboards in Tableau to support strategic decision making; synthesizing extensive datasets into actionable insights to optimize portfolio management strategies; and developing advanced PowerPoint presentations. We offer a competitive total rewards package including base salary determined based on the role, experience, skill set, and location. For those in eligible roles, discretionary incentive compensation which may be awarded in recognition of individual achievements and contributions. We also offer a range of benefits and programs to meet employee needs, based on eligibility. These benefits include comprehensive health care coverage, on-site health and wellness centers, a retirement savings plan, backup childcare, tuition reimbursement, mental health support, financial coaching and more. Additional details about total compensation and benefits will be provided during the hiring process. In addition, please visit: https://careers.jpmorgan.com/us/en/about-us.
Requirements
- Master's degree in Accounting, Mathematics, Statistics, Economics, or related field of study plus three (3) years of experience in the job offered or as Analytics Solutions, Accountant, Accounting Analyst, Corporate Strategy Analyst, Business Management Analyst, Data Analyst, or related occupation. The employer will alternatively accept a Bachelor's degree in Accounting, Mathematics, Statistics, Economics, or related field of study plus five (5) years of experience in the job offered or as Analytics Solutions, Accountant, Accounting Analyst, Corporate Strategy Analyst, Business Management Analyst, Data Analyst, or related occupation.
- automating the production and delivery of recurring data- driven reports using Alteryx, SQL, Excel, and VBA frameworks
- applying advance Excel techniques including index match, xlookup functions, advanced macros, to enhance data manipulation and reporting efficiency
- designing interactive Excel workbooks with array-based formulas and advanced macros to support data analysis
- utilizing Alteryx to process and analyze large datasets, enabling robust data integration across systems
- leveraging SQL for querying, managing, and analyzing datasets
- creating insightful data visualizations and dashboards in Tableau to support strategic decision making
- synthesizing extensive datasets into actionable insights to optimize portfolio management strategies
- developing advanced PowerPoint presentations
Responsibilities
- Produce monthly firmwide headcount trends analysis, identifying locations with significant changes as well as monitoring the firm's global key locations headcount movement.
- Responsible for the monthly workflow that provides teams with the monthly fixed asset balance report.
- Maintain and trouble-shoot a workflow that produces daily underlying data for Global Real Estate capital planning and execution tracking.
- Maintain and trouble-shoot a workflow that produces weekly reports of GRE capital data integrity, which is crucial in budget forecasting and capital planning.
- Responsible for analyses of our global real estate portfolio to provide insights into the current and projected age of the portfolio and areas of focus for upcoming investment decisions.
- Responsible for estimating the occupancy cost per seat for tenants of our office portfolio.
- Conduct complex analytical work, and report results to senior bank leadership.
Benefits
- competitive total rewards package including base salary determined based on the role, experience, skill set, and location
- discretionary incentive compensation which may be awarded in recognition of individual achievements and contributions
- comprehensive health care coverage
- on-site health and wellness centers
- a retirement savings plan
- backup childcare
- tuition reimbursement
- mental health support
- financial coaching
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Credit Intermediation and Related Activities
Number of Employees
5,001-10,000 employees
