Data Flow Engineer

undefined ago • All levels • Data Analysis

Job Summary

Job Description

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.
Must have:
  • 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 various issues, such as normalizing new feeds and improving automation.
  • Understand and 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 our best practices with non-technical internal and external stakeholders.
  • Engage in light on-call duties.

Job Details

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 various issues, such as normalizing new feeds and improving automation.
  • Understand and 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 our best practices with non-technical internal and external stakeholders.
  • Engage in light on-call duties.

Required Skills:

  • Securities, accounting, and financial experience.
  • Strong understanding of SQL and relational database principles.
  • Experience with scripting programming languages like Groovy, Perl or Python.
  • Experience with industry-standard data transmission protocols preferred.
  • 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 degrees.
  • Experience with industry-standard data transmission protocols.

Welcome

Thank you for your interest in a career with Clearwater!

About us

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.

Don’t meet every single requirement?

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.

Similar Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Similar Skill Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Jobs in Noida, Uttar Pradesh, India

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

Data Analysis Jobs

Looks like we're out of matches

Set up an alert and we'll send you similar jobs the moment they appear!

About The Company

Clearwater Analytics (NYSE: CWAN) is the leading provider of web-based investment portfolio accounting, reporting, and reconciliation services for institutional investors at thousands of organizations.


Clearwater aggregates, reconciles, and reports on more than $6.4 trillion in assets across thousands of accounts daily. Our clients include corporate treasuries, insurance companies, investment managers, banks, governments, and other institutional investors both in the United States and worldwide.


For more than a decade, we have leveraged web-based software and world-class client service to help clients such as American Family Insurance, Arch Capital, C.V. Starr & Co., Cisco, Facebook, Oracle, Selective Insurance, Sirius Group, Sompo International, Starbucks, WellCare Health Plans, Wilton Re, and many others, streamline their investment and accounting operations. Clearwater also works with hundreds of custodians, investment managers, dealers/brokers, and electronic trading portals who offer Clearwater to their many clients.


With global headquarters in Boise, Idaho, and offices in Edinburgh, Frankfurt, London, New Delhi, New York, Paris, Seattle, Singapore, and Washington D.C., Clearwater sets the new global standard for investment portfolio reporting.

Bengaluru, Karnataka, India (On-Site)

Chicago, Illinois, United States (On-Site)

Noida, Uttar Pradesh, India (On-Site)

Mumbai, Maharashtra, India (On-Site)

Chicago, Illinois, United States (On-Site)

Bengaluru, Karnataka, India (On-Site)

New York, United States (On-Site)

Noida, Uttar Pradesh, India (On-Site)

New York, United States (On-Site)

Noida, Uttar Pradesh, India (On-Site)

View All Jobs

Get notified when new jobs are added by Clearwater Analytics

Level Up Your Career in Game Development!

Transform Your Passion into Profession with Our Comprehensive Courses for Aspiring Game Developers.

Job Common Plug