Financial Data Analyst

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

Job Summary

The Financial Data Analyst is responsible for monitoring and maintaining asset data for Clearwater’s clients. As content experts, FDAs advise internal and external constituents on the proper handling of critical data topics such as security master, reference data, asset classes, corporate actions, cash flows, analytics, pricing, amortization, performance, derivatives, and alternative assets etc.

Responsibilities

• Responds promptly and accurately to both internal and external inquiries.
• Plans, designs, develops, and assesses data elements to ensure quality.
• Utilizes a combination of manual and automated processes to validate data accuracy.
• Evaluates data vendors for accuracy, timeliness, and completeness of data.
• Serves as a content expert in their specialized area of data management.
• Collaborates with clients and prospects to brainstorm and implement innovative data solutions.
• Maintains and updates securities data in real-time, ensuring accuracy.
• Establishes a repository for process documentation, covering workflows not included in standard operating procedures.
• Performs basic SQL tasks and acquires fundamental SQL skills.
• Validates investment data by comparing it against third-party market data sources.
• Nurtures relationships with data providers, clients, and service delivery managers.
• Contributes to the operational maintenance of reference data products.
• Develops a foundational understanding of fixed income and equity investments.
• Reviews and updates procedures to ensure they remain current and effective.
• Escalates spending queries in a timely manner to address potential issues.
• Acts as a reliable reference point for assigned tasks, clients, or processes.
• Ensures compliance with risk and control checks in data management.
• Analyzes information flow between accounting and custody systems.
• Develops a working knowledge of corporate bonds and new bond issuance procedures.

Required Skills

• Proficiency in advance Excel.
• SQL skills.
• Familiarity with technology and tools related to Reference Data.
• Ability to work independently and collaboratively.
• Willingness to learn new things and adapt to change.
• Strong computer skills, including proficiency in Microsoft Office.
• Excellent attention to detail and strong documentation skills.
• Outstanding verbal and written communication skills.
• Strong organizational and interpersonal skills.
• Exceptional problem-solving abilities.

Education and Experience

Bachelor’s or master's degree in Business-related field.

Company Overview

Thank you for your interest in a career with Clearwater! Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud-native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single-instance, multi-tenant architecture delivers real-time data and AI-driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance, and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally. Learn more at www.clearwateranalytics.com.

Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with the job description, we encourage you to still apply! You may be just what we're looking for.