Data Engineer

TECHOHANA; New York (NY); Hybrid; USD 69,000 - 115,000; Full time

Benefits offered by this job

Full medical, dental and vision

401k

Generous PTO

Paid development days

Job summary

TechOhana is partnering with a global capital markets SaaS platform to hire a Data Engineer based in New York City. The role focuses on stabilising a SQL Server estate while migrating to Snowflake on AWS.

You’ll work on ETL/ELT pipelines with Python and Airflow, modernise the data platform, and aim toward a data science track. The position is permanent, full-time, hybrid in NYC with three days in the office.

Qualifications

• Hands-on Snowflake experience, ideally on a SQL Server to Snowflake migration.
• Python or C#.
• Apache Airflow, AWS (S3), Git and CI/CD.
• Snowflake, SQL or AWS certifications.
• Finance domain experience: securities, equities, FX or futures and options.

Responsibilities

• Stability focus in first 6–12 months: keep the current system running and own the legacy ticket queue.
• Analyze business logic in stored procedures and redesign it for Snowflake.
• Build ETL/ELT pipelines with Python and Airflow.
• Add monitoring, logging and alerting to critical pipelines.
• Opportunity to grow towards a data scientist role.

Skills

Snowflake experience

Python

C#

Apache Airflow

AWS

SQL Server

Tools

SQL Server

Git

CI/CD

Snowflake

Airflow

AWS

Job description

TechOhana have partnered with a global capital markets SaaS platform to bring on a Data Engineer, based in New York City.

The platform supports transaction cost analysis for portfolio managers, a specialist area of trading analytics, and takes in roughly 1TB of market and client data each day. The team is modernising a large SQL Server estate onto Snowflake and AWS, and the role offers a route into data science over time.

You’ll work across the existing SQL Server environment and the new cloud platform. In the first six to twelve months the priority is stability: keeping the current system running without downtime and owning the legacy ticket queue. Alongside that you’ll analyse business logic held in stored procedures and redesign it for Snowflake, build ETL/ELT pipelines with Python and Airflow, and add monitoring, logging and alerting to critical pipelines.

Hands-on Snowflake experience, ideally on a SQL Server to Snowflake migration

Python or C#

Apache Airflow, AWS (S3), Git and CI/CD

Snowflake, SQL or AWS certifications

Finance domain experience: securities, equities, FX or futures and options

Up to $115,000 base

Permanent, full time

New York City, hybrid with three days a week in the office

Full medical, dental and vision cover, 401k, generous PTO and paid development days

Room to grow towards a data scientist role