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 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.
- Solid understanding of SQL and relational