Senior Data Scientist - AI & Data Warehouse Systems

EXANTE
Canton de Saint-Mihiel, France
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior

Job location

Remote
Canton de Saint-Mihiel, France

Tech stack

API
Artificial Intelligence
Data analysis
Business Logic
Google BigQuery
Databases
Data Governance
Data Infrastructure
Information Leak Prevention
Data Warehousing
Machine Learning
Standard Sql
SQL Databases
Large Language Models
Snowflake
Multi-Agent Systems
Data Analytics
GPT
Automation Anywhere
Redshift
Databricks

Job description

We are looking for a Senior Data Scientist to help build the next generation of analytics on top of our enterprise data warehouse. This role is focused on a practical and increasingly important challenge: how AI interacts with structured business data.

The successful candidate will help design and build systems where AI can understand, query, validate, reconcile, and reason on analytical data in a reliable and controlled way.

This is not a traditional dashboarding role, and it is not a pure research-focused Data Science role. The primary focus is practical implementation of AI systems inside a modern data warehouse environment.

The role combines several disciplines:

  • Data Science
  • AI / Large Language Models (LLMs)
  • Data Warehousing & Analytics Engineering
  • Machine Learning
  • Data Quality & Validation
  • AI Agentic Workflows

What We Are Building

We are building an AI-ready analytical environment on top of our data warehouse where AI can reliably interact with structured business data.

Examples include:

  • Natural-language analytics on warehouse data
  • AI-driven reconciliation and validation
  • Analytical copilots
  • Data quality automation
  • Business metric validation
  • Automated anomaly detection
  • Multi-agent analytical workflows, Help define how AI interacts with warehouse data through prompts, semantic context, retrieval logic, validation mechanisms, and AI workflows. Ensure AI produces correct and trusted answers., Work hands-on with technologies such as ChatGPT, Claude, OpenAI APIs, and AI agents. Test, evaluate, and improve AI outputs. Design workflows where multiple AI agents collaborate to solve analytical problems.
  1. Ensure Metric Correctness

Help define how AI interprets business metrics and financial logic. Ensure AI correctly understands the difference between concepts such as revenue, cost, gross revenue, net revenue, trading volume, cash movement, accounting movement, balances, and position changes.

  1. Improve Data Governance & Reliability

Ensure AI interacts with data in a controlled and secure manner. Help implement validation mechanisms, prevent sensitive data exposure, and improve trust in AI-generated outputs.

Scope:

Data Platform

  • Build clean, reusable analytical data layers in BigQuery
  • Move business logic from BI into the warehouse
  • Define metrics, dimensions, and semantic consistency

AI Interaction

  • Enable reliable AI data interaction
  • Design schemas + instructions so AI produces correct outputs
  • Test and refine real AI usage (not theory)

Access & Governance

  • Implement data-layer access control (not BI-layer)
  • Row/column-level security, role/attribute-based access
  • Ensure consistent behavior across BI, AI, and internal tools
  • Ensure metric reconciliation across different data sources

Prevent:

  • sensitive data leakage
  • shadow metric layer
  • uncontrolled query cost

Automation:

  • Replace manual data workflows with AI-driven processes
  • Build agents for reporting, validation, and internal analytics

Requirements

Do you have experience in SQL?, * Strong SQL and analytical data modeling

  • Experience working with analytical databases (BigQuery, Snowflake, Databricks, Redshift or similar)
  • Practical experience with LLMs (ChatGPT, Claude, OpenAI APIs or similar)
  • Experience building AI-driven workflows or agent-based systems
  • Strong analytical and problem-solving skills
  • Understanding of machine learning fundamentals

Nice to have:

  • Experience training or fine-tuning models using historical/labeled data
  • Entity resolution / record matching
  • Classification models and probability scoring
  • RAG / vector databases
  • dbt / semantic layers
  • BigQuery optimization
  • Finance, brokerage, or fintech experience
  • Data governance or fine-grained access control

About the company

EXANTE is a pioneering wealth tech company that delivers cutting-edge centralized trading solutions and robust B2B financial infrastructure, driving value through innovative technology. Our bespoke, internally engineered trading platform provides seamless access to a diverse range of financial instruments, including stocks, ETFs, bonds, futures, and options, all within a single, multi-currency account. As a rapidly expanding global firm with over 700 talented employees from 70+ nationalities across 70 locations, we are a frontrunner in the financial sector. Our investment priorities are clear: We prioritize investing in our most valuable asset-our people. Join us in shaping the future of finance., A group of disruptive technology experts created EXANTE. With an impressive track record in the industry and knowledge of the markets, our systems are built to democratize access to global financial instruments for professional traders and institutional investors. Through our robust, cutting-edge trading platforms, you can offer clients access to comprehensive, global financial instruments and investment possibilities while keeping their data safe and private. EXANTE is a global prime broker backed by proprietary technology and dedicated service. All regulated group companies and fully controlled affiliates and subsidiaries are committed to compliance with data protection laws, including the GDPR. We process personal data in line with the GDPR principles of fairness, purpose limitation, transparency, data minimisation, storage limitation and deletion, accuracy, confidentiality and integrity, and accountability. We rely on legitimate interests to assess and manage your application, after determining that our interests are not overridden by your rights and interests. You have the rights of access, rectification, data portability, erasure, restriction of processing, and objection to processing. To exercise your rights or contact our Data Protection Officer, please see our GDPR policy at https://exante.eu/gdpr/. We retain recruitment data only for as long as necessary for the purposes described above, after which it will be securely deleted unless we are required to keep it longer to comply with law or you consent to a longer retention.

Apply for this position