Financial Data Analyst

Clearwater Analytics (CWAN); Boise (ID); On-site; USD 65,000 - 90,000; Full time

Job summary

Clearwater Analytics in Boise, Idaho, is seeking a Financial Data Analyst to monitor and maintain asset data for our clients. You will act as a content expert on security master, reference data, asset classes, corporate actions, cash flows, pricing, and analytics, collaborating with clients and internal teams to implement data solutions.

The role requires strong Excel and SQL skills, the ability to work independently and with others, meticulous documentation, and excellent communication.

Qualifications

• Proficiency in advanced Excel
• SQL skills
• Familiarity with reference data
• Ability to work independently and collaboratively
• Strong communication and documentation skills
• Excellent attention to detail

Responsibilities

• Responds promptly and accurately to inquiries from internal and external stakeholders
• Plans, designs, and assesses data elements to ensure quality
• Validates data accuracy using manual and automated processes
• Evaluates data vendors for accuracy, timeliness, and completeness
• Collaborates with clients to brainstorm and implement data solutions
• Maintains securities data in real-time and documents workflows
• Performs basic SQL tasks and develops SQL skills
• Ensures compliance with risk and control checks in data management

Job description

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.