Data Analyst - Accounting

FUNCTION: The primary function of the Data Analyst is to assist in maintaining the transferring of financial data from custodial integrator to the Trust Accounting System for the trusts for which Commonwealth Trust Company serves as trustee. This role may also maintain systems, troubleshoot issues, correct and post transactions, and will help develop improved processes ongoing.

It is the responsibility of the Operations Department, to assure that the company’s fiduciary responsibilities are properly discharged as they relate to all areas of trust accounting, clients are served expeditiously and professionally, and that the company’s business is conducted in such a way as to both accomplish our client’s goals without creating undue risk to CTC. It is necessary to combine exemplary client service with diligent risk management

• ):
  
  Maintains Data Aggregator:
  Adds/Deletes Accoun
• ts.
  
  Utilizes knowledge regarding Cheetah Transaction Types and associated Broker Composite Types to maintain Cheetah for Transaction Imports and Custody Set-
• Up.Pulls Daily Transactions from Data Aggregator and manipulates in preparation of file load into Accutech Cheetah (2000 lines at month-end, 300-500 dail
• y).Identifies patterns within and across brokers for Data Aggregat
• or.
  
  Maintains Historical Data and Transaction Typ
• es.
  
  Inloads Daily File Transactio
• ns.
  
  Reviews and Posts transaction import errors and other manual transactions, such as Corporate Actio
• ns.
  
  Maintains (in conjunction with the Senior Data Analyst) the trust accounting reconciliation proce
• ss.
  
  Develops relationships with Staff Accountants to ensure consistent feedback for the daily transaction import proce
• ss.
  
  Completes special data analysis, reporting and accounting projects as assign

ed.

• RED:
  
  Must have a bachelor’s degree in accounting, management information systems, data/business analytics, computer science, or related
• field
  
  Must have advanced knowledge of Microsoft Excel (mastery of all functions), and Intermediate knowledge of other Microsoft Office applica
• tions
  
  Prior knowledge of and experience in Accounting and Finance required, including familiarity with financial state
• ments
  
  Past experience with Trust Accounting software pref
• erred
  
  Experience working with Data analytics software packages a
• MENTS:
  
  Must be detail oriented and have strong problem solving and communication
• skills.
  
  Excels at developing and maintaining good working relationships with colleagues and c
• lients.
  
  Demonstrates an excellent work ethic, high standards, integrity and understanding of the importance of confident
• iality.
  
  Works effectively with other team members and departments and functions very well with independent responsibi
• lities.
  
  Must have excellent organizational
• skills.
  
  Must have the ability to learn and master new technologies q
• uickly.
  
  Must be able to recognize patterns, compile and analyze data and find
• errors.
  
  Excels at independent research but knows when to ask for guidance or ass
• istance
  
  Ability to work with large data sets and spend long periods of time reviewing info

rmation

• REMENTS:
  
  Prolonged periods sitting at a desk and working on a c
• omputer.
  
  Must be able to lift up to 15 pounds a