Skip Navigation

Search Jobs

You Belong at City National

At City National, we are constantly in search of experienced, client service oriented professionals who want to become a part of our team and make a difference.

GL Analyst

Job ID BIS-8273 CityLos Angeles StateCalifornia Exempt/Non ExemptExempt ShiftDay Work ScheduleMonday-Friday, 8-5
Works within the Loan Servicing Department to perform data reporting and analysis of new and renewal loans to ensure accuracy in fed call reporting.
  • Responsible for overseeing and monitoring the Fed Call Coding matrix is up to date and covers the full loan portfolio, both consumer and commercial as designed in collaboration with controllers department and Credit Portfolio Review.
  • Responsible for reconciling the general ledger to loan level detail on an ad hoc basis or as scheduled. Research and document discrepancies for corrective action.
  • Run monthly queries to test accuracy of loan portfolio against Fed Call Coding matrix. Make correcting entries as appropriate.
  • Work with various internal groups to obtain inputs, gather data requirements, and respond to questions and inquires. Work with stakeholders to troubleshoot data gaps and issues.
  • Maintain and safe keep all underlying source documents attributed to any changes.
  • Obtain data extracts and downloads needed to populate templates or run exception queries. Develop/refine data extracts as needed.
  • Perform data discrepancy research and analysis. Perform balancing and reconciliation of data to target totals.
  • Design and develop supporting reports/tools.
  • Maintain reporting requirements for templates, including updates/changes to mapping files, hierarchies and methodologies. Make changes to workbooks and working files as needed. Maintain business logic rules.
  • Identify and support implementation of process improvements.
  • Creates ad hoc reports.
Basic Qualifications:
  • *Minimum of 4 years of financial analysis or general ledger to loan system reconcilement experience
  • *Minimum of 4 years of advanced Excel experience including macros and pivot tables
  • *Minimum of 4 years of experience in a financial services environment
Skills and Knowledge
  • Highly preferred: Technical -- Technology side: SQL, VBA, BI tools, task automation; Functional side: global level regulatory and financial reporting, global level accounting reconciliation
  • Highly preferred: Analytical -- Ability to reverse engineer from limited data or hard-copy reports to identify accurate underlying data sources and selection criteria to build automated models that replicate and enhance existing reports and processes.
  • Highly preferred: Lateral Thinking -- Ability to source, observe and assimilate discrete information into a validated hypothesis to improve data governance and facilitate process improvement.
  • Excellent interpersonal, verbal and written communication skills to effectively communicate with all levels of bank colleagues and clients.
  • Ability to organize analyzed data into simple, complete and concise presentation formats; envision the global issue, separate symptoms from causes, research thoroughly; weigh costs/benefits and derive sound conclusions.
  • Excellent project management skills, including the ability to prioritize tasks and handle multiple projects at the same time, working under tight deadlines.
  • MS Office (Outlook, Word, Excel, PowerPoint, Access).
  • Knowledge of banking and general accounting a plus.
  • Knowledge of FIS and AFS loan systems a plus.
  • Knowledge of PeopleSoft a plus
  • Bachelors' degree in Finance or Accounting preferred
*Represents basic qualifications for the position. To be considered for this position you must at least meet the basic qualifications.

City National Bank is an Equal Opportunity Employer - Affirmative Action Employer, Minorities/Females/Individuals with Disabilities/Veterans

Note: This 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.

Note: Candidates should be advised that City National Bank does not pay interviewee travel expenses or relocation expenses for candidates who are hired unless previously agreed.

Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
Join Our Talent Community

Join our Talent Community and receive City National job alerts and communications.

Select Interests

  • Finance/Accounting, Los Angeles, California, United StatesRemove