Senior Analytics Solution Associate

Testing Site - JPMC; Wilmington (DE); On-site; USD 120,000 - 150,000; Full time

Job summary

JPMorgan Chase is seeking a Finance Data & Insights Associate to design, develop, and optimize data solutions for Marketing Finance and Business Management. You will build a robust DataMart, streamline ETL pipelines with Databricks, and enable analytics via ThoughtSpot and Tableau.

The role requires collaboration with business stakeholders and cross-functional teams to deliver data-driven insights, reporting, and data governance across the marketing finance domain.

Qualifications

• 5+ years of experience in data management, data engineering, data lineage, data dictionaries, and making data discoverable.
• Bachelor’s degree in Computer Science, Information Systems, or related discipline.
• Strong knowledge of data architecture, data warehousing, and data integration, with a focus on the banking/financial services industry.
• Experience designing scalable data mart architectures (star/snowflake schemas).
• Proficiency with Python, Databricks, Snowflake or similar cloud data warehouse, and data modeling tools (ERWIN).
• Familiarity with ThoughtSpot, Tableau, Alteryx, or Essbase.

Responsibilities

• Design and implement data mart schemas consolidating data from multiple sources for Marketing Finance and Business Management.
• Collaborate with stakeholders to map requirements and calculation logic.
• Work with data engineers, analysts, and tech specialists to gather and analyze business needs.
• Develop and optimize ETL processes and data pipelines (Databricks).
• Create reporting environments using Databricks and ThoughtSpot for analytics and reporting.
• Partner with product teams to design insightful reporting and analytics solutions and ensure data discoverability for analysis.
• Maintain documentation on data mart architecture, models, ETL processes, and governance policies.

Skills

Data governance

Data management

Data lineage

Data warehousing

ETL processes

Python

Databricks

Snowflake

ThoughtSpot

Tableau

Alteryx

Essbase

Education

Bachelor’s degree in Computer Science or Information Systems

Tools

ERWIN

Databricks

Snowflake

Job description

Be an essential member of a diverse team of professionals dedicated to making a lasting impact!

As a Finance Data & Insights Associate on the Marketing Finance Data & Insights team, you will play a key role in designing, developing, and optimizing data solutions that support the Marketing Finance & Business Management functions. This position requires strong collaboration with business stakeholders and cross-functional teams to deliver a robust DataMart, efficient ETL processes, and insightful analytics and reporting solutions.

Job responsibilities

• Design and implement comprehensive and efficient data mart schemas that consolidate key data categories from various source systems, tailored to the needs of the Marketing Finance & Business Management functions.
• Collaborate with Business stakeholders to understand requirement and accordingly map source & calculation logic.
• Collaborate with cross-functional teams, including data engineers, data analysts, and technical specialists, to gather and analyze business requirements.
• Develop, implement, and optimize data workflows, Extract Transform Load (ETL) processes, and data pipelines using Databricks.
• Utilizing Databricks and ThoughtSpot tools, create a robust and efficient reporting environment for marketing Finance data analytics and reporting.
• Work closely with your business domain Product teams and business stakeholders to: 1) design and develop insightful reporting and analytics solutions that drive informed decision-making; 2) apply design led thinking to meet their needs, including making data discoverable and accessible for analytical needs.
• Maintain up-to-date documentation on data mart architecture, data models, ETL processes, and data governance policies.

Required qualifications, capabilities, and skills

• 5+ years of experience in data management, data engineering, data lineage, data dictionaries, and making data discoverable.
• Bachelor’s degree in Computer Science, Information System, or related discipline.
• Good Knowledge of data architecture, data warehousing, and data integration, with a focus on the retail banking or financial services industry.
• Expertise in designing and implementing scalable and efficient data mart architectures, including star schema, snowflake schema, and other data modeling techniques.
• Experience with Python, Databricks, Snowflake, or other Cloud Data Warehouse, Data Engineering, Data Modeling, ERWIN.
• Ability to deliver complex data projects in a fast-paced, dynamic environment.
• ThoughtSpot, Tableau, Alteryx, or Essbase experience.