Data Flow Engineer

Job Summary

Data Flow Responsibilities

• Import and validate file deliveries for new clients.
• Automate daily process monitoring and reporting.
• Establish external API and FTP connections.
• Ensure dependable consumption of external portfolio data.
• Normalize external datasets into the standardized Clearwater format.
• Mine existing feeds to improve auto-reconciliation.

Issue Resolution and Communication

• Execute improvements requested by Operations and Development groups.
• Normalize new feeds and resolve issues using procedures and decision-making best practices.
• Explain general workflows, tools, and the Clearwater value proposition.
• Communicate technical system details and best practices to non-technical stakeholders.
• Participate in light on-call duties.

Required Skills

• Knowledge or experience in securities, accounting, and financial domains.
• Strong SQL and relational database knowledge.
• Experience with Groovy, Perl, or Python scripting languages.
• Strong computer skills, including Microsoft Office proficiency.
• Excellent attention to detail, documentation, communication, organization, and problem-solving skills.

Education and Experience

• Bachelor's degree in Mathematics, Computer Information Systems, or another relevant field.
• At least 1 year of relevant experience.
• Experience with industry-standard data transmission protocols is preferred, although the source also lists it without a preference qualifier.