Data Engineer: SQL Server to Snowflake Migration on AWS

Neurensic; New York (NY); Hybrid; USD 95,000 - 115,000; Full time

Benefits offered by this job

Health insurance

Dental insurance

Vision insurance

401(k) retirement plan

Paid time off (PTO)

Transit and parking benefits

Job summary

Trading Technologies is seeking a Data Engineer in New York to modernize our SQL Server-based data platform and migrate to Snowflake on AWS. You will design data models, build ETL/ELT pipelines, and optimize production data workflows.

You will work across both legacy SQL Server and the cloud data platform, applying Python and C# scripting, with a focus on large-scale financial data and analytics. This is a hybrid role with in-person collaboration three days per week.

Qualifications

• Bachelor’s degree in Computer Science, Data Engineering, or a related field.
• Hands-on experience with Snowflake and AWS Cloud services (S3).
• Strong SQL development experience, including complex queries and performance tuning.
• Proficiency in Python and C# scripting.
• Experience migrating SQL Server workloads to Snowflake or other cloud platforms.

Responsibilities

• Develop, maintain, and optimize complex SQL Server queries, stored procedures, functions, views, and data processing workflows.
• Design and develop scalable Snowflake data solutions, including data models, SQL transformations, loading processes, and analytical workloads.
• Participate in the migration of large volumes of data and processing from SQL Server to Snowflake.
• Analyze existing SQL Server logic and translate or redesign it for Snowflake where appropriate.
• Build and maintain ETL/ELT pipelines using SQL, Python, and workflow orchestration tools such as Apache Airflow.
• Develop data ingestion and processing workflows using AWS, including S3.
• Perform SQL Server and Snowflake performance tuning, including query optimization, execution plans, indexing, statistics, warehouse sizing, and workload optimization.
• Build data validation and reconciliation processes to ensure migrated and transformed data is accurate and complete.
• Troubleshoot production data issues, identify root causes, and implement reliable long-term solutions.
• Implement monitoring, logging, alerting and operational controls for critical data pipelines.
• Collaborate with software engineers, service managers and implementation team, product teams, and DevOps.
• Support and enhance existing Transaction Cost Analysis (TCA) products and develop new functionality.
• Work with large-scale trade, market, benchmark, and financial data.

Skills

SQL development

Python

C#

Large-scale data handling

Problem solving

Education

Bachelor's degree in Computer Science or Data Engineering

Tools

Snowflake

Microsoft SQL Server

Airflow

Git

CI/CD

Liquibase

AWS

Job description

Trading Technologies is seeking a Data Engineer in New York to modernize our SQL Server-based data platform and migrate to Snowflake on AWS. You will design data models, build ETL/ELT pipelines, and optimize production data workflows.

You will work across both legacy SQL Server and the cloud data platform, applying Python and C# scripting, with a focus on large-scale financial data and analytics. This is a hybrid role with in-person collaboration three days per week.