Senior Market Risk Tech Engineer - Data Pipelines & AI

Capgemini; New York (NY); Hybrid; USD 103,000 - 129,000; Full time

Benefits offered by this job

Paid time off

Medical, dental, vision coverage

401(k) retirement savings

Employee assistance programs

Job summary

Capgemini is seeking a Senior Technologist to architect scalable data pipelines that ingest billions of PV calculations from risk engines. You will build high-performance aggregation jobs with Spark and create intelligent data APIs for on-demand access to risk insights.

You will load massive datasets into OLAP engines such as Pinot, Druid, or Trino, and develop interactive analytics tools and dashboards. Collaborating with Front Office and Risk teams, you’ll translate complex analytics needs

Qualifications

• Degree in a quantitative or technical field is required.
• Expert-level hands-on experience with big data technologies (Spark).
• Proven experience with high-performance OLAP databases (Pinot/Druid/Trino).
• Strong programming skills in Python, Java and/or Scala, and expert-level SQL.

Responsibilities

• Architect and build data pipelines to ingest and process billions of PV calculations from stress engines.
• Develop and optimize large-scale aggregation jobs using Spark.
• Design and deliver intelligent data APIs for flexible access to risk data.
• Integrate NLP to create intuitive query-based data exploration interfaces.
• Load and model large datasets into OLAP engines (Pinot/Druid/Trino) and build interactive dashboards.

Skills

Python

SQL

Java

Scala

Data structures & algorithms

AI-first mindset

Education

Degree in Computer Science or quantitative field (e.g., Financial Mathematics/Financial Engineering)

Tools

Apache Spark

Apache Pinot

Apache Druid

Trino

NLP frameworks

Job description

Capgemini is seeking a Senior Technologist to architect scalable data pipelines that ingest billions of PV calculations from risk engines. You will build high-performance aggregation jobs with Spark and create intelligent data APIs for on-demand access to risk insights.

You will load massive datasets into OLAP engines such as Pinot, Druid, or Trino, and develop interactive analytics tools and dashboards. Collaborating with Front Office and Risk teams, you’ll translate complex analytics needs