Transformation and Innovation Team - Analytics Solutions Senior Associate

Join a team that delivers innovative products and solutions that enable advanced use of data and technology to drive process optimization and enhanced analytics for Finance, P&A, and Business Management. 

As a Analytics Solutions Senior Associate, within the, you will build AI-ready analytics datasets and semantic models, with a strong emphasis on Databricks lakehouse engineering as the foundation for Finance reporting and planning use cases and support a strategic migration from Oracle Database / Essbase to a modern stack using Databricks for curated, governed data products and Atoti for semantic/cube analytics.

Job Responsibilities:

• Design and deliver curated analytics datasets in Databricks (conformed dimensions, metric-ready fact tables, standardized grains) that serve as the authoritative foundation for Finance semantic models and downstream consumption.
• Develop and optimize transformation logic and pipelines in Databricks (e.g., incremental processing patterns, performance tuning, cost-conscious compute usage), partnering with Technology while owning the data/modeling requirements and validation.
• Translate Databricks curated datasets into Atoti semantic/cube models (dimensions, hierarchies, measures, aggregation logic) and ensure performance and usability for Finance personas.
• Create and maintain structured semantic metadata (business definitions, synonyms, calculation narratives, grain constraints, permitted aggregations, known limitations) to improve GenAI grounding and reduce ambiguity/hallucination risk in natural-language analytics.
• Convert Essbase/Oracle logic into lakehouse and semantic-layer constructs, documenting mapping rules, assumptions, and gaps; support parallel runs and model validation.
• Ensure curated data + semantic models support Excel workflows via AnaplanXL, including drill paths, hierarchies, measure behavior, and user-facing definitions and  contribute to cutover readiness, issue triage, adoption metrics, and decommissioning of legacy Essbase/Oracle-dependent reporting by ensuring Databricks datasets and semantic models meet functional and performance requirements.
• Establish reusable Databricks patterns (data quality checks, validation harnesses, reconciliation templates) and contribute to playbooks for Finance lakehouse and semantic modeling.

Required qualifications, capabilities, and skills:

• Bachelor’s degree required (analytics, finance, engineering or related field), or equivalent experience; 4+ years of experience in data modeling, analytics engineering, data platform transformation, or Finance analytics roles (financial services preferred).
• Hands-on experience building curated datasets using Databricks (or equivalent lakehouse platform), including strong SQL and data transformation skills and an understanding of performance/cost tradeoffs..
• Experience designing semantic models for enterprise analytics (dimensions, measures, hierarchies, aggregation behavior) and partnering with BI/consumption teams.
• Working knowledge of GenAI integration patterns for analytics (e.g., natural-language-to-metrics, grounded responses via semantic layers) and how metadata quality impacts outcomes.
• Ability to translate legacy logic (e.g., Essbase/Oracle) into modern curated-layer and semantic-layer implementations, including reconciliation and validation.
• Strong analytical, independent problem-solving, and communication skills; able to partner effectively across Product, Technology and Finance stakeholders.
• High attention to detail, ownership mindset, and ability to manage multiple priorities in a fast-paced environment.

Preferred qualifications, capabilities & skills:

• Experience with Atoti (or similar OLAP/semantic tooling) and understanding of cube design/performance considerations.
• Familiarity with Excel-based consumption patterns and add-ins (including AnaplanXL).
• Hands-on familiarity with Model Context Protocol (MCP) concepts and patterns (tool/schema exposure, semantic discovery, guardrails), especially in the context of analytics/semantic layers.
• Exposure to data quality rules, lineage documentation, access controls/entitlements, and audit/control expectations in Finance and agile delivery experience and familiarity with Jira/Confluence.

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

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.