Data Domain Architect Associate: Finance Analytics & Reporting

JPMorgan Chase; Wilmington (DE); On-site; USD 110,000 - 140,000; Full time

Job summary

JPMorgan Chase is seeking a Data Domain Architect Associate to support the CCB Finance Data & Insights Team. You will help develop and manage the Consumer Analytic Reporting Infrastructure (CARI) and translate stakeholder requirements into robust solutions using SQL, ETL, and BI concepts.

You will work with Finance, IT, and operations to ensure production readiness, perform data reconciliations, and respond to ad-hoc data inquiries. Strong communication and collaboration skills are essential.

Qualifications

• 1+ years of total experience within MIS, Business Intelligence, and/or Analytics roles.
• Strong analytical and problem-solving skills with ability to interpret data, identify anomalies, and recommend solutions.
• Proficient in SQL query writing in Teradata/SQL Server/Hadoop/Databricks.
• Proficient with Excel including Pivot, VLOOKUP, and trend analysis.
• Familiar with ETL, Data Modeling, Reporting Automation, and Dashboarding.

Responsibilities

• Work with business users to understand requirements and translate into prototype solutions.
• Collaborate with end-users/IT during UAT and ensure functionality meets needs.
• Migrate developed solutions to production with IT.
• Validate production results against business requirements and expected outcomes.
• Reconcile and analyze data between Firm financial systems and CARI using SQL and BI tools.
• Provide rapid responses to ad-hoc requests and regulatory inquiries.

Skills

Analytical

Data-driven

Communication skills

SQL proficiency

Excel proficiency

ETL

Data Modeling

Reporting Automation

Dashboarding

Self-starter

Team player

Tools

Teradata

SQL Server

Hadoop

Databricks

Job description

JPMorgan Chase is seeking a Data Domain Architect Associate to support the CCB Finance Data & Insights Team. You will help develop and manage the Consumer Analytic Reporting Infrastructure (CARI) and translate stakeholder requirements into robust solutions using SQL, ETL, and BI concepts.

You will work with Finance, IT, and operations to ensure production readiness, perform data reconciliations, and respond to ad-hoc data inquiries. Strong communication and collaboration skills are essential.