Data Migration & Automation Lead for Client Onboarding

Clearwater Analytics

Chicago (IL)

On-site

USD 80,000 - 110,000

Full time

14 days+

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Clearwater Analytics in Chicago seeks a Data Migration Specialist to enhance automation, speed, and accuracy by collecting and analyzing data with Excel and SQL. You will load and validate client data into Clearwater's investment account system and collaborate with development teams to implement onboarding improvements, enabling rapid client growth.

The role requires strong accounting knowledge, advanced Excel/SQL, and experience in financial markets.

Qualifications

  • Bachelor’s or Master’s in finance, math, accounting, or economics.
  • 7+ years of relevant experience.
  • Strong Excel and SQL skills for data handling.
  • Knowledge of derivatives, fixed income, and financial markets.
  • Excellent attention to detail and documentation.

Responsibilities

  • Resolve issues using established procedures and best practices.
  • Load and validate client data into Clearwater's investment account system.
  • Apply Clearwater Way methodologies to onboard clients and support Client Engagement Model.
  • Identify improvement opportunities and lead solutions for service enhancement.
  • Apply understanding of accounting concepts including amortization and interest income.
  • Apply knowledge of data intake, normalization, reconciliation, and reporting workflows.
  • Understand vanilla fixed income and equity investments and their roles in CW.
  • Apply Clearwater's core value proposition: aggregate, reconcile, report.
  • Coordinate complex activities in a dynamic, Agile environment.

Skills

Advanced Excel
SQL Databases
Financial markets
Project management
MS Office
Attention to detail
Communication skills
Organizational skills
Problem solving
Math expertise

Education

Finance/Math/Accounting/Economics degree

Tools

None

Job description

Clearwater Analytics in Chicago seeks a Data Migration Specialist to enhance automation, speed, and accuracy by collecting and analyzing data with Excel and SQL. You will load and validate client data into Clearwater's investment account system and collaborate with development teams to implement onboarding improvements, enabling rapid client growth.

The role requires strong accounting knowledge, advanced Excel/SQL, and experience in financial markets.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Financial Data Migration & Automation Specialist
Financial Data Migration & Automation Specialist

Clearwater Analytics • Boise (ID)

On-site
USD 62,000 - 85,000
Data Migration Specialist
Data Migration Specialist

Clearwater Analytics • Boise (ID)

On-site
USD 62,000 - 85,000
Sr. Data Migration Specialist
Sr. Data Migration Specialist

Clearwater Analytics • Chicago (IL)

On-site
USD 80,000 - 110,000
Client Onboarding & Solutions Specialist
Client Onboarding & Solutions Specialist

Clearwater Analytics, LLC • Boise (ID)

On-site
USD 65,000 - 90,000
Client Onboarding Lead - Finance & Risk SME
Client Onboarding Lead - Finance & Risk SME

Clearwater Analytics, LLC • New York (NY)

On-site
USD 120,000 - 168,000
Health insurance
401(k)
PTO
+3
Client Experience & Investment Accounting Analyst
Client Experience & Investment Accounting Analyst

Clearwater Analytics • Chicago (IL)

On-site
USD 54,000 - 70,000
Health benefits
401(k)
PTO
+3
Investment Analytics & Client Services Specialist
Investment Analytics & Client Services Specialist

Clearwater Analytics (CWAN) • Chicago (IL)

On-site
USD 60,000 - 85,000
Health insurance
Vision/dental insurance
401(k)
+4
Senior Client Onboarding & Finance SME
Senior Client Onboarding & Finance SME

Clearwater Analytics • New York (NY)

On-site
USD 120,000 - 168,000
Health/vision/dental insurance
401(k)
PTO
+3
Remote Data Migration Lead — AI & SQL Expert
Remote Data Migration Lead — AI & SQL Expert

Calliere • United States

Remote
USD 120,000 - 150,000
Senior Onboarding SME - Solvency II & Derivatives Expert
Senior Onboarding SME - Solvency II & Derivatives Expert

Clearwater Analytics, LLC • Boise (ID)

On-site
USD 110,000 - 135,000