Analytics Solutions Manager- Associate

If you are a strategic thinker passionate about driving solutions in analytics, you have found the right team.

As an Analytics Solutions Manager- Associate within our analytics organization, you lead development of dimensional and domain-oriented analytics data models optimized for BI and self-service consumption. You will translate stakeholder needs into governed datasets and KPI definitions in Snowflake and/or Databricks using SQL as the primary transformation language. You will embed data quality, documentation, and performance best practices so downstream teams can reliably reuse models for self-service reporting.

Job Responsibilities 

• Lead development of dimensional and/or domain-oriented analytics data models optimized for BI and self-service consumption.

• Design and maintain a semantic layer defining standardized metrics, dimensions, entities, and business definitions.

• Translate stakeholder requirements into clear modeling deliverables, including grains, entities, metric logic, and acceptance criteria.

• Build transformations primarily in SQL and leverage Python for complex logic, automation, and validation as needed.

• Implement data quality controls, including tests, reconciliations, and anomaly checks tied to business-critical metrics.

• Optimize model performance in Snowflake and/or Databricks by applying efficient joins and storage/performance strategies.

• Collaborate with upstream teams to align source-to-model meaning, including semi-structured and NoSQL data considerations.

• Establish modeling standards covering naming conventions, documentation, lineage, metric governance, and change management.

• Document curated datasets and produce user guidance to enable correct adoption of semantic definitions.

• Support consumers by troubleshooting metric questions and improving usability of downstream analytics products.

Required Qualifications, Capabilities, and Skills 

• Hold a Master’s degree in IT, Computer Science, MIS, Operations Research, or related field plus 3 years of relevant experience, or hold a Bachelor’s degree in the same fields plus 5 years of relevant experience.

• Demonstrate advanced SQL capability, including complex joins, performance tuning, and incremental logic.

• Apply strong data modeling expertise across grains, facts/dimensions, conformed dimensions, SCDs, and metric design.

• Build or operate a semantic layer or metrics framework to standardize KPI logic and definitions.

• Model semi-structured data (e.g., JSON) and integrate NoSQL sources for analytics use cases.

• Use Snowflake and/or Databricks effectively in an analytics engineering context and apply practical Python for workflow automation and validation.

• Practice strong stakeholder partnership and documentation discipline to drive clarity, correctness, and measurable outcomes.

Preferred Qualifications, Capabilities, and Skills 

• Leverage experience with testing and documentation frameworks for analytics engineering.

• Apply familiarity with BI consumption patterns and tooling concepts (e.g., Tableau, Sigma, Looker).

• Utilize orchestration tooling knowledge (e.g., Airflow, Dagster, ADF) with an SLA and reliability mindset.

• Implement observability practices such as logging, alerting, and operational runbooks for data products.

• Optimize cost and performance trade-offs through pragmatic platform tuning and design decisions.

About UsAbout the TeamJ.P. Morgan’s Commercial & Investment Bank is a global leader across banking, markets, securities services and payments. Corporations, governments and institutions throughout the world entrust us with their business in more than 100 countries. The Commercial & Investment Bank provides strategic advice, raises capital, manages risk and extends liquidity in markets around the world.