Mgr Data Analytics and Reporting 1LOD

MGR DATA ANALYTICS AND REPORTING

1LOD

WHAT IS THE OPPORTUNITY Position will support the Risk Strategy and Governance program by leading the Data Analytics and Reporting team to provide solutions on data and reporting needs. Produce intelligence through querying data repositories generating periodic reports and identifying risk trends through quantitative and qualitative analysis. Implement analytical approaches and methodologies and assist in the interpretation of results. Present reports to management for use in decision making and strategic planning. Furthermore increase automation in processes related to data and reporting along the division to maximize productivity.

WHAT WILL YOU DO

• Define and maintain a reporting framework to support the monitoring and management of risk and control assurance activities for applicable 1LOD Risk categories as well as other ERM related programs and initiatives.
• Engage with internal and external stakeholders to understand needs and ensure reporting and outputs are in alignment to key risk programs.
• Responsible for design, implementation and maintenance of intuitive dashboards that deliver valuable insights for enabling data-driven decision making and automation of processes.
• Responsible for periodic risk reporting and analysis to support Risk and Compliance Disciplines in the Office of the President.
• Foster and maintain good working relationships with colleagues to meet expected service levels.
• Oversee, coach, mentor and develop staff to facilitate the achievement of the teams goals.
• Lead efforts involving analysis and reporting of risk profile, control performance and benchmark process performance against Key Risk Indicators and Risk Appetite Metrics, highlighting any exceptions or areas of concern.
• Lead standardization and improvement of quarterly Division Risk Committee presentation and develop aggregated view for all divisions under the Centralized Risk and Compliance unit and other materials as needed.
• Collaborate with larger Bank-level programs e.g. new system implementation or data initiatives to identify impacts and dependencies on reporting requirements.
• Discover patterns, insights, trends and anomalies from straightforward analyses, data sets and visualization tools.
• Understands concepts of data lineage and data stewardship in order to develop effective data analytics that provide the insights.
• Identify data quality issues and concerns and support data governance initiatives.
• Stay abreast on specific reporting standards, department reporting requirements and bank system changes/enhancements.

WHAT DO YOU NEED TO SUCCEED

Required Qualifications

• Bachelors Degree or equivalent.
• Minimum 5 years of experience in one or a combination of the following: reporting, analytics or modeling.
• Minimum 5 years of experience with SAS or SQL or other data management, reporting and query tools (Sharepoint, SAP, Business Objects, Tableau, Crystal reports, Dashboard, etc.).
• Minimum 5 years of experience in banking operations.

Additional Qualifications

• Masters Degree Preferred.
• Strong analytical and organizational skills with emphasis on report production and program management.
• Ability to effectively manage team and projects.
• Hands on experience gathering requirements, designing and coding new reports, maintaining and enhancing existing reports as well as designing dashboards.
• Report development experience utilizing Microsoft SQL Server Reporting Services (SSRS), Tableau, Business Objects, Crystal Reports or similar report development software.
• Advanced experience designing and generating scheduled and ad hoc reports using reporting/query tools i.e. Brio, Toad, SQL Developer, MS Access, Crystal Reports, Business Objects, etc.
• Expertise in statistical programming, data mining and machine learning tools (Python, SAS, R, etc.).
• Experience developing business applications using VBA code and Access forms.
• Must be detail-oriented and possess effective organizational and analytical skills.
• Understanding of banking processes and risk management programs.
• Ability to handle complexity and ambiguity.
• Must have excellent verbal and written communications skills and ability to communicate clearly and professionally with all levels of the organization.

WHATS IN IT FOR YOU

Compensation

• Starting base salary: $101,231 - $172,355 per year. Exact compensation may vary based on skills, experience and location.
• This job is eligible for bonus and/or commissions.

Benefits and Perks At 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 date.
• Generous 401k 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 weve 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 Americas 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.