Role purpose

Clyde & Co's Fraud Intelligence Team (FIT) is the analytical engine behind the firm's counter-fraud insurance practice. The team ingests, matches and triages insurance claims data against a range of industry intelligence feeds and third-party data sources to identify claims, claimants and networks warranting investigation by fee-earners and clients.

The team is mid-way through a strategic shift to a structured, partially automated intelligence pipeline. This six-month fixed-term role exists to keep that pipeline running reliably during the transition, capture and document the current process so it is repeatable and auditable, deliver practical improvements within the existing tooling, and act as operational subject-matter input into the build and rollout of the replacement system.

Key responsibilities

• Run the recurring intelligence screening cycle - ingest, clean and cross-match daily, weekly, monthly and quarterly data feeds against the team's intelligence database, and produce risk flags, alerts and intelligence packages for the wider team and instructing fee-earners.
• Maintain data quality and integrity across the intelligence database, including entity de-duplication, missing-attribute resolution, and standardised cleansing routines that protect downstream matching accuracy.
• Produce scheduled intelligence outputs, including recurring alert cycles for internal and client-facing distribution, and periodic trend reporting that supports leadership and client engagement.
• Document the end-to-end process (rules, logic, edge cases, escalation paths) to a standard that supports continuity, audit, and migration to the automated platform.
• Deliver tactical improvements within current tooling (advanced Excel and macros, Power Query, SQL, Power Automate) to reduce manual effort, improve accuracy and shorten cycle times.
• Act as operational SME on the migration to the automated screening platform, including defining and testing matching rules, supporting data mapping, and validating output during build and rollout.
• Provide flexible analytical support to the wider Fraud Intelligence Team on intelligence packages, network analysis, and ad-hoc investigations as priorities require.
• Ensure all screening activity meets the firm's data protection and audit obligations, including UK GDPR / DPA 2018 and applicable regulatory frameworks.

Essential

• Strong, demonstrable data-handling skills: advanced Excel (complex functions, lookups, ideally macros / VBA), structured data cleansing, and cross-dataset matching.
• Confidence working accurately with large, structured datasets drawn from multiple source systems with inconsistent schemas.
• Methodical and detail-focused, with the discipline to document a process to a standard fit for both audit and automation.
• Able to pick up an undocumented process quickly and operate with limited supervision.
• Sound grasp of rules-based logic and structured matching criteria (defined conditions, exclusion sets, exception handling).
• Comfortable acting as the operational voice of the current process during a system change.

Desirable

• Background in insurance, claims, counter-fraud, financial crime, or wider intelligence and investigations.
• Power Query, SQL, Power BI, Power Automate or comparable data tooling.
• Experience with link analysis and intelligence database platforms (e.g. i2 iBase/Analyst Notebook or equivalent).
• Familiarity with entity resolution and fuzzy matching across heterogeneous data sources.
• Working understanding of UK data protection (UK GDPR / DPA 2018) in a data-processing context.

The Firm

When you work at Clyde & Co, you join a team of 500 partners, 2,400 lawyers, 3,200 legal professionals and 5,500 people in nearly 70 offices and associated offices worldwide. Our values are the principles that guide the decisions we make, unite us in our endeavours and strengthen our delivery, for both our clients and our firm. We work as one, excel with clients, celebrate difference and act boldly. We are committed to operating in a responsible way by progressing towards a diverse and inclusive workforce that reflects the communities and clients it serves. We are devoted to providing an environment in which everyone can realise their potential, using its legal and professional skills to support its communities. We do this through pro bono work, volunteering and charitable partnerships, and minimising the impact it has on the environment, including through our commitment to the SBTi Net-Zero standard and the setting of ambitious emissions reduction targets.

Our Commitment

Clyde & Co is proud to be an equal opportunities employer. Our values encourage us to support fairness, celebrate diversity and prohibit all forms of discrimination in the workplace to allow everyone to excel at work. Therefore, we welcome and encourage all applications from suitably qualified individuals, regardless of background or identity. Learn more about our interview process.

A Note on Privacy

Please take a moment to read our privacy notice. This describes what personal information Clyde & Co (we) may hold about you, what it's used for, how it's obtained, your rights and how to contact us as a data subject.

If you are submitting a candidate as a Recruitment Agency Partner, it is an essential requirement and your responsibility to ensure that candidates applying to Clyde & Co are aware of this privacy notice.

This is the job description as constituted at present; however, Clyde & Co reserves the right to reasonably amend it in accordance with the changing needs of the business.