Data Flow Engineer I

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.

- Automate daily process monitoring and reporting.

- Establish connections through external APIs and FTPs.

- Ensure timely and dependable consumption of external portfolio data.

- Normalize external datasets into a standardized Clearwater format facilitating the in-take process.

- Mine data from existing feeds to identify, design, and implement solutions to improve auto-reconciliation.

- Execute improvements requested from Operations and Development groups.

- 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 workflow, tools, and Clearwater value proposition.

- 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 light 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.

- 1+ years of relevant experience.

- Experience with industry-standard data transmission protocols.