Data Analyst (New Grad)
- Participate in the sourcing, validation, analysis, and reconciliation of data used for FR 2052a, CCAR FR Y-14, FR 2028D, FR Y-9C, FFIEC031/041, and FDIC 370 Regulatory reporting
- Experience and an enthusiastic interest in gaining additional expertise in areas such as risk/portfolio management and analysis, banking/trading product operations, finance/accounting, information systems, and/or retail/commercial lending are required
- Analyze commercial and consumer loan and portfolio data, advising management of trends and any significant changes in the quantity and quality of the data elements being reported
- Analyze data related to securities, derivatives, repos, and other trading products advising management of trends and any significant changes in the quantity and quality of the data elements being reported
- Participate in initiatives designed to improve existing processes or create new processes, and address changes to regulatory reporting requirements
- Perform prescribed analysis and ad hoc portfolio monitoring/reporting activities as assigned
- Perform prescribed data extraction and reporting activities as directed
- Knowledge of data governance and data management principles and processes
- Moderate experience with SQL
- Proficient with MS Office (Word, Visio, PowerPoint, Outlook) and SharePoint
- Strong natural affinity for structuring and organizing large amounts of data in order to satisfy continually evolving reporting needs
- Comfortable working both independently and collaboratively in a dynamic and fast-paced team environment
- Results oriented and delivery focused
Supports the execution of accurate and efficient reporting solutions for risk, regulatory and management information to internal and external stakeholders including regulatory bodies. Supports an efficient and effective risk management function which uses common information sources and practices, reduces ongoing costs, increases service level performance and minimizes risk.
- Designs, develops, and implements reporting solutions to meet management and regulatory reporting requirements.
- Provides advice and guidance to assigned business/group on implementation of analytical and reporting solutions.
- Executes work to deliver timely, accurate, and efficient service for scheduled reporting production processes.
- Supports the maintenance, monitoring, and measurement of key risk indicators to internal & external stakeholders.
- Analyses data and information to provide risk-related insights and recommendations for the assigned portfolio e.g. capital at risk modeling, risk/return assessments, etc.
- Supports the interpretation of internal and external policies and regulatory requirements relevant to the analytics and reporting mandate e.g. regulatory reporting.
- Works with various data owners to discover and select available data sources from internal sources and external vendors (e.g. lending system, payment system, external credit rating system) to fulfill analytical needs.
- Ensures strong governance and effective controls across risk reporting activities and information in accordance with enterprise standards.
- Analyzes data and highlights significant information including variances, trends, opportunities and exposures; escalates as required.
- Provides information and supports the process for internal and external audits.
- Gathers and formats data into regular and ad-hoc reports, and dashboards.
- Supports development and execution of strategic initiatives in collaboration with internal and external stakeholders.
- Builds effective relationships with internal/external stakeholders.
- Supports the maintenance of operational procedures and processes related to analytical and reporting processes.
- Supports the development of tools and delivery of training focused on awareness and understanding of key data elements used in risk reporting.
- Participates in the design, implementation and management of core business processes to ensure the accuracy of risk data used in reporting.
- Organizes work information to ensure accuracy and completeness.
- Focus may be on a business/group.
- Thinks creatively and proposes new solutions.
- Exercises judgment to identify, diagnose, and solve problems within given rules.
- Works mostly independently.
- Broader work or accountabilities may be assigned as needed.
Qualifications:
- Typically between 3 – 5 years of relevant experience and post-secondary degree in related field of study or an equivalent combination of education and experience.
- Knowledge of risk management metrics, KPIs and KRIs.
- Knowledge of industry trends and regulatory requirements for risk reporting.
- Product knowledge for the designated business/portfolio.
- Knowledge of risk management theory, processes and portfolio management reporting techniques.
- Knowledge of reporting & analytics concepts and applications.
- Knowledge of risk systems technology.
- Specialized knowledge from education and/or business experience.
- Verbal & written communication skills - In-depth.
- Collaboration & team skills - In-depth.
- Analytical and problem solving skills - In-depth.
- Influence skills - In-depth.