Clearwater Analytics (CWAN) Logo

Clearwater Analytics (CWAN)

Lead Data Migration Specialist

Reposted Yesterday
Be an Early Applicant
Hybrid
Chicago, IL, USA
60K-85K Annually
Junior
Hybrid
Chicago, IL, USA
60K-85K Annually
Junior
The Lead Data Migration Specialist will enhance data processes for client onboarding using Excel, SQL, and AI, ensuring accuracy and efficiency.
The summary above was generated by AI

The Lead Data Migration Specialist plays a crucial role in enhancing our system's automation, speed, accuracy, and workflow. They employ tools such as Excel, SQL, and AI 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 mortgages and private equity. 

  • Understands and applies Clearwater's core value proposition (aggregate, reconcile, report) in a market- and client-agnostic manner. 

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, organizing and managing priorities). 

  • 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 

Salary Range: $60,000 - $85,000
 

This is the pay range the Company believes it will pay for this position at the time of this posting. Consistent with applicable law, compensation will be determined based on relevant experience, other job-related qualifications/skills, and geographic location (to account for comparative cost of living). The Company reserves the right to modify this pay range at any time. For this role, benefits include: health/vision/dental insurance, 401(k), PTO, parental leave, and medical leave, STD/LTD insurance benefits. Clearwater Analytics is An Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or veteran status, age or any other federally protected class.

Clearwater Analytics (CWAN) Chicago, Illinois, USA Office

Located in the heart of the Loop in Downtown Chicago. The office is easy to get to with various train and bus stops nearby.

Similar Jobs at Clearwater Analytics (CWAN)

Junior
Fintech • Software • Financial Services
The Lead Data Migration Specialist enhances system automation and accuracy, handling data collection, analysis, and onboarding. They resolve discrepancies, implement optimizations, and collaborate with development teams, ensuring efficient data management and continuous service improvement.
Top Skills: ExcelPythonSQLVBA
17 Hours Ago
Hybrid
Chicago, IL, USA
74K-96K Annually
Senior level
74K-96K Annually
Senior level
Fintech • Software • Financial Services
The Service Delivery Manager oversees service fulfillment, manages client engagement and reporting, ensures operational performance, and develops client relationships.
Top Skills: MS Office
17 Hours Ago
Hybrid
Senior level
Senior level
Fintech • Software • Financial Services
The Program Manager oversees project scope, timelines, and budget management while coordinating resources, conducting meetings, and ensuring client satisfaction during implementations.
Top Skills: ClarizenExcelJIRAMS OfficeSalesforce

What you need to know about the Chicago Tech Scene

With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.

Key Facts About Chicago Tech

  • Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
  • Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
  • Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
  • Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account