The Role
The Senior Snowflake Developer will design and enhance Market Risk Time Series infrastructure on Snowflake, focusing on performance tuning, ETL/ELT pipelines, and ensuring data quality for risk calculations.
Summary Generated by Built In
We are seeking a Senior Snowflake Developer to design, optimize, and enhance the Market Risk Time Series infrastructure built on Snowflake. 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 the Market Data team and Risk stakeholders to ensure accurate, scalable, and auditable data solutions for VaR and SVaR calculations.
Primary Responsibilities:
- Snowflake Development
- Data Engineering
- Data Quality & Remediation
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.
Essential Experience/ Skills:
- 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.
Snowflake Expertise
Programming
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.
Top Skills
Python
Snowflake
Snowpark
SQL
Am I A Good Fit?
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.
Success! Refresh the page to see how your skills align with this role.
The Company
What We Do
Serving Luxembourg's IT needs since 2002, ION Group has focused its activities on 3 pillars:
ION Home: IT services for home users.
- Computer repair and maintenance
- Network Setup
- Internet Setup
- Email and Hosting Services
ION Pro: Maintenance for small and medium businesses
- Server maintenance and setup
- Network configuration and security
- Workstation
- Server and services hosting and housing
ION Development
- Website design and development
- Custom application development (Web, Mobile, iOS, Android)
- OpenSource software modifications
