Data Flow Engineer III

Clearwater Analytics India Private Limited; Dadri; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Clearwater Analytics India Private Limited is seeking a Data Flow Engineer to build and manage connections, perform validations, and execute data transformations. The role focuses on automating processes and improving auto-reconciliation through robust data engineering practices.

You will work with external data feeds, APIs, and FTPs, ensuring timely ingestion and normalization into Clearwater formats, while mentoring new hires and contributing to best practices across the division.

Qualifications

• Bachelor's degree in Math, CIS or related field and 7+ years of experience.
• Experience with data transmission protocols and scripting languages.
• Strong SQL and data modeling skills.
• Excellent attention to detail and documentation abilities.
• Clear communication, both verbal and written, with strong organizational skills.

Responsibilities

• 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.
• Design and implement improvements for auto-reconciliation.
• Create scripts to automate repeat tasks and error resolution.
• Mentor new hires and share best practices.
• Coordinate and communicate project work across teams; participate in light on-call duties.

Skills

SQL & relational databases

Financial services experience

Microsoft Office

Attention to detail

Documentation skills

Verbal & written communication

Organizational & interpersonal skills

Problem solving

Education

Bachelor's degree in Math, Computer Information Systems, or other relevant degree

Tools

Groovy / Perl / Python scripting

Job 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. 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.

Thank you for your interest in a career with Clearwater!

Clearwater Analytics (NYSE: CWAN) is transforming investment management with the industry’s most comprehensive cloud‑native platform for institutional investors across global public and private markets. While legacy systems create risk, inefficiency, and data fragmentation, Clearwater’s single‑instance, multi‑tenant architecture delivers real‑time data and AI‑driven insights throughout the investment lifecycle. The platform eliminates information silos by integrating portfolio management, trading, investment accounting, reconciliation, regulatory reporting, performance, compliance and risk analytics in one unified system. Serving leading insurers, asset managers, hedge funds, banks, corporations, and governments, Clearwater supports over $8.8 trillion in assets globally. Learn more at www.clearwateranalytics.com.

Studies have shown that women and people of color are less likely to apply to jobs unless they meet every single qualification. We are dedicated to building a diverse, inclusive and authentic workplace, so if you’re excited about this role but your past experience doesn’t align perfectly with the job description, we encourage you to still apply! You may be just what we’re looking for.