Financial Data Analyst

Clearwater Analytics; City of Edinburgh; Hybrid; GBP 42,000 - 64,000; Full time

Job summary

Clearwater Analytics in Edinburgh is seeking a Financial Data Analyst to monitor and maintain asset data for clients, acting as a content expert on security master, reference data, and valuation processes. The role emphasizes data quality, collaboration with clients, and building documentation; you will perform SQL tasks, validate against market data, and support data governance.

Applicants should have strong Excel and SQL skills, attention to detail, and the ability to work independently in a

Qualifications

• Bachelor’s or Master’s degree in a business-related field.
• Proficiency in advanced Excel and SQL.
• Familiarity with reference data tools and data management concepts.
• Strong attention to detail and excellent documentation and communication skills.

Responsibilities

• Monitor and maintain asset data for Clearwater’s clients.
• Plan, design, develop, and assess data elements to ensure quality.
• Validate data accuracy using manual and automated processes.
• Collaborate with clients to implement data solutions and improvements.
• Maintain securities data in real-time and update process documentation.
• Perform basic SQL tasks and grow SQL skills over time.
• Ensure data management compliance with risk controls.

Skills

Advanced Excel

SQL

Reference Data tools

Attention to detail

Documentation

Communication

Independent work

Team collaboration

Education

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

Tools

Microsoft Office

Reference Data systems

Job description

## Financial Data AnalystApply: Office - Edinburgh: Full time: Posted Today: R12237**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.