Investment Data Analyst: Master Financial Data & Analytics

Clearwater Analytics, Ltd.; City of Edinburgh; On-site; GBP 42,000 - 66,000; Full time

Job summary

Clearwater Analytics, Ltd. in Edinburgh is seeking a Financial Data Analyst to monitor and maintain asset data for clients, advising on security master, reference data, asset classes, corporate actions, cash flows, analytics, pricing, and performance.

You will respond to inquiries, design data elements, validate data with automated and manual processes, and collaborate with clients to implement innovative data solutions.

Qualifications

• Proficiency in advanced Excel and data analysis.
• Strong SQL skills for data validation and queries.
• Familiarity with reference data technologies and processes.
• Ability to work independently and with teams.
• Excellent attention to detail and documentation.
• Strong written and verbal communication.
• Excellent organizational and interpersonal skills.
• Problem-solving abilities.

Responsibilities

• Responds promptly and accurately to inquiries.
• Plans, designs, develops, and assesses data elements to ensure quality.
• Utilizes both manual and automated processes to validate data accuracy.
• Evaluates data vendors for accuracy, timeliness, and completeness.
• Serves as a content expert in data management.
• Collaborates with clients to brainstorm and implement data solutions.
• Maintains and updates securities data in real-time.
• Establishes a repository for process documentation.
• Performs basic SQL tasks and acquires fundamental SQL skills.
• Validates investment data against third-party market data sources.
• Nurtures relationships with data providers, clients, and service delivery managers.
• Contributes to the maintenance of reference data products.
• Develops understanding of fixed income and equity investments.
• Reviews and updates procedures to stay current.
• Escalates spending queries to address issues promptly.
• Acts as a reliable reference point for tasks and processes.
• Ensures compliance with risk and control checks in data management.
• Analyzes data flow between accounting and custody systems.
• Develops knowledge of corporate bonds and new bond issuance procedures.

Skills

Advanced Excel

SQL

Reference Data tools

Independent & collaborative work

Adaptability

Microsoft Office

Attention to detail

Documentation

Communication

Organizational skills

Interpersonal skills

Problem solving

Education

Bachelor’s or Master's degree in Business-related field

Tools

Reference Data tools

Job description

Clearwater Analytics, Ltd. in Edinburgh is seeking a Financial Data Analyst to monitor and maintain asset data for clients, advising on security master, reference data, asset classes, corporate actions, cash flows, analytics, pricing, and performance.

You will respond to inquiries, design data elements, validate data with automated and manual processes, and collaborate with clients to implement innovative data solutions.