Production Data Engineer for Fintech Markets — On-Site NYC

Open Select; New York (NY); On-site; USD 140,000 - 190,000; Full time

Job summary

Open Select is building a production-grade data platform for public markets with a small, highly capable data team that owns end-to-end delivery—from ingestion to production monitoring. You will work on manageable, impactful datasets that power trading decisions.

We seek a data engineer who can run production pipelines, write clean SQL and Python, and model data with clear schema justifications. On-site in New York, you’ll join a team that values autonomy, strong technical craft, and rapid

Qualifications

• Extensive experience running production pipelines with orchestration ownership.
• Proficient in SQL and Python with minimal scaffolding.
• Ability to model data and justify schema decisions.
• Understanding of public markets reference data and identifier standards.
• Clear communication and proactive problem-solving.

Responsibilities

• Build and operate production data pipelines end-to-end.
• Design schemas for financial domains and absorb new data sources cleanly.
• Resolve identifiers across vendor feeds, APIs, and scraped sources.
• Onboard third-party data including messy vendor feeds, partner APIs, and PDFs.
• Monitor data quality using validation, contracts, freshness checks, and lineage tools.
• Model reference data covering securities masters, corporate actions, and filings.
• Instrument pipelines for observability and handle failures without hand-holding.

Skills

SQL

Python

Data modeling

Public markets knowledge

Communication

Autonomy

Streaming / tick data (bonus)

Tools

Airflow

Dagster

Prefect

Snowflake

BigQuery

Databricks

Job description

Open Select is building a production-grade data platform for public markets with a small, highly capable data team that owns end-to-end delivery—from ingestion to production monitoring. You will work on manageable, impactful datasets that power trading decisions.

We seek a data engineer who can run production pipelines, write clean SQL and Python, and model data with clear schema justifications. On-site in New York, you’ll join a team that values autonomy, strong technical craft, and rapid