Sr. Software Development Engineer
Clearwater Analytics24 days ago
Noida, IndiaSenior
Responsibilities
- Design and build Python-based ETL/ELT pipelines for multi-asset market and reference data from Bloomberg, Refinitiv/LSEG, ICE Data Services, and FactSet.
- Engineer and maintain a securities master system covering identifiers, corporate actions, instrument attributes, and classification hierarchies.
- Build and operate real-time and batch data feeds with AWS-native services and millisecond-to-second service-level agreements.
- Implement data quality frameworks including completeness checks, anomaly detection, stale-data alerting, and reconciliation against authoritative vendor sources.
- Architect event-driven AWS infrastructure using Infrastructure-as-Code and contribute to automated, tested, and observable CI/CD deployments.
- Drive schema design, data modeling, and partitioning strategies for query performance and storage efficiency at petabyte scale.
- Make architectural decisions, mentor peers, and collaborate with quant researchers, data vendors, and platform engineers.
Requirements
- 7+ years of software engineering experience, including at least 4 years building production data pipelines in Python.
- Hands-on experience with AWS data services including S3, Glue, Lambda, Kinesis or MSK, Redshift, RDS, and Step Functions.
- Strong understanding of market data domains including pricing, corporate actions, identifier mapping, and instrument reference data in financial services or fintech.
- Experience designing and operating highly available, low-latency streaming and batch pipelines in production.
- Proficiency in SQL and data modeling for analytical and operational workloads.
- Familiarity with schema validation, reconciliation, service-level monitoring, dead-letter queues, alerting, and other data quality patterns.
- Strong written and verbal communication skills, including design documentation and cross-disciplinary technical discussions.
- Preferred: securities master and reference data experience with CUSIP, ISIN, SEDOL, FIGI, and corporate action processing.
- Preferred: integration experience with Bloomberg B-PIPE or SAPI, Refinitiv/LSEG Elektron, and ICE Data Services.
- Preferred: Apache Airflow or similar workflow orchestration experience.
- Preferred: Apache Iceberg, Delta Lake, or other open table format experience.
- Preferred: risk or pricing platform experience in asset management or insurance investment operations.
- Preferred: AWS Professional or Specialty certifications in areas such as Data Analytics or Solutions Architect.
Tech Stack
Categories
BackendData Engineering
About Clearwater Analytics
Clearwater Analytics builds a SaaS platform for investment accounting, reconciliation, performance, compliance, and risk reporting used by insurers, asset managers, banks, corporations, and governments. It aggregates and normalizes market and trade data and offers front‑office tools (Beacon) that give portfolio teams real‑time visibility into positions. Founded in 2004 and headquartered in Boise, Idaho, the company is publicly traded on the NYSE (ticker: CWAN).