Manager Capital Markets Data Analysis

City National Bank; Los Angeles (CA); On-site; USD 111,000 - 190,000; Full time

Benefits offered by this job

Healthcare coverage

401(k) matching

Tuition reimbursement

Paid time off

Specialized health and family planning

Career mobility support

Employee resource groups

Job summary

City National Bank is seeking a Capital Markets Business Data Analytics Manager to oversee analytics projects, drive data-driven insights, and develop reporting strategies across Capital Markets and the enterprise.

The role requires senior-level data analysis, leadership, and collaboration with stakeholders to translate business needs into complex data analyses and dashboards that improve performance and risk oversight.

Qualifications

• Bachelor's Degree or equivalent.
• 10+ years' experience in financial services / banking.
• 8+ years' experience in data analysis with SQL, visualization and ETL tools.
• 5+ years of management experience.
• 5+ years in Capital Markets or Corporate Banking.

Responsibilities

• Lead and develop Associates and Analysts on the Capital Markets Data team.
• Serve as the primary contact for data, analytics and reporting initiatives.
• Collaborate with TI, Legal, Product Management to implement forms and services.
• Drive automation of data mining, reporting tasks and ad hoc requests.
• Develop executive level reporting showing trends and opportunities.
• Run queries against databases and assist with periodic/ad hoc reports.
• Analyze performance against forecasts and KPIs; improve reporting accuracy.
• Evaluate and consolidate duplicative or non-value reporting.

Skills

Leadership

Data analysis

SQL

Tableau

Alteryx

Mentoring

Communication

Problem solving

Education

Bachelor's Degree

Tools

SQL

Snowflake

Access

Excel

Tableau

Alteryx

Brio

Crystal Reports

Business Objects

Job description

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.