Data Flow Engineer: Data Integration & Reconciliation

Clearwater Analytics, LLC; Boise (ID); On-site; USD 80,000 - 120,000; Full time

Benefits offered by this job

Healthcare benefits

401(k) plan

Job summary

Clearwater Analytics, LLC is seeking a Data Flow Engineer to create and manage data connections, perform validations, and execute transformations. You will focus on enhancing auto-reconciliation through advanced technology within the Clearwater platform.

Responsibilities include data import/validation for new clients, automating monitoring/reporting, establishing API/FTP connections, and normalizing data into Clearwater formats for intake.

Qualifications

• Securities, accounting, and financial experience required or preferred.
• Experience with SQL and relational databases.
• Experience with scripting languages such as Groovy, Perl or Python.
• Proficiency with industry-standard data transmission protocols.
• Securities, accounting, and financial experience preferred.

Responsibilities

• Import and validate file delivery for new clients.
• Automate daily process monitoring and reporting.
• Establish connections via external APIs and FTPs.
• Ensure timely consumption of external portfolio data.
• Normalize external datasets into Clearwater format for intake.
• Mine data from feeds to improve auto-reconciliation.
• Implement improvements requested by Operations and Development.
• Apply procedures and decision-making to normalize feeds and improve automation.
• Understand workflows and Clearwater value proposition.
• Communicate technical aspects to non-technical stakeholders.
• Participate in light on-call duties.

Skills

Securities, accounting, and financial

SQL and relational databases

Groovy / Perl / Python scripting

Data transmission protocols

Microsoft Office

Education

Bachelor's degree in Math, CIS, or related

1+ years of relevant experience

Tools

Groovy

Perl

Python

Job description

Clearwater Analytics, LLC is seeking a Data Flow Engineer to create and manage data connections, perform validations, and execute transformations. You will focus on enhancing auto-reconciliation through advanced technology within the Clearwater platform.

Responsibilities include data import/validation for new clients, automating monitoring/reporting, establishing API/FTP connections, and normalizing data into Clearwater formats for intake.