- TechnoSphere
- Chicago, IL
- Full-Time
- 6 days ago
Senior Snowflake Developer.
Before you go
Before you leave us, sign up for our email alerts
We don't do job spam, just the best digital jobs delivered straight to your inbox.
Senior Snowflake Developer: our view in 3 lines...
- The Role:This role is for a senior developer who builds and optimises data solutions on the Snowflake platform to support investment accounting systems.
- The Person:The person will design and develop scalable Snowflake solutions, optimise complex SQL and data transformation processes, build ETL/ELT pipelines, and conduct code reviews while mentoring other developers.
- Requirements:The ideal candidate has 5+ years of hands-on Snowflake development experience, advanced SQL development skills, strong relational database fundamentals, and a strong understanding of dimensional modeling and SCD Type 2.
About the role
Job Title: Senior Snowflake Developer
Location: Chicago IL (Hybrid)
Job Type: Contract
We are seeking a senior, hands-on Snowflake Developer to support the Investran Snowflake implementation and related investment accounting data solutions. The role requires strong database fundamentals, data modeling expertise, advanced SQL skills, and the ability to mentor and upskill other developers through code reviews, technical guidance, and knowledge transfer.
Key Responsibilities
· Design and develop scalable solutions on Snowflake supporting Investran, General Ledger, sub-ledger, and related investment systems.
Develop, troubleshoot, and optimize complex Snowflake SQL and data transformation processes.
Design data models using dimensional modeling, SCD Type 2, Data Vault, or similar historization techniques.
Implement Snowflake-native capabilities including Streams, Tasks, Dynamic Tables, stored procedures, and Snowflake Scripting.
Analyze and improve performance using Snowflake Query Profile, warehouse configuration, micro-partition pruning, and SQL optimization techniques.
Understand and refactor existing SQL Server/T-SQL solutions into efficient Snowflake implementations.
Build and support ETL/ELT pipelines, incremental processing, data validation, and reconciliation.
Conduct code and technical design reviews, establish development standards, and demonstrate better implementation approaches through working code.
Mentor and upskill developers in SQL, database fundamentals, data modeling, Snowflake development, debugging, and performance optimization.
Develop maintainable solutions using Git, automated testing, documentation, and CI/CD practices.
Required Skills
· 5+ years of hands-on Snowflake development experience or equivalent demonstrated expertise building production Snowflake solutions.
Advanced SQL development, debugging, and performance-tuning skills.
Strong relational database fundamentals, including normalization/denormalization, keys, joins, CTEs, window functions, set-based processing, transactions, and incremental processing.
Strong understanding of dimensional modeling and SCD Type 2, including business/surrogate keys, change detection, effective dating, and maintaining historical data.
Hands-on experience with Snowflake Streams and Tasks and other Snowflake-native development capabilities.
Ability to independently troubleshoot complex data, SQL, and performance issues.
Demonstrated ability to mentor developers and improve the quality of other developers' solutions through effective code reviews and technical guidance.

