Data Analyst

About the Role

Data Analyst

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