Data Flow Engineer III

Clearwater-Analytics-; Dadri; Vor Ort; INR 900.000 - 1.400.000; Vollzeit

Zusammenfassung

Clearwater Analytics in India seeks a Data Flow Engineer to design and manage data connections, validate data, and transform datasets for standardized intake. The role emphasizes improving auto-reconciliation with external feeds, APIs, and FTPs, while building automation and documenting best practices.

You will import client data, automate monitoring, and collaborate with Operations and Development to implement improvements, training, and cross-team communication.

Qualifikationen

• Bachelor's degree in Math, Computer Information Systems, or a related field.
• 7+ years of relevant experience.
• Experience with Groovy, Perl or Python scripting.
• Experience with data transmission protocols.
• Securities, accounting, and financial domain knowledge preferred.

Aufgaben

• Import and validate file delivery for new clients.
• Automate daily process monitoring and reporting.
• Establish connections via external APIs and FTPs.
• Normalize external datasets into Clearwater format for intake.
• Analyze feeds to improve auto-reconciliation.
• Implement improvements requested by Ops/Dev teams.
• Apply best practices to normalize feeds and enhance automation.
• Explain Clearwater workflows, tools, and value proposition.
• Use critical thinking to address internal/external issues.
• Communicate Clearwater tech and practices to stakeholders.
• Participate in projects like data acquisitions and tooling migrations.
• Assist in training and mentoring new hires.
• Document and promote best practices division-wide.
• Design scripts to automate repeat tasks and errors.
• Coordinate project work across teams and on-call duties.

Kenntnisse

SQL

Relational Databases

Problem Solving

Documentation

Communication Skills

Organizational Skills

Office Suite

Groovy

Python

Perl

Securities / Accounting / Financial

On-call Support

Ausbildung

Bachelor's degree in Math / CIS / related field

Jobbeschreibung

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 degree7+ 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.