Apply on Employer Site

ION · 2 days ago

Senior Snowflake Developer – Risk Technology (Contract)

New York, United States

Contract

Onsite

Senior Level

7+ years exp

ION is seeking a Senior Snowflake Developer to design, optimize, and enhance the Market Risk Time Series infrastructure built on Snowflake. The role involves deep expertise in Snowflake development, schema design, and performance tuning, along with strong Python skills to ensure accurate and scalable data solutions for risk calculations.

AccountingAsset ManagementFinanceFinancial ServicesSoftware

H1B Sponsor Likely

Responsibilities

Design and implement efficient and bi-temporal schemas leveraging micro-partitioning and clustering keys for optimal performance

Develop and optimize SQL queries, stored procedures, and Snowpark-based transformations

Implement query performance tuning and cost optimization strategies

Build and maintain Python-based ETL/ELT pipelines for sourcing historical market data from internal and external providers

Integrate with quant libraries to identify data quality issues and validate risk inputs

Detect and remediate common data quality issues (gaps, stale data, outliers)

Implement algorithms for gap-filling, back-filling, and anomaly correction to ensure data is fit for VaR and SVaR calculations

Qualification

SnowflakeSQLPythonSchema designData engineeringAnalytical skillsProblem-solvingCommunication skillsTime management

Required

7+ years of hands-on experience in developing applications using Relational Databases and Big-data platforms

Strong experience in schema design, micro-partitioning, clustering, and query optimization

Proficiency in Snowpark and stored procedures

Expert-level SQL for complex queries and performance tuning

Advanced Python for data engineering and integration

Strong analytical and problem-solving skills, including the ability to troubleshoot and resolve complex data related issues

Strong verbal and written communication skills

Self-starter and entrepreneurial in approach

Ability to escalate and follow-up proactively

Good time management skills

Company

ION

Glassdoor3.3

ION Group provides solutions for electronic trading, position management, pricing, risk management, and downstream processing for clients.

Founded in 1998

New York, New York, USA

10001+ employees

https://iongroup.com

H1B Sponsorship

ION has a track record of offering H1B sponsorships. Please note that this does not guarantee sponsorship for this specific role. Below presents additional info for your reference. (Data Powered by US Department of Labor)

Distribution of Different Job Fields Receiving Sponsorship

Represents job field similar to this job

Trends of Total Sponsorships

2025 (2)

2024 (1)

2022 (2)

2021 (4)