Fraud Screening Analyst - Intel

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.

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

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

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

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 refore, we welcome and encourage all applications from suitably qualified individuals, regardless of background or identity.