Data Domain Architect Senior Associate - Finance Data & Insights

Description

Are you a skilled data professional with a passion for transforming raw data into actionable insights and a proven track record of learning and implementing new technologies? The Finance Data & Insights Team is an agile product team responsible for the development, production, and transformation of financial data and reporting across Consumer Community Banking. Our vision is to enhance the lives of our people and increase the firm's value by leveraging data and advanced tools to analyze information, generate insights, save time, improve processes and controls, and lead the organization in developing future-ready skills.

As a Data Domain Architect Senior Associate in the Consumer Community Banking Finance Data & Insights Team, you will assist in the development, testing and on-going maintenance of finance data products for the Business Banking line of business. You will focus on understanding data requirements, developing proof of concept data against requirements, comparing data sources, testing solutions, as well as preparing ad hoc analysis for our CFO (Chief Finance Officers) stakeholders. The type of data covered is everything from BB (Business Banking) Field scorecard data (how we measure all business banking field personnel performance) to lending data (e.g. originations and funded loans) to Deposits (new and lost accounts, associated cash management services, revenue earned), etc.

Job responsibilities

Work closely with the business stakeholders/analysts to understand reporting requirements and functional needs.

Translate business requirements into prototype solutions for new/enhancement requests,

Provide a high level of responsiveness to ad-hoc requests. Ability to understand broad business questions and determine the data that will help answer/give insights to the business question, perform “what-if” scenario data analytics, and regulatory inquiries.

Work closely with end-users/data product owners during the UAT phase of the project and perform testing to ensure new functionality meets end user requirements.

Validate that production results comply with business requirements and expected results.

Work with end users and the Business Intelligence team to develop and implement standard reporting solutions in support of Business Banking Finance.

Support BAU operating model for Business Banking Field scorecard requests including loading of user data and investigation of banker questions.

Required qualifications, capabilities, and skills

5+ 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: AWS or Databricks, Oracle/SQL Server/Teradata, Cognos/BO, or 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

Strong attention to detail with ability to understand and communicate bigger picture

Preferred qualifications, capabilities, and skills

Databricks or AWS Cloud Experience

Experience with Agile development framework

Knowledge of Business Banking, Deposit Products, and or Cash Management products.