Contract Role: Senior Snowflake Developer_ Chicago IL (Hybrid)
TechnoSphere, Inc.
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.
$148.75k - $192.5k
...team connection, this role follows a four day in office... ...a team of seasoned developers, technologists, and quants... ...communication with senior managers and technical... ..., $130,900-$169,400 in Chicago, and $148,750-$192,500... ...SummaryLocation: Chicago, IL; Overland Park OPX; New...SeniorFull timeWork at office- ...to hire for the below role. Project... ...Implementation Location: Chicago IL (downtown) | Hybrid 2 days/week onsite... ...Duration: 6 months plus contract Pay rate: $56/HR... ...Project Manager will: Develop and maintain a... ...in collaboration with senior management and stakeholders...Contract workSeniorFull timeTemporary workFor contractorsWork experience placementWork at officeLocal area2 days per week
$200k - $250k
...Circana. Learn more at Role OverviewCircana is... ...the engineers other senior engineers turn to. When... ...context management, tool contracts and MCP servers,... ...to-deploy pipelines, developer platforms.Prior forward... ...following area(s): Chicago, IL (Hybrid) or NYC, NY (Hybrid)The...SuggestedFull timeLocal areaFlexible hoursShift work$155k - $180k
...Intelligence team is hiring a Senior Manager, Software Engineering... ...Infrastructure organization. In this role, you will lead a distributed... ...: Candidate must be in the Chicago office 3 times a week.#LI-MP2... ...clearance as required by government contract.Travel RequirementsUnder 10%...Contract workSeniorFull timeWork at officeRemote workRelocation- ...Role: Oracle PL/SQL Developer Location: Chicago, IL (3 days Onsite/week) Duration: 24+ Months W2 Only - ANY VISA Work authorization: Any work... ...our customers' requirements. Experience Level: Senior Qualifications: A Bachelor's degree...Contract workLocal area3 days per week
- ...Role: ServiceNow ATF Tester Location: Chicago, IL - Onsite Long Term Contract - W2 / C2C Job Description: We are looking for a highly skilled ServiceNow... ...Key Responsibilities: Design, develop, and maintain automated test scripts using...Contract workLong term contract
- NETPACE Health in Chicago, IL is seeking a Talent Acquisition Specialist for a 12-month hybrid contract. You will own full-cycle recruiting, source and assess candidates, and partner with hiring managers to shape hiring plans, with a focus on sales professionals. Candidates...Contract workSenior
- Chicago, IllinoisHybridFull Time$120k - $140kA high-performing insurance... ...is seeking a talented Senior Software Developer to join its growing... ...development tools.This is a hybrid position requiring onsite attendance... ...South Chicago suburbs. This role is ideal for a highly...SeniorFull time
- Chicago, IllinoisHybridFull Time$150k - $200kA rapidly growing, technology-driven company... ...improve how teams operate day to day. This role is ideal for an engineer who wants to go... ...Insurance Vacation Time401kRegular Hybrid Schedule with additional WFH allotments...SeniorFull timeWork from home
$150k - $190k
...Circana. Learn more at Role OverviewWe are seeking an experienced Senior DevOps Engineer to design... ...operational excellence in hybrid infrastructure... ...and infrastructure teams.Develop and manage CI/CD pipelines... ...the following area(s): Chicago, IL (Hybrid) or NYC, NY (Hybrid...Full timeLocal areaFlexible hoursShift work- Chicago, IllinoisRemote LocalFull Time$170k - $200kLooking for an opportunity where you... ...anywhere in the United States or hybrid in Chicago, IL. You'll work with cutting-edge technologies... ...providers nationwide. What makes this role stand out is the chance to help build an...Full timeImmediate startRemote workFlexible hours
- ...would also appreciate if you can recommend me someone looking for a similar role. Job Title : Content manager Location : Chicago, Illinois (Hybrid role) Duration : 12 +months Contract Interview : Video Job Description- Must-Haves ~7+ years of...Contract workFor contractorsFlexible hours
$160k - $200k
...experience working at Circana. Learn more at Role OverviewCircana is building an agentic... ...be located in the following area(s): Chicago, IL (Hybrid) or NYC, NY (Hybrid)The below range... ...qualifications, certifications, experience, skills, seniority, geographic location, performance,...Full timeLocal areaFlexible hoursShift work$125k - $140k
...the Jesse Brown VA Medical Center (VAMC), Chicago, IL Electronic Health Record Modernization (... ...Review and interpret construction contract documents, drawings, and specifications.... ...Qualifications to be successful in the role: Bachelor's degree in Architecture...Contract workSeniorFull timeTemporary workWorldwide$150k - $175k
...Senior Data & AI Engineer | Python, Snowflake, dbt & Machine Learning Location: Downtown Chicago, IL | Hybrid, 3 Days Onsite Per Week Employment Type:... ...a hands-on engineering role, not simply a data analytics... ...Experience designing, developing, and maintaining...SeniorFull timeRemote workVisa sponsorship2 days per week3 days per week$96.26k - $137.66k
...collaborative and driven Senior Data Engineer to... ...Manager, this role is responsible for... ...experience with Snowflake or a similar cloud... ...care leaveFlexible & hybrid work... ...goal is to attract, develop and retain the best... ...SummaryLocation: Peoria, IL; Chicago, ILType: Full timeSeniorFull timeWork at officeLocal area- ...Senior AI Data Engineer (Cloud) Location: Chicago, IL Schedule: Full-time, 40 hours/week Type: Contract Overview We are looking... ...capabilities. This role will work... ...pipelines using Snowflake, AWS, and Python... ...hands-on experience developing and deploying production...Contract workSeniorFull time
$160k - $200k
...States / New York / Chicago,IL / San... ...highly skilled Mid-to-Senior Backend Engineer to... ...prediction ecosystem.This role demands an... ...RESPONSIBILITIESDesign, develop, and optimize robust... ...-work hour and hybrid set-upAspire career... ...and cultural event contracts.Make your call now...Contract workSeniorFull timeWorldwide- The American Medical Association (AMA) seeks a Senior Contracts Coordinator II for a hybrid role in Chicago, IL. The role supports the Finance team by managing contract intake, review, workflow coordination, and lifecycle activities within the CLM system. Responsibilities...Contract workSeniorWork at office
$280k
...Firm Software / SaaS | Irvine (Hybrid), Chicago (Remote), New York City (Remote) | CA, IL, NY | $280,000 Treeline, Inc.,... ...B2B SaaS company that has developed a specialized virtual collaboration... ...record in a full-cycle closing role (Account Executive) with proven...SeniorRemote job$136k - $160k
...truly value. Overview Senior Associate Data Engineering - Chicago Hybrid As a Senior... ...responsible for designing, developing, and maintaining... ..., and data contract rigor to context and... .... Experience with Snowflake and zero-copy architecture... ...required for the role. Benefits of...Contract workSenior$164.7k - $266k
...in e-signature and contract lifecycle... ...Docusign is seeking a Senior Software Engineer... ...Cloud Platform. This role focuses on the platforms... ...Designation Hybrid:Employee divides... ...record of enhancing developer experience via... ...San Francisco | US-IL-Chicago | US-WA-SeattleCategory...Contract workSeniorWork at officeLocal areaRemote work2 days per week- ...W2 Role | Healthcare experience is preferred. Sr. AI Engineer Chicago, IL (Full Onsite) AI Engineer with strong hands-on experience in prompt engineering, LLM... ...solutions. Key Responsibilities: Design, develop, and optimize prompts for Large Language Models...Senior
- Chicago, Illinois100% RemoteFull Time$150k - $200kA rapidly growing healthcare technology company is seeking a Senior Software Engineer to join their fully remote engineering team. This role is ideal for an engineer with strong AWS, DevOps, cloud infrastructure, and software...SeniorRemote workFlexible hours
$100k - $120k
...and give them better quality of life. We develop breakthrough therapies for an impactful... ...Location / TypeThis is a remote, field-based role supporting a high volume of accounts in... ...or near one of the following cities: Chicago, IL or Minneapolis, MN. Additional regional...Minimum wageOngoing contractFull timeWork at officeLocal areaRemote workWorldwideNight shift- ...To $180K+ Incentives – Chicago, IL – Job # 3630 Who We... ...fill a Sr. C&I Lender role located in the Chicago... ...candidate will also assist senior officers in handling... ...include: Developing and managing commercial... ...(Accounting Software; Contract Management Systems; Development...Contract workSeniorWork at office
- ...Greenwich, CT, USA; Chicago, IL, USAPay: USD 180000 -... ...and others. This is Hybrid role (3 days in office /2... ...We are looking for a senior software engineer who... ...will work directly with developers and data scientists,... ...integration, performance, and contract testing for...Contract workSeniorTemporary workWork at officeRemote workWorldwideFlexible hours
$61.8k - $82.03k
Senior Contracts Coordinator II (Hybrid) Chicago, IL, United States The American Medical Association (AMA) is the nation... ...& Process Improvement Develops, maintains, and communicates contract... ...transportation in Chicago. This role is an exempt position, and the salary...Contract workSeniorWork experience placementWork at office3 days per week$106.9k - $147k
...communityHumana is seeking a Senior DevOps Platform... ...and GCP. This role is responsible for... ..., automation, and developer self-service... ...Department of Defense contract requires U.S.... ...To ensure Home or Hybrid Home/Office employees... ...Fort Lauderdale, FL; Chicago, IL; Frisco, TX;...Contract workSeniorFull timeTemporary workApprenticeshipWork at officeRemote workWork from homeHome office$65 - $75 per hour
...Senior Power BI Developer (Microsoft Fabric) Location: Chicago, IL (Hybrid – onsite a few times per month) Other Locations Considered... ...MO, PA, VA Position Type: Contract-to-Hire Contract Duration:... ...is a senior-level development role focused on designing, developing...Contract workSeniorHourly payFull timeRemote work
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Contract Role: Senior Snowflake Developer_ Chicago IL (Hybrid). Be the first to apply!
- remote contract web developer Chicago, IL
- senior living Chicago, IL
- senior trade analyst Chicago, IL
- senior accountant manufacturing Chicago, IL
- senior manager customer operations Chicago, IL
- senior director information security Chicago, IL
- senior full stack web developer Chicago, IL
- senior technical director Chicago, IL
- senior service engineer Chicago, IL
- senior environment artist Chicago, IL




