Fraud Screening Analyst - Manchester/ Liverpool

Clyde & Co Claims LLP; Manchester; On-site; GBP 35,000 - 52,000; Full time

Job summary

Clyde & Co’s Fraud Intelligence Team seeks a six‑month fixed‑term data analyst to run the intelligence screening pipeline, clean and cross‑match data, and deliver timely intelligence packages for the team and clients.

The role focuses on documenting current processes, implementing practical improvements with Excel and SQL‑based tooling, and supporting the migration to an automated platform while ensuring data protection obligations are met.

Qualifications

• Strong data handling and cleansing skills with complex datasets.
• Ability to document processes clearly for audit and automation.
• Comfort working with diverse source systems and inconsistent schemas.
• Experience with data tooling and knowledge of GDPR/data protection basics.

Responsibilities

• Run recurring intelligence screening cycles and generate risk flags and alerts.
• Maintain data quality, deduplication, and cross‑dataset matching.
• Produce scheduled outputs and trend reports for leadership and clients.
• Document end‑to‑end processes for continuity and migration.
• Suggest practical improvements using Excel, Power Query, SQL and automation.

Skills

Advanced Excel

Macros / VBA

Data handling

Data cleaning

Data matching

Tools

Power Query

SQL

Power BI

Power Automate

i2 iBase / Analyst Notebook

Job description

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 Qualifications

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

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

Equal Opportunity Employment

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.