Data Domain Architect Senior Associate Finance Data & Insights

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 firms 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 youwill assist in the development testing and on-going maintenance of finance data products for the Business Banking line of 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.