Sr. Data Flow Engineer
Description
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 .
-
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+ year s of relevant experience .
-
Experience with industry-standard data transmission protocols .
-
Experience with a scripting programming language like Groovy, Perl or Python.
-
Experience with industry-standard data transmission protocols preferred.