Strategic Trust Accounting Data Analyst

Commonwealth Trust Company; Wilmington (DE); On-site; USD 65,000 - 90,000; Full time

Job summary

Commonwealth Trust Company is seeking a Data Analyst to support the transfer of financial data from custodial integrator to the Trust Accounting System for the trusts it serves. The role may also maintain systems, troubleshoot issues, correct and post transactions, and help develop improved processes ongoing.

The position requires a bachelor’s degree in accounting, MIS, or related field, advanced Excel skills, and experience with trust accounting software.

Qualifications

• Bachelor’s degree in accounting, MIS, data analytics, CS or related field.
• Advanced knowledge of Microsoft Excel (mastery of all functions).
• Prior accounting/finance experience and familiarity with financial statements.
• Experience with Trust Accounting software and data analytics tools.
• Detail oriented with strong problem solving and communication skills.
• Proven ability to work with large data sets and maintain accuracy.

Responsibilities

• Maintains Data Aggregator: adds/deletes accounts.
• Uses Cheetah for transaction imports and custody set-up.
• Pulls daily transactions and preps files for load into Accutech Cheetah.
• Identifies patterns across brokers and data aggregates.
• Maintains historical data and transaction types.
• Reviews and posts transaction import errors and manual entries.
• Supports reconciliation procedures with staff accountants.
• Collaborates with team to improve daily data import processes.
• Executes special data analysis, reporting and accounting projects as assigned.

Skills

Excel mastery

Data analysis

Attention to detail

Problem solving

Communication skills

Organizational skills

Team collaboration

Learn new technologies quickly

Large data set handling

Education

Bachelor's degree in Accounting

Bachelor's degree in MIS

Bachelor's degree in Data Analytics

Bachelor's degree in Computer Science

Tools

Acutech Cheetah

Microsoft Excel

Trust Accounting software

Data analytics software packages

Job description

Commonwealth Trust Company is seeking a Data Analyst to support the transfer of financial data from custodial integrator to the Trust Accounting System for the trusts it serves. The role may also maintain systems, troubleshoot issues, correct and post transactions, and help develop improved processes ongoing.

The position requires a bachelor’s degree in accounting, MIS, or related field, advanced Excel skills, and experience with trust accounting software.