Senior SQL Engineer

This position owns the technical interpretation and implementation of trading risk logic, with primary hands-on responsibility for SQL-based risk calculations and data layers. The role leads development across SQL, data ingestion, and frontend/backend streams, ensuring that positions, exposures, pricing, and P&L outputs are accurate, performant, and aligned with agreed business definitions.

Our client is a trading company located in Geneva

Description

End-to-end technical ownership: Acts as the single technical owner for the CRR platform, accountable for solution coherence, correctness, performance, and scalability across all development streams.

SQL risk logic leadership: Leads the design and implementation of SQL-based risk logic, including base, semantic, and reporting data layers, with primary hands-on responsibility for complex transformations and performance tuning.

Cross-stream technical leadership: Provides technical leadership across SQL developers, data engineers, and full stack engineers, ensuring alignment across ingestion, data layers, APIs, and user interfaces.

Risk data correctness and integrity: Ensures consistency and correctness of positions, exposures, pricing, and P&L outputs across end-of-day and reporting use cases.

Architecture and design stewardship: Guides and reviews architectural decisions across database, data ingestion pipelines, OpenSearch, and .NET/React-based UI and API layers.

Business and domain partnership: Partners closely with the Senior Business Analyst and Domain Modeler to translate business requirements into implementable technical designs, providing feasibility assessment and technical guidance.

Technical risk and debt management: Identifies, assesses, and proactively manages technical risks, performance bottlenecks, and technical debt to protect platform stability and long-term maintainability.

Delivery and production readiness: Supports release planning, cutovers, and production readiness, ensuring data availability, performance validation, and operational stability.

Engineering standards and quality: Defines and enforces standards for SQL development, data quality, lineage, DevOps and coding practices, and design patterns across the CRR engineering team.

Mentorship and capability uplift: Mentors engineers across streams and contributes to raising overall engineering quality, consistency, and technical maturity within the CRR team.

Profile

Minimum requirement of 10 years of relevant work experience, typically reflecting 10-15+ years in engineering roles delivering data-intensive or analytics-driven platforms.

Demonstrated experience owning end-to-end delivery of complex, multi-stream engineering solutions, with deep hands-on responsibility in SQL development.

Strong experience delivering trading or risk platforms, preferably in commodities or capital markets environments.

Proven ability to balance hands-on technical contribution with architectural leadership and cross-team influence.

Strong communication skills with the ability to engage effectively with both technical and business stakeholders.

Required Skills:

Mandatory:

• Expert-level SQL development and performance optimization
• Strong understanding of relational data modeling, data layers, and lineage
• Proven experience implementing complex risk or analytical logic in database-centric platforms
• Ability to reason across data ingestion, transformation, API, and UI consumption layers
• Strong system design skills spanning databases, services, and reporting interfaces
• Experience owning production readiness and end-to-end solution delivery

Good to Have:

• Experience with distributed large-scale operational databases
• Familiarity with OpenSearch or search-based analytics patterns
• Working knowledge of .NET backend services and React/AG Grid-based frontends
• Experience with SAP ODP, CTRMs, or enterprise data replication
• Exposure to cloud-native architectures and AWS-based platforms

Job Offer

Attractive package