> Markdown version of [/jobs/ext/1422274-lead-data-migration-specialist-3](https://www.wearedevelopers.com/jobs/ext/1422274-lead-data-migration-specialist-3). 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 Data Migration Specialist-3

- **Company:** Clearwater Analytics
- **Location:** Chicago, IL, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Microsoft Excel, Data Analysis, Data Migration, Relational Databases, Python (Programming Language), Microsoft Office, SQL Databases, Vba Programming Language
- **Published:** July 24, 2026
- **Apply:** https://www.indeed.com/viewjob?jk=d57d158d574de38b

## About the Role

* They must possess a solid foundation in accounting knowledge.
 * Advanced Excel proficiency.
 * Securities or financial markets knowledge, especially involving derivatives, alternatives, structured products, and/or fixed income.
 * Project Management Skills (ex. workstream lead).
 * 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 expertise., * Bachelor's & Master's in finance or math, accounting, economics.
 * 2+ years of relevant experience.
 * Experience with SQL or other relational databases

## Description

The Data Migration Specialists play a crucial role in enhancing our system's automation, speed, accuracy, and workflow. They employ tools such as Excel, SQL, VBA, and Python to collect and analyze data, resolving issues and discrepancies. This optimization greatly improves the efficiency of onboarding client data at Clearwater. Collaborating closely with our talented development teams, they devise creative strategies that not only simplify the process but also dramatically cut down delivery times. Our commitment lies in establishing processes that are not only replicable but also adaptable, enabling us to effortlessly accommodate our expanding client base., * Applies acquired skills, procedures, and decision-making best practices to resolve various issues.

 * Loads and validates client data into the Clearwater investment account system as the primary responsibility.
 * Demonstrates a working knowledge of Clearwater Way methodologies to implement and onboard clients, including aligning and supporting CW's Client Engagement Model.
 * Identifies opportunities for improvement and takes the lead in implementing solutions, both individually and within their role, for continuous service improvement.
 * Applies their understanding of the accounting equation, amortization, interest income, and other accounting concepts.
 * Utilizes their understanding of data intake, normalization, reconciliation, and reporting workflow, along with related concepts.
 * Applies their understanding of vanilla fixed income and equity investments, comprehending their purpose and functionality within CW.
 * Understands and applies Clearwater's core value proposition (aggregate, reconcile, report) in a market- and client-agnostic manner.
 * Coordinates complex activities effectively within a dynamic and agile environment.


## Related Videos

- [Data Science in Retail](https://www.wearedevelopers.com/videos/586-data-science-in-retail)
- [Swapping a Data Warehouse at Runtime: Zero-Downtime Migration Without Changing a Single Client](https://www.wearedevelopers.com/videos/100311-swapping-a-data-warehouse-at-runtime-zero-downtime-migration-without-changing-a-single-client)
- [Replacing Excel with SAP APIs & Python validation](https://www.wearedevelopers.com/videos/1944-replacing-excel-with-sap-apis-python-validation)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1146-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)
- [Data Science on Software Data](https://www.wearedevelopers.com/videos/162-data-science-on-software-data)
- [Fault Tolerance and Consistency at Scale: Harnessing the Power of Distributed SQL Databases](https://www.wearedevelopers.com/videos/1520-fault-tolerance-and-consistency-at-scale-harnessing-the-power-of-distributed-sql-databases)

## 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)
- [Data Analyst Salary Germany](https://www.wearedevelopers.com/magazine/277-data-analyst-salary-germany)
- [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)