Clearwater Analytics

Sr. Data Flow Engineer

Clearwater Analytics • $90K — $120K *
Boise, ID 83709In-Person
Finance & Insurance
5 - 7 years of experience
Today
Be an Early Applicant
Job Overview by Ladders

Qualifications

  • Bachelor's degree in Math, Computer Information Systems, or equivalent
  • 7+ years of relevant experience
  • Strong understanding of SQL and relational database principles
  • Familiarity with industry-standard data transmission protocols
  • Proficiency in a scripting language such as Groovy, Perl, or Python
  • Excellent verbal and written communication skills
  • Outstanding attention to detail and documentation skills

Responsibilities

  • Import and validate client file deliveries
  • Automate daily monitoring and reporting processes
  • Establish data connections via APIs and FTPs
  • Ensure timely data consumption from external portfolios
  • Normalize datasets into a standard Clearwater format
  • Identify and design solutions for improving auto-reconciliation
  • Communicate technical aspects to non-technical stakeholders
  • Participate in data acquisition and tooling migration projects
  • Assist in training and mentoring new employees
  • Document and build best practices for data processes

Benefits

  • Engagement in projects that drive technological advancements
  • Opportunity to contribute to process improvement and automation
  • Collaboration with diverse teams to enhance vendor relationships
  • Light on-call duties providing a balanced work structure
  • Mentorship opportunities to uplift new team members
Full 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.


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

About Clearwater Analytics

Clearwater Analytics is a global SaaS solution for automated investment data aggregation, reconciliation, accounting, and reporting. Clearwater helps thousands of organizations make the most of investment portfolio data with cloud-native software and client-centric servicing. Every day, investment professionals worldwide trust Clearwater to deliver timely, validated investment data and in-depth reporting. Clearwater aggregates, reconciles, and reports on more than $5.5 trillion in assets across thousands of accounts daily for our Fortune 500 clients.
Learn more about Clearwater Analytics
Size
1,500 employees
Market Cap
$4.4 billion
Industry
Finance & Insurance
NASDAQ
CWAN
* Ladders Estimates

Similar Jobs

Ad banner background

Get Ready For Your
Next Interview

More Jobs at Clearwater Analytics

More Finance & Insurance Jobs

Find similar Sr. Data Flow Engineer jobs:

NationwideBoise, ID