Finance Data & Insights - Data Domain Architect Senior Associate

Join the Finance Data & Insights Team, to play a key role in driving the transformation in how we report and analyze financial information across Consumer and Community Banking.

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.

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 Chase Consumer and Business Banking lines of business.  Your primary focus will be on supporting the integration of the Deposit 2.0 infrastructure via FRW into CARI plus supporting the CARI buildout to replace historical processes outside of our strategic infrastructure. You will focus on ensuring data quality, investigating authoritative data sources as well as doing deep reconciliations and variance explanations to shift us to “single source of truth”.

Job Responsibilities

1. Work closely with the business users/analysts to understand requirements and functional needs.
2. Translate business requirements into prototype solutions for new/enhancement requests, with appropriate standards.
3. Work closely with end-users/IT during the UAT phase of the project and perform testing to ensure new functionality meets end user requirements
4. Work with IT to migrate to production the developed solutions.
5. Validate that production results comply with business requirements and expected results.  
6. 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.
7. Provide a high level of responsiveness to ad-hoc requests, “what-if” scenario data analytics, and regulatory inquiries

Required qualifications, capabilities and skills

1. 5 years of total experience within MIS, Business Intelligence, and/or Analytics roles
2. Must be proficient in SQL query writing. Demonstrated knowledge of data warehousing concepts and exposure to one or more Business Intelligence toolsets and database platforms: Oracle/SQL, AWS, Snowflake or Databricks, Server/Teradata, Cognos/BO, or SAS/R. 
3. Must be proficient with analysis in Excel including but not limited to Pivot, Vlookup, trend analysis etc.
4. Must be proficient in one or more data & business intelligence concepts including ETL, Data Modeling, Reporting Automation, and/or Dashboarding.
5. Self-starter, team player, good communication skills, be proactive in asking help when needed
6. Ability to take cues/guidance and solve problems independently
7. Strong analytical and problem-solving skills with proven ability to interpret and analyze data, identify anomalies, determine root cause, and recommend solutions
8. Ability to handle multiple deliverables at the same time.

Preferred qualifications, capabilities, and skills

1. Experience with Agile development framework 
2. AWS Cloud experience