> Markdown version of [/jobs/ext/1311709-lead-reconciliation-implementation-associate](https://www.wearedevelopers.com/jobs/ext/1311709-lead-reconciliation-implementation-associate). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead Reconciliation Implementation Associate - **Company:** Clearwater Analytics - **Location:** Chicago, IL, United States - **Experience:** Expert - **Salary:** $62,000.0 - $85,000.0 - **Contract:** Permanent contract - **Skills:** Microsoft Excel, Lookup Table, Microsoft Office, Pivot Tables, Software Tools - **Published:** July 17, 2026 - **Apply:** https://www.indeed.com/viewjob?jk=e4b947a4062a8122 ## About the Role * An intense desire to learn something new and improve daily. * Basic knowledge of Excel such as VLOOKUP, SUMIF, 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. ## Description The Lead Reconciliation Implementation Analyst is responsible for establishing reconciliation processes and thresholds for clients. They collaborate with stakeholders to gather requirements, design automated workflows, and ensure data accuracy through analysis and validation with third-party data. This analyst monitors and addresses discrepancies in the reconciliation process involving safekeeping institutions, third-party data, and order management systems. The role requires strong analytical and technical skills, along with effective communication and collaboration abilities to ensure accurate reconciliation of investment data., * 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. * Primary responsibility involves back reconciling, normalizing, and automating data. * 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. ## Related Videos - [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation) - [ Secure Code Superstars: Empowering Developers and Surpassing Security Challenges Together](https://www.wearedevelopers.com/videos/422-secure-code-superstars-empowering-developers-and-surpassing-security-challenges-together) - [Is it still C#? Practical systems programming with .NET (war stories included)](https://www.wearedevelopers.com/videos/100138-is-it-still-c-practical-systems-programming-with-net-war-stories-included) - [Beyond Dashboards: Fixing Text-to-SQL with Semantic RAG](https://www.wearedevelopers.com/videos/2036-beyond-dashboards-fixing-text-to-sql-with-semantic-rag) - [Graphs and RAGs Everywhere... But What Are They? - Andreas Kollegger - Neo4j](https://www.wearedevelopers.com/videos/1311-graphs-and-rags-everywhere-but-what-are-they-andreas-kollegger-neo4j) - [What is relational learning and why does it matter?](https://www.wearedevelopers.com/videos/396-what-is-relational-learning-and-why-does-it-matter) ## Related Articles - [Data Analyst Salary in the UK](https://www.wearedevelopers.com/magazine/278-data-analyst-salary-in-the-uk) - [Data Analyst Salary in Switzerland](https://www.wearedevelopers.com/magazine/276-data-analyst-salary-in-switzerland) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk) - [Software Engineer Salary London](https://www.wearedevelopers.com/magazine/252-software-engineer-salary-london) - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer)