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 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.
Education and Experience:
* Bachelor's degree in Math, Computer Information Systems, Data, or other relevant degrees.
Required Skills:
* Good understanding of SQL and relational database principles.
* Experience with scripting programming languages like Groovy, Perl or Python, good to have.
* Experience with industry-standard data transmission protocols 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.