Senior Data Engineer

PLEASE NOTE:

• It is a remote position.
  


• Looking for candidates in the NY/NJ area or the very least on the East Coast.
  


• Duration: Contract through June 2027.
  

Job Description:

We are seeking a Senior Data Engineer with extensive Capital Markets experience to support the design, development, and implementation of trade lifecycle data solutions. The consultant will be responsible for building cloud-native data pipelines, onboarding complex financial data sources, and supporting a unified trade architecture that enables trade processing, reconciliation, settlement, and exception management functions.

This role requires strong technical expertise combined with deep knowledge of post-trade processing, DTCC platforms, and financial messaging standards.

Requirements

Required Skills & Experience:

• 10+ years of Data Engineering experience within Capital Markets environments.
  


• Strong Experience developing ETL pipelines using .NET application code and deploying solutions into containerized Kubernetes environments.
  


• Strong experience writing.NET applications utilizing RabbitMQ libraries for message queue integration and event-driven processing.
  


• Strong understanding of the complete trade lifecycle, including execution, clearing, settlement, and reconciliation.
  


• Extensive experience designing and implementing ETL/ELT data pipelines.
  


• Strong expertise in data modeling, schema design, and transaction data architecture.
  


• Hands-on experience with DTCC platforms, specifically RTTM and Settlement Web.
  


• Strong knowledge of ISO 15022 financial messaging standards.
  


• Experience developing ingestion frameworks utilizing MQ technologies (IBM MQ, RabbitMQ, Kafka, or similar) and REST APIs.
  


• Advanced SQL Server expertise including performance tuning, indexing, query optimization, and stored procedure development.
  


• Strong experience with AWS cloud-native services, including S3, EKS, Kubernetes, Docker, and RDS.
  


• Excellent troubleshooting, analytical, and problem-solving capabilities.
  

• Unified Trade Record (UTR) schema design and implementation.
  


• Trade Exceptions platform development and support.
  


• Real-time or near real-time data processing architectures.
  


• Data governance, lineage, cataloging, and observability tooling.
  


• Regulatory reporting and compliance data requirements within Capital Markets.
  


• FIX protocol message processing.
  


• FxML message processing.
  


• Previous consulting or client-facing delivery experience.