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. * Analysis 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:
* 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 preferred like Groovy, Perl or Python. * Experience with industry-standard data transmission protocols preferred.