Senior Data Engineer

Jobtailor; Connecticut; On-site; USD 120,000 - 160,000; Full time

Job summary

Trexquant is seeking an experienced data engineer to design and maintain scalable ingestion pipelines for market, reference, tick, and vendor data. You will own data normalization, validation, storage, and lifecycle management to support quantitative research and simulations.

You will develop Python- and SQL-based workflows across equities, options, futures, fixed income, ETFs, and FX, collaborating with researchers and infra teams to onboard datasets and improve data quality.

Qualifications

• Bachelor’s or Master’s degree in computer science, engineering, mathematics, or related field.
• 5+ years of data engineering experience in quantitative or fintech environments.
• Proficient in Python and SQL for large-scale ETL pipelines.
• Strong Linux scripting and automation experience.
• Experience with market, reference, tick and vendor data feeds, and data quality control.
• Familiarity with Parquet, Arrow, object storage, and columnar databases.

Responsibilities

• Design, build, and maintain scalable data ingestion pipelines for multiple data types.
• Own normalization, validation, storage, and lifecycle management of research datasets.
• Develop Python- and SQL-based data processing workflows for various asset classes.
• Collaborate with researchers, data architects, and infra teams to onboard datasets.
• Build monitoring, automation, and tooling to ensure reliability and performance.

Skills

Python

SQL

Data pipelines

Linux scripting

Communication

Collaboration

ETL

Education

Bachelor's or Master's in CS/Engineering/Math

Tools

Parquet

Arrow

Object Storage

Columnar Databases

Job description

Responsibilities

• Design, build, and maintain scalable ingestion pipelines for market, reference, tick, and alternative data from a diverse set of external vendors.
• Own the normalization, validation, storage, and lifecycle management of research datasets, ensuring data is accurate, consistent, and readily accessible for quantitative research and simulation.
• Develop and optimize Python- and SQL-based data processing workflows supporting multiple asset classes, including equities, options, futures, fixed income, ETFs, and FX.
• Partner with quantitative researchers, data architects, and infrastructure teams to onboard new datasets, improve data quality, and deliver reliable research‑ready data.
• Build monitoring, automation, and operational tooling to ensure the reliability, performance, and scalability of the firm’s data platform.
• Document data pipelines and engineering best practices while contributing to the ongoing evolution of Trexquant’s research data infrastructure.

Requirements

• Bachelor’s or Master’s degree in Computer Science, Engineering, Mathematics, or a related quantitative field.
• 5+ years of data engineering experience within a systematic trading, quantitative research, hedge fund, or financial technology environment.
• Python and SQL development experience in building large‑scale data ingestion and ETL pipelines.
• Strong Linux experience, including scripting, automation, and operating production data processing systems.
• Deep knowledge of financial data across multiple asset classes, including equities, options, futures, fixed income, ETFs, FX, and alternative datasets.
• Experience working with market data, tick data, reference data, and vendor data feeds, including normalization, validation, and quality control.
• Familiarity with modern data storage formats and technologies such as Parquet, Arrow, object storage, and columnar databases.
• Strong communication and collaboration skills, with the ability to work effectively alongside researchers and engineering teams.

Core Competencies

Expertise in designing and maintaining scalable data ingestion pipelines, with strong proficiency in Python and SQL for data processing workflows. Deep understanding of financial data across multiple asset classes and experience in data quality management and operational tooling.

Tools & Technologies

• Parquet
• Arrow
• Object Storage
• Columnar Databases