Back to jobs

Data Migration Specialist

Pay
$62,000–85,000/yearAnnual period assumed — pay source
Experience with SQL or other relational databases Chicago Salary Range: $62,000 - $85,000 depending on experience.
Read the full posting
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full time
From the employer’s posting

What you’ll work on

Full posting
  • 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.

What you’ll bring

All qualifications

Core experience

  • Bachelor’s & Master’s in finance or math, accounting, economics.
  • 2+ years of relevant experience.
  • Experience with SQL or other relational databases
Qualification wording
Bachelor’s & Master’s in finance or math, accounting, economics.
2+ years of relevant experience.
Experience with SQL or other relational databases
Education & alternatives
Education and Experience: - Bachelor’s & Master’s in finance or math, accounting, economics. - 2+ years of relevant experience.
Apply at Clearwater Analytics

Posting record

Report an error

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

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

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.

  • Data Operations hiring is picking up
  • Takes jobs down at a usual pace
  • 16% of open jobs were reposted
Hiring record

See how this role fits your experience

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.

Your next step

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.

Already applied? Track this application

Has Clearwater Analytics posted this job before?

Yes. We’ve followed 2 other Data Migration Specialist jobs there since May 2026. One came down after 70 days. One is still up.

  1. BoiseCame down after 70 days, first seen May 7
  2. This jobUp 119 days so far, first seen Jul 25
  3. BoiseStill up after 65 days, first seen Sep 18

Job description

View original posting ↗

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: 

  • 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.

Weekly new Data Operations postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 23, the most 193, and the latest week had 82.
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.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay
Experience with SQL or other relational databases Chicago Salary Range: $62,000 - $85,000 depending on experience.
Location & working pattern

Office - Boise

Working pattern and location restrictions need checking in the full posting.

Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.