Manager Capital Markets Data Analysis

Capital Markets Business Data Analytics ManagerWHAT 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 strategyServe 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 attentionRun 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 accuracyContinuously 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 equivalent10+ years' experience in financial services / banking experience8+ 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 Experience5+ years working in a financial services business line function (e.g. Capital Markets or Corporate Banking)Additional QualificationsTechnical Skills & ToolsExtensive skill and experience using data extraction tools: SQL, Snowflake, Access, Excel, and similar data extraction/manipulation methodsProficiency with reporting/query tools such as Brio, MS Query, MS Access, Crystal Reports, and Business ObjectsData visualization and ETL tools such as Tableau and AlteryxProgramming experience using Java Server Pages & ScriptsPC computing environments and database/data warehouse experienceComputer literate with proficiency in MS Outlook, Word, Excel, PowerPoint, and AccessData Management & Process SkillsTrack record of developing and implementing effective repeatable processes and controls to ensure extracted data meets business needsExperience accessing data and performing data analysis from multiple and complex sourcesBusiness & Industry KnowledgeComprehensive knowledge of banking, client relationship management, and risk managementWorking 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 & CommunicationsLeadership skills and the ability to mentor and develop staffExcellent verbal and written skills sufficient to interact with all levels of colleaguesDemonstrated ability to creatively design solutions to problems with industry/business knowledgeWHAT'S IN IT FOR YOU?CompensationStarting 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 PerksAt City National, we strive to be the best at whatever we do, including the benefits and perks we offer our colleagues including:Comprehensive healthcare coverage, including Medical, Dental and Vision plans, available the first of the month following start dateGenerous 401(k) company matching contributionCareer Development through Tuition Reimbursement and other internal upskilling and training resourcesValued Time Away benefits including vacation, sick and volunteer timeSpecialized health and family planning benefits including fertility benefits, and cancer, diabetes and musculoskeletal support programsCareer Mobility support from a dedicated recruitment teamColleague Resource Groups to support networking and community engagementGet a more detailed look at our Benefits and Perks.ABOUT USSince 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 EMPLOYMENTCity 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.