Data Flow Engineer: Automation & Reconciliation

Clearwater Analytics; Boise, Northern (ID, KY); Hybrid; USD 70,000 - 100,000; Full time

Job summary

Clearwater Analytics is seeking a Data Flow Engineer to design and manage data connections, validations, and transformations for client onboarding and ongoing reconciliation workflows.

You will automate monitoring, establish API/FTP connections, and normalize external datasets into Clearwater's standard format, enabling efficient intake and improved auto-reconciliation across portfolios.

Qualifications

• Bachelor's degree in Math, Computer Information Systems, or related field.
• 1+ year of relevant experience.
• Experience with industry-standard data transmission protocols.

Responsibilities

• Import and validate file delivery for new clients.
• Automate daily process monitoring and reporting.
• Establish connections via external APIs and FTPs.
• Normalize external datasets into Clearwater format for intake.
• Identify and implement improvements for auto-reconciliation.
• Execute improvements from Operations and Development groups.
• Communicate Clearwater systems and best practices to stakeholders.

Skills

Finance experience

SQL & databases

Groovy/Perl/Python

Data protocols

MS Office

Attention to detail

Communication skills

Organizational skills

Problem solving

Education

Bachelor's degree in Math/CIS

Job description

Clearwater Analytics is seeking a Data Flow Engineer to design and manage data connections, validations, and transformations for client onboarding and ongoing reconciliation workflows.

You will automate monitoring, establish API/FTP connections, and normalize external datasets into Clearwater's standard format, enabling efficient intake and improved auto-reconciliation across portfolios.