Data Flow Engineer

Clearwater Analytics • Full-time • City of Edinburgh, Scotland, United Kingdom • 2d ago

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.
Normalise external datasets into a standardised 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 normalising 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:

Strong understanding of SQL and relational database principles.
Experience with scripting programming languages like Groovy, Perl or Python.
Some knowledge of securities, accounting, or financial topics preferred.
Strong computer skills, including proficiency in Microsoft Office.
Excellent attention to detail and strong documentation skills.
Outstanding verbal and written communication skills.
Strong organisational and interpersonal skills.
Exceptional problem-solving abilities.

Education and Experience:

Bachelor's degree in Maths, Physics, Computer Information Systems, or other relevant degrees.
1+ years of relevant experience, or Master's degree in relevant discipline, preferred.

Related Jobs

Senior Python Data Scraping Engineer (Freelance)

Mindrift • Part-time • Remote (Edinburgh, Scotland, United Kingdom) • 1d ago

Data & Analytics Data Centres IT

Mindrift is looking for highly skilled Senior Python Data Scraping Engineers to join the Tendem project and drive specialized data scraping workflows within our hybrid AI + human system. In this role, as an AI Pilot – th...

1d ago

Apply

Data Scientist

SSE • Full-time • Edinburgh & The Lothians, Scotland, GB • 2m ago

Data & Analytics Data Centres IT

About the Role Base Location: Perth, Reading, Cardiff, Glasgow or Edinburgh Salary: £42,600 - £64,000 + performance-related bonus + a range of benefits to support your finances, wellbeing and family. Working Pattern:...

2m ago

Apply

Data Services Actuary ( Associate Consultant / Consultant )

Lane Clark & Peacock • Hybrid • Remote (Edinburgh, Scotland, United Kingdom) • 1d ago

Data & Analytics

Data Services Actuary (Associate Consultant/Consultant) Location - Edinburgh with hybrid working as per departmental requirements (currently a MINIMUM of 40% (2 days per week). Our Pensions Data Services team is rapidly...

1d ago

Apply

Assistant Manager, Marketing Analytics

Lloyds Banking Group • Full-time • City of Edinburgh, Scotland, United Kingdom • 4d ago

Data & Analytics Marketing

End Date Saturday 27 June 2026 Salary Range £48,987 - £54,430 We support flexible working – click here for more information on flexible working options Flexible Working Options Flexibility in when hours are worked, Hybri...

4d ago

Apply

Markets Data Engineer

Financial Conduct Authority • Hybrid • City of Edinburgh, Scotland, United Kingdom • 4d ago

Data & Analytics Finance

Job title: Markets Data Engineer Division: Enforcement & Market Oversight Department: Market Oversight, Data & Intelligence Salary: National (Edinburgh & Leeds) ranging from £53,000 to £69,000 and Lond...

4d ago

Apply