Data Domain Architect Senior Associate - Finance Data & Insights
About The Position
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.
Requirements
- 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
Nice To Haves
- Databricks or AWS Cloud Experience
- Experience with Agile development framework
- Knowledge of Business Banking, Deposit Products, and or Cash Management products.
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.
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
Industry
Credit Intermediation and Related Activities
Education Level
No Education Listed
Number of Employees
5,001-10,000 employees
