Manager Capital Markets Data Analysis

Capital Markets Business Data Analytics Manager

WHAT IS THE OPPORTUNITY?

The Capital Markets Business Data Analytics Manager oversees analytics projects and processes, providing data-driven insights for business performance. Oversee the development and implementation of reporting strategies within Capital Markets and the broader organization that best optimizes the efficiency and effectiveness of delivering data and required analytics to fulfill reporting, analysis and other use cases to support the business goals. Responsible for developing analytical tools and reports drawing from KPIs, industry trends, and customer and bank information. Collaborating with stakeholders, the incumbent is required to understand business objectives and challenges of the Capital Markets Division, and enterprise to translate business needs into complex data-related analyses and projects to enhance business performance, decision-making, and operational efficiency within the Capital Markets Division. The Manager is required to build and manage teams skilled in data operations, statistical methods, data analysis, data risk management and ensure compliance with enterprise data risk management policy and procedures.

WHAT WILL YOU DO?

Lead, manage, coach, and develop Associates and Analysts on the Capital Markets Data team, including workload allocation, performance management, establishing priorities and standards, aligned with Capital Markets business strategy Serve as the primary point contact for Capital Markets data, analytics, and management reporting initiatives. While maintaining appropriate documentation for data sources, reporting logic, calculations, and business definitions. Collaborate with T&I, Legal, Product Management and others to create and implement correct forms, products and services as they relate to the system application. Drive the automation of data mining, reporting tasks, and ad hoc requests for information and analysis. Support departmental systems, databases, and other technical infrastructure. Work with Capital Markets product teams to develop and automate departmental dashboards and reporting tasks. Develop executive level reporting that clearly identifies trends, opportunities, exceptions, and areas requiring management attention Run queries against application databases and/or the Bank’s data warehouse and assists with the preparation of periodic or ad hoc reports for distribution to line units, senior management, risk management units (e.g. Audit, Compliance and/or Credit Risk Review) or third parties (e.g. OCC, external auditors). Analyze departmental performance against forecasting benchmarks and KPIs (Key Performance Indicators). Implement new processes, systems, other initiatives to improve reporting accuracy Continuously evaluate existing reports and eliminate, consolidate, or automate reporting that is duplicative, manual, or no longer provides business value.

WHAT DO YOU NEED TO SUCCEED?

Required Qualifications* Bachelor's Degree or equivalent 10+ years' experience in financial services / banking experience 8+ years' experience in data analysis, including experience with database extraction tools like SQL alongside Visualization and ETL tools such as Tableau and Alteryx etc. 5+ years of Management Experience 5+ years working in a financial services business line function (e.g. Capital Markets or Corporate Banking) Additional Qualifications Technical Skills & Tools Extensive skill and experience using data extraction tools: SQL, Snowflake, Access, Excel, and similar data extraction/manipulation methods Proficiency with reporting/query tools such as Brio, MS Query, MS Access, Crystal Reports, and Business Objects Data visualization and ETL tools such as Tableau and Alteryx Programming experience using Java Server Pages & Scripts PC computing environments and database/data warehouse experience Computer literate with proficiency in MS Outlook, Word, Excel, PowerPoint, and Access Data Management & Process Skills Track record of developing and implementing effective repeatable processes and controls to ensure extracted data meets business needs Experience accessing data and performing data analysis from multiple and complex sources Business & Industry Knowledge Comprehensive knowledge of banking, client relationship management, and risk management Working knowledge of bank back office processes and systems (preferred) Knowledge of Capital Markets products such as FX, Interest Rate Derivatives, Syndications, Trade Finance, and Supply Chain Finance (preferred) Leadership & Communications Leadership skills and the ability to mentor and develop staff Excellent verbal and written skills sufficient to interact with all levels of colleagues Demonstrated ability to creatively design solutions to problems with industry/business knowledge

WHAT'S IN IT FOR YOU?

Compensation Starting base salary: $111,408 - $189,738 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions. Benefits and Perks Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start date Generous 401(k) company matching contribution Career Development through Tuition Reimbursement and other internal upskilling and training resources Valued Time Away benefits including vacation, sick and volunteer time Specialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programs Career Mobility support from a dedicated recruitment team Colleague Resource Groups to support networking and community engagement Get a more detailed look at our Benefits and Perks.

ABOUT US

Since day one we've always gone further than the competition to help our clients, colleagues and communities flourish. City National Bank was founded in 1954 by entrepreneurs for entrepreneurs and that legacy of integrity, community and unparalleled client relationships continues today. City National is a subsidiary of Royal Bank of Canada, one of North America’s leading diversified financial services companies. To learn more about City National and our dynamic company culture, visit us at About Us.

INCLUSION AND EQUAL OPPORTUNITY EMPLOYMENT

City National Bank fosters an inclusive environment where all forms of diversity are valued and leveraged to make us a better company and employer. We are an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sexual orientation, gender identity, national origin, disability, veteran status or other basis protected by law. It is unlawful in Massachusetts to require or administer a lie detector test as a condition of employment or continued employment. An employer who violates this law shall be subject to criminal penalties and civil liability. *Represents basic qualifications for the position. To be considered for this position, you must at least meet the required qualifications. careers.cnb.com accepts applications on an ongoing basis, until filled. Unless otherwise indicated as fully remote, reporting into a designated City National location is an essential function of the job. #J-18808-Ljbffr City National Bank