Get all C2C Jobs / hotlists 🔥 Alerts

Senior Snowflake Developer with experience in Investment Accounting / Investran || Chicago, IL || Hybrid ||

Role: Senior Snowflake Developer with experience in Investment Accounting / Investran

Work Location: Chicago IL (Hybrid)

Duration: Long term contract

Client: Confidential

 

Max & Final Rate: $62/hr. on C2C

Immediate Interview 

 

Job Description:

·       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.

 

Highly Desirable:

·       Data Vault / Data Vault 2.0 experience. Candidates with strong SCD Type 2 and historization experience but no direct Data Vault experience will also be considered.

·       Strong SQL Server/T-SQL experience, particularly complex stored procedures, temporary tables, execution plans, and migration/refactoring of SQL Server workloads to Snowflake.

·       Python for data processing, automation, and testing.

·       Git and CI/CD experience, preferably Azure DevOps.

·       REST API integration.

·       Experience with Investran, investment accounting, private markets, or financial data.

·       Bachelor's degree in Computer Science, Engineering, or equivalent professional experience.

 


Email is the Best Way to Reach Me 

Thanks & Regards

Krishna

Code Hut IT Solutions

Consulting – Development – Staffing

Email:  krish@codehutit.com       

7751 Belfort Parkway, STE 200 Jacksonville FL 32256

:
:
:
    
🔔 Get our daily C2C jobs / Hotlist notifications on 

   

About Author

I’m Monica Kerry, a passionate SEO and Digital Marketing Specialist with over 9 years of experience helping businesses grow their online presence. From SEO strategy, keyword research, content optimization, and link building to social media marketing and PPC campaigns, I specialize in driving organic traffic, boosting rankings, and increasing conversions. My mission is to empower brands with result-oriented digital marketing solutions that deliver measurable success.

Leave a Reply

Your email address will not be published. Required fields are marked *

×

Post your C2C job instantly

Quick & easy posting in 10 seconds

Keep it concise - you can add details later
Please use your company/professional email address
Simple math question to prevent spam