Data Engineer With Capital Market Exp

Tata Consultancy Services Limited

New York (NY)

On-site

USD 110,000 - 120,000

Full time

12 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

Tata Consultancy Services is seeking a Data Engineer with capital market experience in New York. The role focuses on building and optimizing data pipelines for post-trade data, and modeling securities data for reporting and analytics.

The ideal candidate combines strong SQL and Python skills with experience in data warehouses and cloud data platforms (AWS). Prior work with streaming and batch processing, as well as data quality and lineage, is highly valued.

Qualifications

  • Understanding of post-trade data flows including allocations, confirmations, settlement, risk, finance, and regulatory reporting.
  • Knowledge of securities data modeling and financial data structures; experience with reference data and trade data.
  • Strong SQL development skills and experience designing/optimizing relational data models and database schemas.
  • Proficiency in Python and data processing frameworks such as Pandas and PySpark.

Responsibilities

  • Understand post-trade data flows including allocations, confirmations, settlement, risk, finance, and regulatory reporting.
  • Model securities data and manage reference data, security master data, and transactional trade data.
  • Design and optimize relational data models and database schemas; implement ETL/ELT pipelines.

Skills

Data Modeling

Tools

Python
SQL
PySpark
Databricks
Snowflake
Redshift
PostgreSQL
Kafka
Spark
Airflow
Datadog
Grafana

Job description

Data Engineer with Capital Market Experience
Roles & Responsibilities
  • Understanding of post-trade data flows including allocations, confirmations, settlement, risk, finance, and regulatory reporting.
  • Knowledge of securities data modeling and financial data structures. Experience with reference data, security master data, and transactional trade data.
  • Understanding of time-series data management and financial market data is a strong plus.
  • Strong SQL development skills with experience designing and optimizing relational data models and database schemas.
  • Proficiency in Python, including data processing frameworks such as Pandas and PySpark.
  • Strong understanding of data warehouse, data lake, and Data Lakehouse concepts.
  • Experience working with large-scale transactional and analytical data platforms.
  • Experience with PostgreSQL, SQL Server, Snowflake, Redshift, Databricks, or similar database and data warehouse technologies on cloud, preferably AWS.
  • Experience with stream and batch data processing technologies such as Kafka, Spark, Flink, or similar platforms.
  • Experience building batch and streaming data pipelines, including ETL/ELT workflows, using Python and SQL.
  • Strong understanding of data quality, data lineage, data validation, and reconciliation processes.
  • Experience working with messaging technologies such as Kafka, RabbitMQ, IBM MQ, or similar platforms.
  • Familiarity with monitoring and observability tools such as Datadog, Prometheus, and Grafana.
  • Understanding of data security, privacy, and regulatory compliance requirements.
  • Exposure to data science, machine learning, and AI/GenAI data preparation concepts is a plus.

Salary Range- $110,000-$120,000 a year

Location

New York, NY

Function

TECHNOLOGY

Role

Engineer

ID

438590

Skills

Data Modeling

Salary Range

$110,000 - $120,000

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Engineer – Capital Markets
Senior Data Engineer – Capital Markets

Fynetra • Boston (MA)

Hybrid
USD 120,000 - 150,000
Hybrid work model
Exposure to capital markets and investment workflows
Data Engineer
Data Engineer

Henderson Scott US • New York (NY)

Hybrid
USD 80,000 - 100,000
Capital Markets Data Engineer — Big Data & Streaming in NY
Capital Markets Data Engineer — Big Data & Streaming in NY

Tata Consultancy Services Limited • New York (NY)

On-site
USD 110,000 - 120,000
Data Engineer
Data Engineer

Intec Select • New York (NY)

Hybrid
USD 150,000 - 250,000
Senior Data Engineer - Capital Markets (R13923)
Senior Data Engineer - Capital Markets (R13923)

Oportun • United States

Remote
USD 150,000 - 190,000
Remote-friendly arrangement
Country-specific benefits package
Parental leave
Data Operations Engineer
Data Operations Engineer

Thurn Partners • Chicago (IL)

On-site
USD 250,000 - 500,000
Senior Data Engineer
Senior Data Engineer

SIG • Bala Cynwyd (PA)

On-site
USD 120,000 - 160,000
Senior Data Engineer
Senior Data Engineer

Susquehanna International Group, LLP • Bala Cynwyd (PA)

On-site
USD 110,000 - 170,000
Data Engineer
Data Engineer

Tata Consultancy Services Limited • Charlotte (NC)

On-site
USD 95,000 - 115,000
Data Engineer
Data Engineer

KeyPartners • Bridgeport (CT)

Remote
USD 100,000 - 125,000