Data Flow Engineer II

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 .  

• 2+ years of relevant experience.  

• Experience with industry-standard data transmission protocols.