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.
· 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.
Thanks & Regards
Krishna
Code Hut IT Solutions
Consulting – Development – Staffing
Email: krish@codehutit.com