Senior Snowflake Developer – Risk Technology (Contract)

New York City, NY - USA

Monthly Salary: Not Disclosed

Posted on: 13 hours ago

Vacancies: 1 Vacancy

Job Summary

We are seeking aSenior Snowflake Developerto design optimize and enhance theMarket Risk Time Series infrastructurebuilt onSnowflake. This role requires deep expertise in Snowflake development schema design and performance tuning combined with strong Python skills and domain knowledge in market risk. The candidate will work closely with theMarket Data teamand Risk stakeholders to ensure accurate scalable and auditable data solutions for VaR and SVaR calculations.

Primary Responsibilities:

Snowflake Development

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.

Data Engineering

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.

Data Quality & Remediation

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.

Essential Experience/ Skills:

7 yearsof hands-on experience in developing applications using Relational Databases and Big-data platforms.

Snowflake Expertise

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.

Programming

Advanced Python for data engineering and integration.

Personal Attributes:

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

Lab49/ION is committed to maintaining a supportive and inclusive environment for people with diverse backgrounds and experiences. We respect the varied identities abilities cultures and traditions of the individuals who comprise our organization and recognize the value that different backgrounds and points of view bring to our business.

Lab49/ION adheres to an equal employment opportunity policy that prohibits discriminatory practices or harassment against applicants or employees based on any legally impermissible factor.

We may use artificial intelligence (AI) tools to support parts of the hiring process such as reviewing applications analyzing resumes or assessing responses. These tools assist our recruitment team but do not replace human judgment. Final hiring decisions are ultimately made by humans. If you would like more information about how your data is processed please contact us.

Required Experience:

Senior IC