Finance Risk Warehouse Analytics Solutions - Associate

Are you analytical, data-driven, technical and client focused Do you have strong communication skills and can seamlessly interact with Finance, Technology and Operations professionals to develop modifications to the reporting infrastructure as per the needs of the business partners

As a member of the Finance Risk Warehouse Analytics Solutions team, you will assist in the sourcing, development, management, and maintenance of analytics data for the Finance Risk Warehouse (FRW) and its consumption for the Consumer and Community Banking data/systems. The Finance Risk Warehouse is utilized to standardize data across all lines of business, providing reconciled, edited, validated, and adjusted data to corporate finance and risk teams for external reporting and internal treasury and risk management. This role requires a strong techno-functional and analytical background, with an emphasis on integrating business, operational, and financial metrics from multiple data sources.

Job Responsibilities:

• Partner closely with the business reporting teams (CCB Controller teams, Regulatory, Treasury, and Risk) to understand information requirements and translate that into FRW data sourcing requirements and related JIRAs. This includes demand/story management in an agile framework across multiple product teams. It also includes working with our sub LOB data suppliers (servicing platform product, operational and technical leads) to determine where/if information is available and the controls around it.
• Determine impact to data flows due to new products, new systems or other CCB business changes.
• Negotiate amongst a range of possible solutions in a way that is most beneficial to the firm broadly.
• Assist CARI and other CCB consumers in getting access to/automated flows of data from FRW, especially those businesses that are supported by non CCB systems.
• Conduct UAT testing for enhancement requests and confirm post-production release results.
• Work with technical leads to develop end to end timelines (CCB system source through to FRW) to ensure sprint alignment across the various product teams.
• Investigate production data issues/anomalies with CCB line of business teams (Finance, Operations, and Technology).
• Serve as an escalation point for issues and deployed solutions.
• Determine opportunities where FRW reports can address needed gaps prior to strategic buildouts in CARI or FRI/LRI/etc.

Required qualifications, capabilities and skills

1. 5+ years of total experience within MIS, Business Intelligence, and/or Analytics roles
2. Ability tomanage multiple projects at once.
3. Ability to translate information requirements into data sourcing and functional requirements that can be clearly understood by the technical teams and the ability to explain technical issues in a way business users understand.
4. Highly motivated, self-directed
5. Ability to work in a fast-paced, dynamic environment
6. Strong analytical and problem-solving skills with proven ability to interpret and analyze data, identify anomalies, determine root cause, and recommend solutions.
7. Strong written and verbal communication skills with ability to influence an audience.
8. 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
9. Basic understanding of primary lending or deposit products offered by CCB businesses.

Preferred qualifications, capabilities and skills

1. Knowledge of and exposure to Agile methodology and governance principles preferred.
2. Cloud datawarehouse experience, e.g. AWS, Databricks.