Data Domain Architect, Associate

JPMorgan Chase & Co.
Wilmington, United States of America
7 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Junior

Job location

Wilmington, United States of America

Tech stack

Microsoft Excel
Agile Methodologies
Amazon Web Services (AWS)
Data analysis
ETL
Data Warehousing
Database Queries
Oracle Essbase
Hadoop
Lookup Table
Microsoft SQL Server
SQL Databases
Teradata
Information Technology
Data Analytics
Databricks

Job description

As a Data Domain Architect Associate on the CCB Finance Data & Insights Team, you will assist in the development, management, and maintenance of the Consumer Analytic Reporting Infrastructure (CARI) for the Consumer banking line of business. The role requires a strong technical and analytical background with a focus on understanding requirement from stake holders. Interaction between Finance, Information Technology, and other groups are required to ensure modifications to the infrastructure fully meet business requirements., * 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

Requirements

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., * 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

Benefits & conditions

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.

About the company

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.

Apply for this position