Lead Reconciliation Implementation Associate

Clearwater Analytics, LLC; Boise (ID); On-site; USD 62,000 - 85,000; Full time

Job summary

Clearwater Analytics, LLC is seeking a Lead Reconciliation Implementation Analyst to establish reconciliation processes, thresholds, and automated workflows for client investment books during onboarding, ensuring data accuracy through validation with third‑party data.

You will collaborate with stakeholders, monitor discrepancies across safekeeping institutions and order management systems, and apply knowledge of fixed income and equity investments to improve operational models and risk awareness.

Qualifications

• Bachelor’s or Master’s degree in finance or accounting.
• 2+ years of relevant experience (preferred).
• Strong analytical and mathematical skills.
• Proficiency in Excel and data validation.

Responsibilities

• Complete reconciliation for client investment books during onboarding with focus on automation.
• Demonstrate familiarity with resources and select appropriate research tools.
• Back‑reconcile, normalize, and automate data processing.

Skills

Analytical skills

Excel (VLOOKUP, SUMIF, Pivot)

Attention to detail

Communication skills

Collaboration

Problem-solving

Basic accounting / financial tools

Education

Bachelor’s / Master’s degree in finance or accounting

Tools

Microsoft Office

Job description

The Lead Reconciliation Implementation Analyst is responsible for establishing reconciliation processes and thresholds for clients, collaborating with stakeholders to gather requirements, design automated workflows, and ensuring data accuracy through analysis and validation with third‑party data. The analyst monitors and addresses discrepancies in the reconciliation process involving safekeeping institutions, third‑party data, and order management systems, requiring strong analytical and technical skills, effective communication, and collaboration to ensure accurate reconciliation of investment data.

Responsibilities

• Completing reconciliation for client investment books during onboarding, focusing on automation and scalable operating models.
• Demonstrating familiarity with available resources and accurately selecting appropriate research tools.
• Back reconciling, normalizing, and automating data as a primary responsibility.
• Proactively learning from mistakes and taking steps to avoid repeating them.
• Applying knowledge of investment accounting, financial statements, amortization, interest income, yields, and other financial and accounting concepts.
• Actively communicating project progress and risks with Stream Leads and PMs.
• Applying understanding of vanilla fixed income and equity investments, including their purpose and operation in CW, and developing knowledge of security types commonly held by assigned clients.

Required Skills

• An intense desire to learn something new and improve daily.
• Basic knowledge of Excel such as VLOOKUP, SUMIF, and Pivot Tables.
• Basic knowledge of accounting basis and/or financial instruments preferred.
• 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 and math skills.

Education and Experience

Bachelor’s / Master’s degree. Preference in finance or accounting. 2+ years of relevant experience.

Salary

Chicago Salary Range: $62,000 - $85,000 DOE

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.