Data Analyst - Wilmington, United States - Commonwealth Trust Company

    Commonwealth Trust Company
    Commonwealth Trust Company Wilmington, United States

    2 weeks ago

    Default job background
    Description

    Job Description

    Job Description

    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.

    ESSENTIAL DUTIES & RESPONSIBILITIES (including, but not limited to):

    • Maintains Custodial Integration: Adds/Deletes Accounts.
    • 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 Custodial Integrator and manipulates in preparation of file load into Accutech Cheetah (2000 lines at month-end, daily).
    • Identifies patterns within and across brokers for Custodial Integrator.
    • Maintains Historical Data and Transaction Types.
    • Inloads Daily File Transactions.
    • Reviews and Posts transaction import errors and other manual transactions, such as Corporate Actions.
    • Maintains (in conjunction with the Senior Data Analyst) the trust accounting reconciliation process.
    • Develops relationships with Staff Accountants to ensure consistent feedback for the daily transaction import process.
    • Completes special data analysis, reporting and accounting projects as assigned.

    LEADERSHIP RESPONSIBILTIES: This position has leadership responsibility within the organization through organizational and communication-based activities inherent in the job duties and responsibilities. The individual in this position will work independently at times and perform a critical business function. While this role has no direct reports, it does require the ability to request information from others, give directions when needed and question potential issues and errors.

    CORE COMPETENCIES:

    • Organization
    • Attention to Detail
    • Problem Solving
    • Recognizing Patterns and Data Manipulation
    • Technology and Information Systems

    EDUCATIONAL BACKGROUND & EXPERIENCE REQUIRED:

    • Must have a bachelor's degree in accounting, management information systems, business analytics or related field
    • Must have advanced knowledge of Microsoft Excel (mastery of all functions), and Intermediate knowledge of other Microsoft Office applications
    • Prior knowledge of and experience in Accounting and Finance required, including familiarity with financial statements
    • Past experience with Trust Accounting software preferred
    • Experience working with Data analytics software packages a plus

    OTHER REQUIREMENTS:

    • Must be detail oriented and have strong problem solving and communication skills.
    • Excels at developing and maintaining good working relationships with colleagues and clients.
    • Demonstrates an excellent work ethic, high standards, integrity and understanding of the importance of confidentiality.
    • Works effectively with other team members and departments and functions very well with independent responsibilities.
    • Must have excellent organizational skills.
    • Must have the ability to learn and master new technologies quickly.
    • 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 assistance
    • Ability to work with large data sets and spend long periods of time reviewing information

    PHYSICAL REQUIREMENTS:

    • Prolonged periods sitting at a desk and working on a computer.
    • Must be able to lift up to 15 pounds at times.
    Company DescriptionServing some of the wealthiest clients in the world, Commonwealth Trust Company is an independent family-owned boutique trust company with almost 90 years in the business of providing trustee solutions. What sets us apart from all other trust companies is our specific focus on trust administration and not investment decisions, allowing for a singular, dedicated focus for our clients, many of whom run Fortune 500 enterprises. We are a local, privately owned non-depository trust company.

    Commonwealth offers competitive salaries, benefits (including medical, dental, 401k & more), generous Paid Time Off, flexible work arrangements, hybrid work opportunities, and a one of a kind culture where employees truly enjoy coming to work and being part of a world class team.

    Company Description

    Serving some of the wealthiest clients in the world, Commonwealth Trust Company is an independent family-owned boutique trust company with almost 90 years in the business of providing trustee solutions. What sets us apart from all other trust companies is our specific focus on trust administration and not investment decisions, allowing for a singular, dedicated focus for our clients, many of whom run Fortune 500 enterprises. We are a local, privately owned non-depository trust company.\r
    \r
    Commonwealth offers competitive salaries, benefits (including medical, dental, 401k & more), generous Paid Time Off, flexible work arrangements, hybrid work opportunities, and a one of a kind culture where employees truly enjoy coming to work and being part of a world class team.