Job Title. Data Flow Engineer
Job Summary
The Data Flow Engineer plays a pivotal role in creating and managing data connections, executing validations, and performing transformations. This position is crucial for continuous improvement, particularly focusing on enhancing auto-reconciliation within the system using 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 to streamline the intake process.
- Utilize data mining techniques to identify, design, and implement solutions for improving auto-reconciliation.
- Execute improvements requested by Operations and Development groups.
- Apply acquired skills and decision-making best practices to address various issues, including normalizing new feeds and enhancing automation.
- Understand and articulate the general workflow, tools, and value proposition of Clearwater.
- Employ critical thinking to resolve issues and propose solutions for both internal and external stakeholders while adhering to best practices.
- Communicate technical aspects and best practices of Clearwater systems effectively to non-technical 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.
- Preferred experience with industry-standard data transmission protocols.
- Proficiency in Microsoft Office suite.
- Excellent attention to detail and 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 relevant fields.
- Experience with industry-standard data transmission protocols is preferred.
Join our team at Clearwater and contribute to our mission of advancing data management and reconciliation processes in the financial industry.