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.
Skills Required
- 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
- 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 and REST APIs
- Advanced SQL Server expertise including performance tuning, indexing, query optimization, and stored procedure development
- Strong experience with AWS cloud-native services
- Excellent troubleshooting, analytical, and problem-solving capabilities
What We Do
Omm IT Solutions is a leading provider of IT consulting, analysis, and advisory services, specializing in delivering technical solutions for federal and state government agencies. Their offerings include application development, cybersecurity services, cloud advisory, network modernization, and data analytics.
