About the Role
We are seeking a highly detail-oriented and analytical Data Analyst to join our team at an international law firm. This role involves reviewing, maintaining, and analyzing financial and transaction data using tools such as Microsoft Excel, MS Access, and proprietary internal software (DRRT GPS). You will play a critical role in processing securities litigation claims, identifying data deficiencies, and communicating findings across internal teams.
Responsibilities
- Responsible for cleaning up transaction data, identifying deficiencies, preparing proof of claims for class action settlements
- Reviewing, analyzing, and maintaining data, including investment transaction and loss calculation data, utilizing various software (MS Excel, MS Access and GPS)
- Responsible for managing and reviewing custodian confirmations in support of securities litigation claims.
- Analyzing results and able compiling, sorting, arranging, and presenting data, information, results following requirements
- Combine data, results generated from different systems and maintain the results in the secure destination
- Following requirement to export and update existing results at any time
- Transfer data from PDF files to Excel for routine analysis
- Create overviews and analysis reports when requested
- Efficiently transfer and input data between different applications
- Ability to effectively articulate whatever scenario is encountered during analysis
- Other duties may be assigned by management
Qualifications
- Bachelor's degree in computer science, business analytics, business administration, economics, management information systems or related field or equivalent related experience
- Knowledge in SQL, statistics, data analysis and research methods
- Proficiency in Microsoft office suite especially advanced Excel is a prerequisite do not apply if you don't have advance excel skills.
- Fundamental financial knowledge, including knowledge of different aspect financial derivatives, and ability to interpret financial statements, is required
- Knowledge in SPSS, R, Bloomberg or Python is a plus
- Solid analytical, problem solving and research skills
- Strong written, verbal communication skills
Skills and Abilities:
- Passionate working with data integration and analysis
- Ability to contribute both independently and as part of a team
- Ability to meet deadlines in high-pressure situations
- Ability to QA and troubleshoot data
- Ability to prioritize tasks and projects based on departmental needs
- Highly self-motivated, self-starter with a critical thinking mindset
- Excellent interpersonal, verbal, attention to detail, and written communication skills
- Dependable, detailed-oriented, great attitude and team player are required. Qualities will be assessed during the hiring process
