Data Migration Specialist

Clearwater Analytics

Boise (ID)

On-site

USD 62,000 - 85,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Job summary

Clearwater Analytics is seeking a Financial Data Migration Specialist to enhance automation, speed, and accuracy of client data onboarding. You will use Excel, SQL, VBA, and Python to collect, analyze, and validate data, resolving discrepancies and streamlining workflows with CW’s Client Engagement Model.

You will collaborate with development teams to devise scalable, replicable processes that cut delivery times and adaptable solutions for a growing client base.

Qualifications

  • Strong accounting foundation required.
  • Advanced Excel proficiency required.
  • Knowledge of securities/financial markets, derivatives, alternatives, structured products, and/or fixed income.
  • Experience with SQL or relational databases.
  • 2+ years of relevant experience.

Responsibilities

  • Loads and validates client data into the Clearwater investment account system.
  • Collaborates with CW development teams to onboard clients and align with Client Engagement Model.
  • Identifies opportunities for improvement and leads implementation of solutions for service improvement.
  • Applies accounting concepts (e.g., equations, amortization, interest income) in data migration tasks.
  • Understands data intake, normalization, reconciliation, and reporting workflows.
  • Leverages knowledge of vanilla fixed income and equity investments within Clearwater.
  • Applies Clearwater's core value proposition: aggregate, reconcile, report.

Skills

Accounting knowledge
Excel proficiency
Financial markets knowledge
Project management
Microsoft Office
Attention to detail
Communication skills
Organizational skills
Problem solving
Math skills

Education

Bachelor's & Master's in finance or math, accounting, economics

Tools

SQL

Job description

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.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. Data Migration Specialist
Sr. Data Migration Specialist

Clearwater Analytics • Chicago (IL)

On-site
USD 80,000 - 110,000
Data Migration & Automation Lead for Client Onboarding
Data Migration & Automation Lead for Client Onboarding

Clearwater Analytics • Chicago (IL)

On-site
USD 80,000 - 110,000
Financial Data Migration & Automation Specialist
Financial Data Migration & Automation Specialist

Clearwater Analytics • Boise (ID)

On-site
USD 62,000 - 85,000
Financial Data Associate
Financial Data Associate

Clearwater Analytics, LLC • Boise (ID)

On-site
USD 65,000 - 95,000
Client Service Associate
Client Service Associate

Clearwater Analytics • Chicago (IL)

On-site
USD 54,000 - 70,000
Health benefits
401(k)
PTO
+3
Subject Matter Expert - Implementations
Subject Matter Expert - Implementations

Clearwater Analytics India • Boise (ID)

On-site
USD 90,000 - 130,000
Sr. Subject Matter Expert - Implementations
Sr. Subject Matter Expert - Implementations

Clearwater Analytics, LLC • Boise (ID)

On-site
USD 110,000 - 135,000
Client Service Analyst Intern
Client Service Analyst Intern

Clearwater Analytics, LLC • Boise (ID)

On-site
USD 25,000 - 33,000
Client Service Analyst Intern
Client Service Analyst Intern

Clearwater Analytics • Boise (ID)

Hybrid
USD 18,000 - 28,000
Subject Matter Expert - Implementations
Subject Matter Expert - Implementations

Clearwater Analytics • Chicago (IL)

On-site
USD 120,000 - 180,000