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 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:
Securities, accounting, and financial experience.
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 like Groovy, Perl or Python.
Experience with industry-standard data transmission protocols preferred.
Skills Required
- Bachelor's degree in Math, Computer Information Systems, or other relevant degree
- 7+ years of relevant experience
- Securities, accounting, and financial experience
- Strong understanding of SQL and relational database principles
- Experience with a scripting programming language (Groovy, Perl, or Python)
- Experience with industry-standard data transmission protocols
- Experience establishing connections via external APIs and FTPs
- Proficiency with Microsoft Office and strong computer skills
- Excellent attention to detail and strong documentation skills
- Outstanding verbal and written communication skills
- Strong organizational, interpersonal, and problem-solving skills
What the Team is Saying
_1.jpg)
_1.jpg)
Clearwater Analytics (CWAN) Compensation & Benefits Highlights
-
Retirement Support — A company 401(k) match with immediate vesting is consistently included alongside tax‑advantaged accounts. This indicates reliable long‑term savings support as part of the package.
-
Equity Value & Accessibility — Equity participation is available through an employee stock purchase plan, with RSUs included for some roles. This adds ownership potential beyond base pay and bonus.
-
Leave & Time Off Breadth — Paid time off is available from day one with a baseline around three weeks, plus company holidays and volunteer time. Flexible elements like work‑from‑home Fridays and limited “work from anywhere” periods broaden practical time‑off utility.
Clearwater Analytics (CWAN) Insights
What We Do
CWAN was founded on a simple belief: investment professionals deserve modern technology that actually works for them. Not legacy systems that slow them down. Not fragmented data that creates confusion. But one comprehensive platform that gives you complete visibility and crystal-clear insights. The result? Investment management that works as seamlessly as your investment strategy. Since our founding in 2004, CWAN has been the trusted technology partner powering the world’s leading institutional investors — from insurance companies, asset managers, and hedge funds to asset owners like corporations, endowments, and pension funds managing over $10 trillion in assets.
Why Work With Us
We continue to grow, fueled by a strong foundation, an ambitious vision, and a commitment to delivering exceptional value to our clients, partners, and team members around the world. What started as a bold idea in Boise, Idaho has rapidly transformed into a global presence. We’ve expanded our footprint significantly—now operating out of 24 offices
Gallery
Clearwater Analytics (CWAN) Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
