Data Flow Engineer III

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. 

NOTE : Legal authorization to work in the United States and will not require visa sponsorship in the future.

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. 

• 4+ years of relevant experience. 

• Experience with industry-standard data transmission protocols. 

What we offer:

• Business casual atmosphere in a flexible working environment 

• Team focused culture that promotes innovation and ownership 

• Access cutting edge investment reporting technology and expertise

• Defined and undefined career pathways allowing you to grow your own way 

• Competitive medical, dental, vision, and life insurance benefits

• Maternity and paternity leave 

• Personal Time Off and Volunteer Time Off to give back to the community

• RSUs as well as employee stock purchase plan and 401k with match  

• Work from anywhere 3 weeks out of the year 

• Work from home Fridays