Data Domain Architect Associate

JPMorganChase; Wilmington (DE); On-site; USD 65,000 - 95,000; Full time

Job summary

JPMorgan Chase is seeking a data-focused analyst to collaborate with Finance, Technology, and Operations to improve reporting infrastructure and meet business partner needs.

You will translate requirements into prototype solutions, participate in UAT, and support production migrations while validating results against business expectations. Strong SQL, Excel, and BI skills are essential, with experience in data modeling and dashboarding.

Qualifications

• 1+ years of MIS, BI, and/or Analytics roles.
• Strong analytical and problem‑solving skills with data interpretation.
• Proficient in SQL query writing across Teradata/SQL Server/Hadoop/Databricks.
• Proficient in Excel including Pivot, VLOOKUP, and trend analysis.
• Must understand ETL, Data Modeling, Reporting Automation, and/or Dashboarding.
• Self-starter with strong communication and independence.

Responsibilities

• Collaborate with business users/analysts to understand requirements.
• Translate requirements into prototypes for enhancements with standards.
• Participate in UAT with end‑users/IT and test new functionality.
• Assist IT with migration of developed solutions to production.
• Validate production results against business requirements and expected results.
• Perform data reconciliation between financial systems and data warehouses using SQL and Essbase.
• Provide rapid response to ad-hoc requests, scenario data analytics, and regulatory inquiries.

Skills

MIS/BI/Analytics experience

Analytical thinking

SQL proficiency across platforms

Excel analysis

ETL/Data modeling/Dashboarding

Communication & proactivity

Tools

Teradata

SQL Server

Hadoop

Databricks

Job description

Job Description

You are analytical, data-driven, and technical. You have strong communication skills and are able to seamlessly interact with Finance, Technology and Operations professionals to develop modifications to the reporting infrastructure that fully meets business partner needs.

Job 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

Required Qualifications, Capabilities And Skills

• 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

Preferred Qualifications, Capabilities, And Skills

• Experience with Agile development framework
• AWS Cloud experience

ABOUT US

Chase is a leading financial services firm, helping nearly half of America's households and small businesses achieve their financial goals through a broad range of financial products. Our mission is to create engaged, lifelong relationships and put our customers at the heart of everything we do. We also help small businesses, nonprofits and cities grow, delivering solutions to solve all their financial needs.

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.

Equal Opportunity Employer/Disability/Veterans

About The Team

Our Consumer & Community Banking division serves our Chase customers through a range of financial services, including personal banking, credit cards, mortgages, auto financing, investment advice, small business loans and payment processing. We're proud to lead the U.S. in credit card sales and deposit growth and have the most-used digital solutions – all while ranking first in customer satisfaction.

The CCB Data & Analytics team responsibly leverages data across Chase to build competitive advantages for the businesses while providing value and protection for customers. The team encompasses a variety of disciplines from data governance and strategy to reporting, data science and machine learning. We have a strong partnership with Technology, which provides cutting edge data and analytics infrastructure. The team powers Chase with insights to create the best customer and business outcomes.