Forensic Data & Analytics

SJC Partners Limited; Greater London; On-site; GBP 60,000 - 90,000; Full time

Job summary

SJC Partners Limited’s Forensic Data Analytics team provides advanced analytics services to support high-profile, sensitive client matters such as real-time fraud detection, investigations, financial crime, disputes and litigation.

The role covers end-to-end delivery across the full data lifecycle—data extraction, transformation, loading (ETL), analysis, visualization, deployment and client delivery—using Python, SQL and BI tools like Power BI, while mentoring junior team members and aligning

Qualifications

• Degree in a STEM discipline or equivalent work experience.
• Proficient in SQL and Python with experience in Azure Data Factory and/or Databricks.
• Familiar with visualization techniques and multiple programming languages.
• Ability to work independently and mentor junior team members.
• Strong communication and problem-solving skills.

Responsibilities

• Support high-profile client matters with fraud analytics and financial crime expertise.
• Scope projects with clients and gather requirements.
• Deliver end-to-end analytics projects across the data lifecycle (ETL, analysis, visualization, deployment).
• Handle large structured and unstructured data from diverse sources.
• Explain analytics outputs to clients in business terms.
• Supervise and ensure quality of junior team members.
• Develop algorithms to detect fraud, misconduct and financial crime patterns.
• Create visuals to clearly present benefits of analysis to clients.
• Collaborate with technology, innovation and business development teams.

Skills

SQL

Python

Azure Data Factory

Databricks

Power BI

R

JavaScript

C#

Mentoring

Visualization

Education

STEM degree

Tools

SQL Server

PostgreSQL

Oracle

MySQL

Spotfire

Tableau

Power BI

Azure

Spark

Elasticsearch

Hadoop

HTML

JavaScript

Job description

My client's Forensic Data Analytics team provides advanced analytics services to support high-profile and sensitive client matters such as real-time fraud detection / prevention, fraud investigations, financial crime, disputes, and litigation.

Your key responsibilities:

• Work with financial services clients, fraud strategy, fraud analytics, fraud investigators, internal and external auditors, lawyers and regulatory authorities in sensitive situations
• Communicate with clients to scope projects and gather requirements
• Highlight and explain the outputs of our analytics to clients in the context of their business
• Be responsible for end-to-end delivery of projects across the full lifecycle - Data extraction, transformation, loading (ETL), analysis, visualisation, deployment and client delivery
• Handle a large amount of structured and unstructured data from a variety of data sources
• Carry out reactive and proactive data analysis of large datasets using a wide range of technologies such as Python, SQL and Power BI.
• Supervise the work of junior team members and be responsible for quality control of work products from the team
• Develop algorithms and solutions to detect, respond, prevent, continually monitor and investigate areas of fraud, bribery & corruption, misconduct and financial crime
• Apply analytic techniques to prevent, detect, monitor or investigate potentially improper transactions, events or patterns of behaviour related to misconduct, fraud and non-compliance issues
• Develop supporting material using a suite of visualisation software to clearly present the benefits of the analysis to clients
• Align to various strategic teams in the areas of technology, innovation and business development

To qualify for the role, you must have:

• Strong academic qualifications with a degree in a STEM discipline (Computer Science, Engineering, Statistics, Mathematics, etc.) or equivalent work experience
• Demonstrable proficiency in SQL, Python, Azure data factory and/or Databricks, and Visualization techniques and awareness across other programming languages such as R, C#, JavaScript
• Ability to work independently, manage work products and mentor junior team members
• Strong critical thinking, problem-solving skills, understanding of algorithms and appreciation of working with data
• Excellent communication skills and ability to explain complex analytical concepts to stakeholders from different backgrounds

Ideally, you'll also have:

• Domain knowledge of Financial Crime, Market Abuse, Mis-selling remediations, accounting, fraud, bribery and corruption or sector specific knowledge or experience
• Organisational ability, people skills and project management potential
• Previous consulting experience and experience with:
  • Relational databases, e.g. SQL Server, PostgreSQL, Oracle, MySQL;
  • Data visualisation software: Spotfire, Tableau, or Power BI;
  • Azure cloud computing platform;
  • Big data technologies such as Spark, Elasticsearch, Hadoop;
  • Statistical techniques (regression, clustering etc.);
  • Machine learning and pattern recognition;
  • Front-end web development e.g. HTML, JavaScript;