Sr. Data Flow Engineer
Core
Create and manage data connections, perform validations, and execute transformations to enhance auto-reconciliation within the Clearwater system.
Role type
Senior Data Flow Engineer
Builds
Automated data ingestion pipelines, normalized datasets, and reporting tools for external portfolio data.
Domain
Financial services / Data engineering
Deliverable
production ML models | product features | dashboards & analysis
Required skills
SQL, relational database design, scripting (Groovy/Perl/Python), data transmission protocols, financial/accounting domain knowledge
Preferred skills
Financial securities experience, advanced automation techniques
Technologies
SQL, Groovy, Perl, Python, FTP, APIs, Clearwater
Responsibilities
Import and validate file delivery for new clients; Automate daily process monitoring and reporting; Establish connections through external APIs and FTPs; Normalize external datasets into a standardized Clearwater format; Design and build scripts to automate repeat tasks or error resolution; Execute improvements requested from Operations and Development groups.
Seniority
Senior, hands-on IC