CCB- Data Domain Architect - Associate

Job Description The Finance Data & Insights Team is an agile product team responsible for the development, production, and transformation of Financial data and reporting across CCB. Our vision is to improve the lives of our people and increase value to the firm by leveraging the power of our data and the best tools to analyze data, generate insights, save time, improve processes & control, and lead the organization in developing skills of the future. Our overall product objectives include: 1) constructing a data environment that enables cross-business, customer-centric decision making and reporting needs across CCB in a consistent framework; 2) creating an ecosystem of dashboards, sourced from authoritative data sources, to replace all manual management reporting and to allow our employees to focus on generating actionable insights; 3) eliminating user tools, saving time, and increasing ability to generate insights through data, dashboards, and developing new capabilities.
Job Description:
Data Analysis and Business Management: This position 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. The role requires a strong technical and analytical background with a focus on reconciliation and analysis between multiple data sources. Interaction between Finance, Information Technology, and other groups are required to ensure modifications to the infrastructure fully meet business requirements.
Role and Responsibilities:

• Perform financial data analysis between the general ledger and data warehouse
• Work closely with the business users/analysts to understand requirements and functional needs.
• Ability to create and 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.
• Ensure reconciliation of existing financial systems, including general ledger and account based applications leveraging Essbase, Tableau and SQL
• Ability to leverage Essbase providing analysis and reporting across all levels of management, including cross line of business
• Provide a high level of responsiveness to ad-hoc requests, "what-if" scenario data analytics, and regulatory inquiries.

Skills / Competencies Needed/Education Qualifications:

• 3+ years of total experience within MIS, Business Intelligence, and/or Analytics roles
• 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 Server/Teradata, Cognos/BO, SAS/R.
• 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
• Big Data/Tableau experience a plus.

#LI-HYBRID
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 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. In accordance with applicable law, we make reasonable accommodations for applicants' and employees' religious practices and beliefs, as well as any mental health or physical disability needs.
The health and safety of our colleagues, candidates, clients and communities has been a top priority in light of the COVID-19 pandemic. JPMorgan Chase was awarded the "WELL Health-Safety Rating" for all of our 6,200 locations globally based on our operational policies, maintenance protocols, stakeholder engagement and emergency plans to address a post-COVID-19 environment.
As a part of our commitment to health and safety, we have implemented various COVID-related health and safety requirements for our workforce. Employees are expected to follow the Firm's current COVID-19 or other infectious disease health and safety requirements, including local requirements. Requirements include sharing information including your vaccine card in the firm's vaccine record tool, and may include mask wearing. Requirements may change in the future with the evolving public health landscape. JPMorgan Chase will consider accommodation requests as required by applicable law.
We offer a competitive total rewards package including base salary determined based on the role, experience, skill set, and location. For those in eligible roles, discretionary incentive compensation which may be 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.
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.