Data Domain Architect Associate — Finance Analytics

JPMorgan Chase & Co.; Wilmington (DE); On-site; USD 90,000 - 120,000; Full time

Job summary

JPMorgan Chase & Co. in Wilmington, DE is seeking a Data Domain Architect Associate to help develop, manage, and maintain the CARI reporting infrastructure for the Consumer banking line.

You will translate business requirements into prototype solutions, collaborate with Finance, IT and Operations, and ensure produced results meet business expectations. You will work closely with stakeholders, perform data analysis across financial systems, and support UAT and production migrations.

Qualifications

• 1+ years of total experience within MIS, Business Intelligence, and/or Analytics roles.
• Strong analytical and problem-solving skills with proven ability to interpret and analyze data, identify anomalies, determine root cause, and recommend solutions.
• Must be proficient in SQL query writing in any of the tool set such as Teradata/SQL server/Hadoop/Databricks or others.
• Must be proficient with analysis in Excel including but not limited to Pivot, Vlookup, trend analysis etc.
• Must be proficient in one or more data & business intelligence concepts including ETL, Data Modeling, Reporting Automation, and/or Dashboarding.
• Self-starter, team player, good communication skills, be proactive in asking help when needed. Ability to take cues/guidance and solve problems independently

Responsibilities

• Work closely with the business users/analysts to understand requirements and functional needs.
• Translate business requirements into prototype solutions for new/enhancement requests, with appropriate standards.
• Work closely with end-users/IT during the UAT phase of the project and perform testing to ensure new functionality meets end user requirements
• Work with IT to migrate to production the developed solutions.
• Validate that production results comply with business requirements and expected results.
• Reconcile and perform data analysis between the Firm’s financial systems (e.g. general ledger, Finance Risk Warehouse) and CARI and CARI to other data warehouses leveraging Essbase, SQL and future AWS Cloud tools.
• Provide a high level of responsiveness to ad-hoc requests, "what-if" scenario data analytics, and regulatory inquiries

Skills

MIS/BI/Analytics

Analytical skills

SQL proficiency

Excel proficiency

BI concepts

Independent / proactive

Tools

Teradata

SQL Server

Hadoop

Databricks

Job description

JPMorgan Chase & Co. in Wilmington, DE is seeking a Data Domain Architect Associate to help develop, manage, and maintain the CARI reporting infrastructure for the Consumer banking line.

You will translate business requirements into prototype solutions, collaborate with Finance, IT and Operations, and ensure produced results meet business expectations. You will work closely with stakeholders, perform data analysis across financial systems, and support UAT and production migrations.