Lead Data Content Curation Engineer

Schonfeld

Where
New York, New York, United States
Pay
$190K a year

Posted 9 days ago· Checked live at Schonfeld 2 hours ago

Live.Open on the employer's own site.

See how you score for this job

One sentence and your resume. We score it against what Schonfeld asks for, line by line.

See my score
Is this job still open?
Yes. We checked it live on Schonfeld's own hiring page 2 hours ago.
What is the job?
We are seeking a hands-on Lead Data Content Curation Engineer to transform complex financial and enterprise datasets into trusted, research-ready data products. Working closely with investment research teams, data engineers and platform specialists, you will translate raw vendor content into well-designed models, curated tables, views and reusable datasets across relational databases and modern lakehouse platforms.
What does it pay?
$190K a year, as the posting states.
Our verdict
Live. Open on the employer's own site.

What the job is

We are seeking a hands-on Lead Data Content Curation Engineer to transform complex financial and enterprise datasets into trusted, research-ready data products. Working closely with investment research teams, data engineers and platform specialists, you will translate raw vendor content into well-designed models, curated tables, views and reusable datasets across relational databases and modern lakehouse platforms.

What you’ll do

  • Own end-to-end curation of external and internal datasets, from source evaluation and ingestion design through modeling, validation, publishing and ongoing evolution; prioritize rapid delivery of research-ready content.
  • Interpret complex financial vendor data, including S&P Capital IQ and comparable fundamental, reference and market datasets: schemas, identifiers, relationships, update patterns and methodology changes.
  • Design and implement research-ready relational and lakehouse data models, SQL transformations, curated tables, materialized datasets and performant views across PostgreSQL, SingleStore and Apache Iceberg-based platforms.
  • Build shared, strategy-agnostic data products that support distinct investment workflows without duplicating core definitions, identifiers or historical logic.
  • Enable seamless, location-independent discovery and access to trusted datasets through catalog, API and query services, working with platform teams to preserve consistent semantics, entitlements and governance regardless of where data resides.
  • Partner with investment researchers and analysts to translate use cases into reusable content, including point-in-time company fundamentals, entity-linked financial metrics and historical research datasets.
  • Curate and deliver research-ready datasets supporting fundamental and quantitative investment strategies, including statistical arbitrage, Research Security Master, cross-vendor security identifiers, historical mappings, corporate actions and point-in-time reference data for consistent research and backtesting.
  • Build reliable ingestion and transformation pipelines with incremental processing, CDC where appropriate, backfills, reconciliation and exception handling.
  • Implement controls for completeness, accuracy, freshness, lineage, corporate actions, revisions and point-in-time correctness; investigate discrepancies with vendors and stakeholders.

What you’ll bring

What you need

  • A bachelor's degree
  • 10+ years in data engineering, database development or financial data platform engineering, including 5+ years working with financial datasets in investment management, financial services or financial data providers.
  • Expert SQL, strong relational data modeling and practical experience building analytical views and performant data access patterns in PostgreSQL or comparable databases.
  • Strong Python and production pipeline engineering skills, including testing, version control, CI/CD and operational monitoring.
  • Strong understanding of relational and modern lakehouse architectures, SQL-based access and open table formats such as Apache Iceberg; deep expertise in every named platform is not required.
  • Experience interpreting messy third-party datasets, resolving identifiers and relationships, managing historical changes and validating data at scale.
  • Strong knowledge of financial reference and entity data, company fundamentals, financial statements, estimates and historical revisions, including point-in-time correctness and avoidance of look-ahead bias.
  • Demonstrated domain expertise in at least one asset class or investment strategy, such as equities, futures, options, fixed income, credit, macro or statistical arbitrage, with an understanding of the underlying financial datasets, instruments, identifiers and research workflows.
  • Hands-on experience using AI/LLM-powered development tools to accelerate data engineering, with the ability to apply AI-assisted capabilities to repetitive curation and automation tasks.
  • Ability to work directly with research users, clarify requirements and rapidly deliver documented, reusable data products.

Similar open jobs

Jobs in New York (19157)