Data Flow Engineer

As a Data Flow Engineer, you will play a crucial role in creating and managing data connections, performing validations, and executing transformations. Your primary focus will be on enhancing auto-reconciliation within the system through advanced technology, contributing to iterative improvement processes. Your responsibilities will include importing and validating file deliveries for new clients, automating daily process monitoring and reporting, establishing connections through external APIs and FTPs, ensuring timely consumption of external portfolio data, and normalizing external datasets into a standardized Clearwater format. You will also be responsible for mining data from existing feeds to identify solutions for improving auto-reconciliation, executing improvements requested from Operations and Development groups, and applying acquired skills and decision-making best practices to address various issues. To excel in this role, you must have a strong background in securities, accounting, and financial domains, along with a deep understanding of SQL and relational database principles. Experience with scripting programming languages such as Groovy, Perl, or Python is essential, as well as familiarity with industry-standard data transmission protocols. Additionally, proficiency in Microsoft Office, excellent attention to detail, strong documentation skills, outstanding communication abilities, and exceptional problem-solving skills are required. Ideally, you should hold a Bachelor's degree in Math, Computer Information Systems, or a related field, along with at least 2 years of relevant experience. Experience with industry-standard data transmission protocols is also preferred for this role. Your role may involve engaging in light on-call duties and effectively communicating technical aspects of Clearwater systems and best practices to both technical and non-technical stakeholders. In summary, as a Data Flow Engineer, you will be at the forefront of data management and transformation, contributing to the seamless operation and continuous improvement of auto-reconciliation processes within the system. Your expertise in data connections, validations, and transformations will be instrumental in driving efficiency and accuracy within the organization.,