Financial Data Analyst

clearwateranalytics; City of Edinburgh; On-site; GBP 35,000 - 55,000; Full time

Job summary

Clearwater Analytics seeks a Financial Data Analyst to monitor and maintain asset data for clients. The role requires handling security master data, reference data, and various asset classes, with emphasis on accuracy and documentation.

You will work with teams to validate data, engage with data vendors, and support data solutions for clients. A strong foundation in Excel and SQL is essential, along with attention to detail and communication skills.

Qualifications

• Proficiency in advanced Excel.
• SQL skills.
• Familiarity with technology and tools related to Reference Data.
• Ability to work independently and collaboratively.
• Excellent attention to detail and strong documentation skills.

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.

Skills

Advanced Excel

SQL

Reference Data tools

Independent work

Collaboration

Education

Bachelor’s or Master’s in Business

Tools

Reference Data tools

Job description

Job Summary :

The Financial Data Analyst is responsible for monito ring and maintain ing asset da ta for Clearwater's clients . As content experts, FDAs advise internal and external constituents on the proper handling of critical data topics such as security maste r, 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.