Analytics Solutions [Multiple Positions Available]

Job Description
DESCRIPTION:
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.
Job Location: 545 Washington Blvd, Jersey City, NJ 07310.
Full-Time. Salary: $118,600.00-$165,000.00
About Us
JPMorganChase, one of the oldest financial institutions, offers innovative financial solutions to millions of consumers, small businesses and many of the world's most prominent corporate, institutional and government clients under the J.P. Morgan and Chase brands. Our history spans over 200 years and today we are a leader in investment banking, consumer and small business banking, commercial banking, financial transaction processing and asset management.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set and location. Those in eligible roles may receive commission-based pay and/or discretionary incentive compensation, paid in the form of cash and/or forfeitable equity, 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.
We recognize that our people are our strength and the diverse talents they bring to our global workforce are directly linked to our success. We are an equal opportunity employer and place a high value on diversity and inclusion at our company. We do not discriminate on the basis of any protected attribute, including race, religion, color, national origin, gender, sexual orientation, gender identity, gender expression, age, marital or veteran status, pregnancy or disability, or any other basis protected under applicable law. We also make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as mental health or physical disability needs. Visit our FAQs for more information about requesting an accommodation.
JPMorgan Chase & Co. is an Equal Opportunity Employer, including Disability/Veterans
About the Team
Our professionals in our Corporate Functions cover a diverse range of areas from finance and risk to human resources and marketing. Our corporate teams are an essential part of our company, ensuring that we're setting our businesses, clients, customers and employees up for success.