Data Flow Engineer III

Overview

The Data Flow Engineer creates and manages data connections, performs validations and executes transformations, with a focus on improving auto-reconciliation through advanced technology.

What you'll do

• 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 to facilitate the intake process.
• Analyze data from existing feeds to identify, design and implement solutions that 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 be able to 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 best practices to 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.

What you'll need

• Bachelor's degree in Math, Computer Information Systems, or other relevant degree.
• 7+ years of relevant experience.
• Experience with industry-standard data transmission protocols.
• Strong understanding of SQL and relational database principles.
• 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.

Nice to have

• Securities, accounting, and financial experience.
• Experience with a scripting programming language such as Groovy, Perl or Python.
• Experience with industry-standard data transmission protocols.

Details

• Location: Noida, India (Office).