Senior Business Systems Analyst – Banking Data & Reports

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

Benefits offered by this job

Healthcare coverage (Medical, Dental,

Job summary

City National Bank is seeking a Business Systems Analyst III to design, test, implement and train users on a wide range of bank systems. You will serve as the business expert for development, maintenance, training, regulatory compliance and support of system processes across divisions.

You will coordinate project efforts, prepare requirements, run QA, and support end-users with documentation and training, while monitoring timelines, budget and quality standards.

Qualifications

• Minimum 5 years experience developing and customizing databases/systems for reporting purposes.
• Minimum 5 years experience designing and generating weekly, monthly and ad hoc reports using reporting/query tools such as Brio, MS Query, MS Access, Crystal Reports or Business Objects.
• Minimum 3 years experience working in a loan servicing/operations environment.
• Experience with Oracle and/or Oracle Analytics is highly preferred.
• Experience developing and customizing databases/systems for reporting purposes required.
• Experience designing and generating weekly, monthly and ad hoc reports using reporting/query tools such as Brio, MS Query, MS Access, Crystal Reports and Business Objects.

Responsibilities

• Determine business unit system needs and objectives and consults with business unit regarding problems with current business applications or systems, enhancements, or new functionality.
• Prepare business and system requirements for maintenance/enhancements and present recommendations to division management.
• Gather and write-up business and system requirements, prepare test scripts, quality controls all changes, develop and code documents and supports the division credit, loan documentation and loan services teams for trouble shooting hardware and software
• Conduct all user and quality assurance testing on current systems, new systems and future maintenance. Develop test scripts to quality control all changes. Interact with software vendors and BATS to implement software enhancements.
• Collaborate with Credit Administration, BATS, Legal, Product Management and others to create and implement correct forms, products and services as they relate to the system application.
• Provide system application support to end-users and effectively troubleshoot system application problems. Make system configuration changes or coordinate changes with vendors or BATS to correct identified problems.
• Prepare end-user documentation on system enhancements. Communicate key system changes to the user community. Provide continuous training and instruction to users on system application use and business processes.
• Monitor development activities relating to meeting project objectives, budget, quality standards and schedule.
• 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).
• Maintain current knowledge of related regulatory and bank policies and procedures.
• Represent the Bank by actively participating in outside civic and community affairs, business and industry-related organizations, and other professional activities as appropriate.

Skills

Analytical skills

Communication skills

Problem solving

Process management

Oracle Analytics

Tools

Brio

MS Query

MS Access

Crystal Reports

Business Objects

Oracle Procedures/Views

Java Server Pages

Oracle Analytics

Job description

City National Bank is seeking a Business Systems Analyst III to design, test, implement and train users on a wide range of bank systems. You will serve as the business expert for development, maintenance, training, regulatory compliance and support of system processes across divisions.

You will coordinate project efforts, prepare requirements, run QA, and support end-users with documentation and training, while monitoring timelines, budget and quality standards.