Load and validate client data into the Clearwater investment account system
Coordinate complex onboarding activities in a dynamic, agile environment
Identify and lead improvements to onboarding processes
Resolve data issues and discrepancies using Excel, SQL, VBA and Python
Apply data intake, normalization, and reconciliation workflows
From the employer’s posting
Loads and validates client data into the Clearwater investment account system as the primary responsibility.
Coordinates complex activities effectively within a dynamic and agile environment.
Identifies opportunities for improvement and takes the lead in implementing solutions, both individually and within their role, for continuous service improvement.
They employ tools such as Excel, SQL, VBA, and Python to collect and analyze data, resolving issues and discrepancies.
Utilizes their understanding of data intake, normalization, reconciliation, and reporting workflow, along with related concepts.
Before you apply
Employer’s visa record
26 H-1B petitions approved in fiscal 2024 and 2025For the employer as a whole. This posting doesn’t say whether the role is sponsored. US Citizenship and Immigration Services.
Open 3 monthsWe first saw this posting 119 days ago and it is still up. Roles open this long are often slow to fill or kept open to collect applications.
Status in our records
Live
First seen by us
Jul 25, 2026119 days ago
Recorded sightings
207
Last seen by us
Nov 15, 2026
Reposted
once since May 7, 2026
Jul 25, 2026today
These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications. We count a repost when the same title and location comes back as a new listing within 60 days of the last one coming down. Some hiring systems expire listings on a schedule, so repost rates vary by system.
How this job compares
Time since we first saw it
Day 119
750
Up longer than most. Similar jobs usually come down between day 7 and day 50.
Well past Clearwater Analytics’s usual: its jobs come down by about day 46.
From 677 similar postings that came down, and 41 of Clearwater Analytics’s. Coming down is not always a hire.
Clearwater Analytics is hiring
19 open jobs
Open jobs by the week we first saw them, last 12 weeks.
Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.
Python
SQL
VBA
Excel
Where the posting names them
Job Summary:
The Financial 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.
Responsibilities:
- 2+ years of relevant experience.
- Experience with SQL or other relational databases
Chicago Salary Range: $62,000 - $85,000 depending on experience.
- 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.
Complete your application on clearwateranalytics.wd1.myworkdayjobs.com. The employer’s form will show what is required.
Applying through Workday
You create an account with each employer before you can upload anything. Every Workday employer has its own account, so one sign-up doesn’t carry over.
“Autofill with Resume” comes right after sign-in, before the My Information and My Experience steps. Check every field it fills in those steps, since that’s what recruiters see.
Your application status lives in that employer’s Candidate Home, under the same sign-in.
The Financial 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.
Responsibilities:
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.
Required skills:
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.
Education and Experience:
Bachelor’s & Master’s in finance or math, accounting, economics.
2+ years of relevant experience.
Experience with SQL or other relational databases
Chicago Salary Range: $62,000 - $85,000 depending on experience.
Demand for Data Operations roles
New Data Operations postings at the employers we follow are up 164% over the last 6 weeks compared with the 6 before.
August 17Last week
Each bar is one week of new postings. The darkest bars are the last 6 weeks.
Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.
About the role
We file this job under Data Operations, by the work the posting describes.
Data operations staff do the day-to-day work of getting data processed correctly: loading and checking files, moving records between systems, fixing errors and following set procedures.
Expect Excel, some SQL, close attention to detail, and knowledge of the particular systems the company runs.
Data governance sets the rules for the data; data operations does the hands-on work of processing it and keeping it moving.