Data Migration Specialist

16 Minutes ago • 1 Years +

Job Summary

Job Description

The Data Migration Specialist plays a crucial role in enhancing system automation, speed, accuracy, and workflow. This involves using tools like Excel and SQL to collect, analyze data, and resolve issues, significantly improving the efficiency of onboarding client data. Collaborating with development teams, specialists devise strategies to simplify processes and reduce delivery times. The role emphasizes establishing replicable and adaptable processes to accommodate a growing client base. Key responsibilities include applying acquired skills and best practices to resolve issues, loading and validating client data into the Clearwater investment account system, and demonstrating a working knowledge of Clearwater Way methodologies for client onboarding. Specialists will identify and lead improvements for continuous service enhancement, apply understanding of accounting concepts like the accounting equation and amortization, and utilize knowledge of data intake, normalization, reconciliation, and reporting workflows. They will also comprehend the purpose and functionality of vanilla fixed income and equity investments within Clearwater and apply Clearwater's core value proposition (aggregate, reconcile, report) in a market- and client-agnostic manner, while coordinating complex activities in a dynamic environment.
Must have:
  • Strong foundation in accounting knowledge
  • Advanced Excel proficiency
  • Experience with SQL or relational databases
  • Knowledge of securities or financial markets
  • Proficiency in Microsoft Office
  • Excellent attention to detail and documentation skills
  • Outstanding verbal and written communication
  • Strong organizational and interpersonal skills
  • Exceptional problem-solving abilities
Good to have:
  • Bachelor's or Master's in finance, math, accounting, or economics

Job Details

Job Summary:  

The Data Migration Specialists play a crucial role in enhancing our system's automation, speed, accuracy, and workflow. They employ tools such as Excel and SQL 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 strong foundation in accounting knowledge. 

  • Advanced Excel proficiency.  

  • Experience with SQL or other relational databases. 

  • Securities or financial markets knowledge, especially involving derivatives, alternatives, structured products, and/or fixed income. 

  • 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 and/or Master’s in finance or math, accounting, economics. 

  • 1+ years of relevant experience. 

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Boise, Idaho, United States

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Category Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Clearwater Analytics (NYSE: CWAN) is the leading provider of web-based investment portfolio accounting, reporting, and reconciliation services for institutional investors at thousands of organizations.


Clearwater aggregates, reconciles, and reports on more than $6.4 trillion in assets across thousands of accounts daily. Our clients include corporate treasuries, insurance companies, investment managers, banks, governments, and other institutional investors both in the United States and worldwide.


For more than a decade, we have leveraged web-based software and world-class client service to help clients such as American Family Insurance, Arch Capital, C.V. Starr & Co., Cisco, Facebook, Oracle, Selective Insurance, Sirius Group, Sompo International, Starbucks, WellCare Health Plans, Wilton Re, and many others, streamline their investment and accounting operations. Clearwater also works with hundreds of custodians, investment managers, dealers/brokers, and electronic trading portals who offer Clearwater to their many clients.


With global headquarters in Boise, Idaho, and offices in Edinburgh, Frankfurt, London, New Delhi, New York, Paris, Seattle, Singapore, and Washington D.C., Clearwater sets the new global standard for investment portfolio reporting.

San Jose, California, United States (On-Site)

Boise, Idaho, United States (On-Site)

Boise, Idaho, United States (On-Site)

Chicago, Illinois, United States (On-Site)

Boise, Idaho, United States (On-Site)

San Jose, California, United States (On-Site)

Chicago, Illinois, United States (On-Site)

Boise, Idaho, United States (On-Site)

New York, United States (On-Site)

New York, United States (On-Site)

View All Jobs

Get notified when new jobs are added by Clearwater Analytics

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug