Job Summary:

The Data Flow Engineer's primary role is to create and manage data connections, perform validations, and execute transformations. Their work is integral to the ongoing process of iterative improvement, with a particular focus on enhancing auto-reconciliation within the system through advanced technology.

Responsibilities:

Import and validate file delivery for new clients.

Establish inbound and outbound connections through external APIs and FTPs.

Ensure timely and dependable consumption of external portfolio data.

Normalize external datasets that can be consumed through the core pipeline.

Execute improvements requested by Global Delivery, Client Services, and Development.

Apply acquired skills, procedures, and decision-making best practices to complete various issues, such as normalizing new feeds and improving automation.

Understand and reference or explain the general dataflow, tools, and Clearwater value proposition for Core and Premium product pipelines.

Use critical thinking to address issues and offer solutions for both internal and external parties, ensuring best practices are employed.

Clearly and effectively communicate the technical aspects of Clearwater systems and our best practices with non-technical internal and external stakeholders.

Engage in occasional on-call duties.

Required Skills:

Securities, accounting, and financial experience.

Strong understanding of SQL and relational database principles.

Experience with scripting programming languages like Groovy, Perl or Python.

Experience with industry-standard data transmission protocols preferred.

Securities, accounting, and financial experience preferred.

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.

Education and Experience:

Bachelor's degree in Math, Computer Information Systems, or other relevant degrees.

2+ years of relevant experience.

Experience with industry-standard data transmission protocols.

This role is on-site at our Boise office.