Clearwater Analytics (CWAN) Logo

Clearwater Analytics (CWAN)

Lead Data Migration Specialist

Reposted 4 Days Ago
Hybrid
Boise, ID
60K-85K Annually
Junior
Hybrid
Boise, ID
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) New York, New York, USA Office

1 Rockefeller Plaza Floor 27, New York, NY, United States, 10020

Similar Jobs at Clearwater Analytics (CWAN)

Junior
Fintech • Software • Financial Services
Load, validate, normalize, reconcile, and report client investment data using Excel, SQL, VBA, and Python. Work with development teams to automate and improve onboarding, apply accounting and securities knowledge, lead improvements, and coordinate complex activities within an agile environment.
Top Skills: Clearwater Investment Account SystemExcelMS OfficePythonRelational DatabasesSQLVBA
Mid level
Fintech • Software • Financial Services
Lead data migration and onboarding of client investment data using Excel and SQL. Validate, normalize, reconcile, and load data into the investment account system. Collaborate with development teams to automate and improve processes, apply accounting and securities knowledge, identify continuous improvement opportunities, and coordinate complex activities in an agile environment.
Top Skills: ExcelMS OfficeRelational DatabasesSQL
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

What you need to know about the NYC Tech Scene

As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.

Key Facts About NYC Tech

  • Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
  • Key Industries: Artificial intelligence, Fintech
  • Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
  • Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account