Sr. Data Flow Engineer

• 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 a variety of issues, such as normalizing new feeds and improving automation.

• Understand and can reference or explain the general workflow, tools, and Clearwater value proposition.

• Use critical thinking in addressing issues and offering 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.

• Take part in projects, including normalization logic rebuilds, external portfolio data acquisitions, and internal tooling migrations.

• Assist in training and mentoring new hires.

• Work with the overall division to build and document best practices.

• Design and build scripts to automate repeat tasks or error resolution.

• Effectively manage, coordinate, and communicate project work involving multiple team members.

• Engage in very light on-call duties.

Required Skills:

• Securities, accounting, and financial experience.

• Strong understanding of SQL and relational database principals.

• 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 degree

• 7+ years of relevant experience.

• Experience with industry-standard data transmission protocols.

• Experience with a scripting programming language like Groovy, Perl or Python.

• Experience with industry-standard data transmission protocols preferred.