Business Analyst Reporting Lead Job Listing at City National Bank in Los Angeles, CA (Job ID 10733)

Description

BUSINESS ANALYST REPORTING LEAD
WHAT IS THE OPPORTUNITY? Will be responsible for the Royal Bank of Canada ("RBC") template production process and other projects related to data integrity and reporting process improvements. Will participate in the data gathering, monitoring, balancing, preparation, and submission of all required template reporting to our parent company, RBC, to support consolidated financial and regulatory reporting requirements. Financial reporting includes monthly, calendar quarter, fiscal quarter and annual template submissions to RBC. Responsibilities include understanding template reporting requirements, obtaining data extracts, performing data analysis, preparing certain templates, monitoring the template process to ensure all templates are submitted timely and maintaining necessary mapping and process documentation. Supports financial regulatory reporting initiatives related to process improvements, report automation, policies and procedures documentation and other special projects when needed.
What you will do

• Lead the preparation and submission of RBC reporting templates and supporting documentation within established deadlines.
• Manage timing of template completion by all parties to ensure that all templates are prepared and filed on a timely basis within RBC deadlines.
• Review and identify errors and issues in data contained in the templates and supporting documentation prepared by team members and work with RBC to correct mapping issues when identified. Support data providers as they work toward resolution of found errors and issues.
• Stay current on new or changing RBC template requests and obtain clarity from RBC when needed on reporting requirements
• Implement new and changing RBC template reporting requirements, including the establishing of new processes or enhancements and automation of existing processes. Prepare associated memos and supporting documentation.
• Lead special projects in the RBC template reporting function, including the planning, design, and development of workflows and surrounding data gathering and analysis.
• Support maintenance of change management controls and preserve data lineage to mitigate reporting risks.
• Work closely with system developers to define specifications and provide feedback for process enhancements.
• Perform detailed testing for implementation of automated processes and provide post-implementation support.
• Collaborate within the Controllers department to implement process changes and reduce manual production efforts.
• Assist with Controllers department strategic initiatives to streamline and transform accounting operations.
• Develop compelling, well designed and automated dashboards that support financial and management reporting.
• Assist with other special projects, including initiatives from RBC, as requested.

Must-Have*

• Bachelor's Degree or equivalent
• 7+ years of experience in the financial analysis or reporting experience required.
• 3+ years of experience in the banking or Financial Services industry
• 3+ years of experience as an analyst supporting medium to large size projects

Skills and Knowledge

• Experience with database management applications, GL systems, query tools (PeopleSoft, Business Objects, etc.),
• Experience with SQL and Tableau.
• Knowledge of Alteryx, Snowflake, and PowerQuery highly desirable.
• Advanced experience in Microsoft Office (e.g., Excel, Word, PowerPoint).
• Ability to accurately, thoroughly, and efficiently analyze a high data volume and organize analyzed data into simple, complete and concise presentation formats
• Ability to identify the issue, separate symptoms from causes, and research thoroughly to derive supportable conclusions.
• Ability to work independently and manage numerous priorities simultaneously, working under tight deadlines.
• Excellent verbal/written communication skills and strong analytical skills required.
• Adapts procedures, processes and techniques to accomplish the requirements of the position.
• Must be able to think through complex problems and develop solutions
• Relies on experience and judgment to plan and accomplish assigned tasks and goals.
• Self-motivated with strong attention to detail and excellent work ethic
• May serve as a resource to others in the resolution of complex problems and issues.

Compensation Starting base salary: $87,027 - $138,965 per year. Exact compensation may vary based on skills, experience, and location. This job is eligible for bonus and/or commissions.
*To be considered for this position you must meet at least these basic qualifications
The preceding job description has been designed to indicate the general nature and level of work performed by employees within this classification. It is not designed to contain or be interpreted as a comprehensive inventory of all duties, responsibilities, and qualifications required of employees assigned to this job.
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. Get an inside look at our Benefits and Perks.
ABOUT CITY NATIONAL
City National Bank, a subsidiary of Royal Bank of Canada, is the largest bank headquartered in Los Angeles with $92.03 billion in assets as of April 30, 2024. Founded in 1954, City National provides personalized banking, investment and trust services in select markets including Los Angeles, Orange County, San Diego, the San Francisco Bay Area, New York City, Nashville, Atlanta, Delaware, Las Vegas, Washington D.C. and Miami.* In addition, the company and its investment affiliates manage or administer $96.83 billion in client investment assets. City National is dedicated to strengthening communities, and in 2023 alone, the company made more than $11 million in charitable contributions to nonprofits that support the communities it serves.

*City National Bank does business in Miami and the state of Florida as CN Bank.

For more information about City National, visit cnb.com.
EQUAL OPPORTUNITY EMPLOYER & REASONABLE ACCOMMODATION
City National Bank is an equal opportunity employer committed to promoting and maintaining a diverse, equitable and inclusive working environment where differences are valued and encouraged. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, veteran status or any other basis protected by the laws or regulations in the locations where we operate or in our Code of Conduct. READ MORE

If you are a qualified individual with a disability or a disabled veteran, you have the right to request a reasonable accommodation for any part of the employment process. Please contact us via email or leave a message at (213) 673-9139. These contact methods are dedicated to applicants whose disability prevents them from successfully applying online. Only messages left for this purpose will be returned. Responses may take up to two business days.

 Apply on company website