Lead Data Migration Specialist

Clearwater Analytics; Chicago (IL); On-site; USD 62,000 - 85,000; Full time

Job summary

Clearwater Analytics is seeking a Lead Data Migration Specialist in Chicago, IL. In this role, you will enhance system automation, speed, and accuracy while resolving data issues. Responsibilities include data loading and validation, identifying improvement opportunities, and collaborating with development teams. Ideal candidates hold a Bachelor's or Master's in finance or related fields, have 2+ years of experience, and possess strong Excel and accounting knowledge. Salary ranges from $62,000 to $85,000, depending on experience.

Qualifications

• 2+ years of relevant experience in data migration or similar fields.
• Experience with SQL or other relational databases.

Responsibilities

• Resolve various issues applying acquired skills and procedures.
• Load and validate client data into the Clearwater system.
• Implement and onboard clients using Clearwater methodologies.
• Identify opportunities for improvement and lead solutions.
• Understand accounting concepts such as amortization and interest income.

Skills

Accounting knowledge

Advanced Excel proficiency

Knowledge of securities/financial markets

Project Management Skills

Strong computer skills

Attention to detail

Documentation skills

Communication skills

Organizational skills

Problem-solving abilities

Education

Bachelor’s or Master’s in finance, math, accounting, or economics

Tools

SQL

Job description

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: $62,000 - $85,000 (DOE)