Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

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.

Vacancy posted 1 day ago
Similar jobs that could be interesting for youBased on the Contract Role: Senior Snowflake Developer_ Chicago IL (Hybrid) in Chicago, IL vacancy
  • $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... 
    Senior
    Full time
    Work at office

    Cboe Exchange

    Chicago, IL
    2 days ago
  •  ...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 work
    Senior
    Full time
    Temporary work
    For contractors
    Work experience placement
    Work at office
    Local area
    2 days per week

    Alpha Business Solutions

    Chicago, IL
    4 days ago
  • $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... 
    Suggested
    Full time
    Local area
    Flexible hours
    Shift work

    Circana

    Chicago, IL
    5 days ago
  • $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 work
    Senior
    Full time
    Work at office
    Remote work
    Relocation

    Indigo Vision

    Chicago, IL
    3 days ago
  •  ...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 work
    Local area
    3 days per week

    HYR GLOBAL SOURCE INC

    Chicago, IL
    3 days ago
  •  ...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 work
    Long term contract

    AceStack LLC

    Chicago, IL
    1 day ago
  • 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 work
    Senior

    NETPACE Health

    Chicago, IL
    4 days ago
  • 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... 
    Senior
    Full time

    Motion Recruitment

    Chicago, IL
    2 days ago
  • 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... 
    Senior
    Full time
    Work from home

    Motion Recruitment

    Chicago, IL
    4 days ago
  • $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 time
    Local area
    Flexible hours
    Shift work

    Circana

    Chicago, IL
    5 days ago
  • 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 time
    Immediate start
    Remote work
    Flexible hours

    Motion Recruitment

    Chicago, IL
    1 day ago
  •  ...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 work
    For contractors
    Flexible hours

    JS Consulting Solutions

    Chicago, IL
    2 days ago
  • $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 time
    Local area
    Flexible hours
    Shift work

    Circana

    Chicago, IL
    5 days ago
  • $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 work
    Senior
    Full time
    Temporary work
    Worldwide

    Planate Management Group

    Chicago, IL
    5 days ago
  • $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... 
    Senior
    Full time
    Remote work
    Visa sponsorship
    2 days per week
    3 days per week

    TalentFish

    Chicago, IL
    1 day ago
  • $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 time
    Senior
    Full time
    Work at office
    Local area

    RLI Corp

    Chicago, IL
    3 days ago
  •  ...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 work
    Senior
    Full time

    Forbes Technical Consulting

    Chicago, IL
    22 days ago
  • $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 work
    Senior
    Full time
    Worldwide

    Crypto.com

    Chicago, IL
    3 days ago
  • 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 work
    Senior
    Work at office

    American Medical Association

    Chicago, IL
    3 days ago
  • $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... 
    Senior
    Remote job

    Treeline, Inc.

    Chicago, IL
    5 days ago
  • $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 work
    Senior

    Publicis Groupe

    Chicago, IL
    14 days ago
  • $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 work
    Senior
    Work at office
    Local area
    Remote work
    2 days per week

    DocuSign

    Chicago, IL
    2 days ago
  •  ...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

    SharpAtoms

    Chicago, IL
    1 day ago
  • 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... 
    Senior
    Remote work
    Flexible hours

    Motion Recruitment

    Chicago, IL
    2 days ago
  • $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 wage
    Ongoing contract
    Full time
    Work at office
    Local area
    Remote work
    Worldwide
    Night shift

    ZOLL Medical Corporation

    Chicago, IL
    3 days ago
  •  ...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 work
    Senior
    Work at office

    The Symicor Group

    Chicago, IL
    1 day ago
  •  ...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 work
    Senior
    Temporary work
    Work at office
    Remote work
    Worldwide
    Flexible hours

    Interactive Brokers

    Chicago, IL
    1 day ago
  • $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 work
    Senior
    Work experience placement
    Work at office
    3 days per week

    American Medical Association

    Chicago, IL
    3 days ago
  • $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 work
    Senior
    Full time
    Temporary work
    Apprenticeship
    Work at office
    Remote work
    Work from home
    Home office

    Humana

    Chicago, IL
    4 days ago
  • $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 work
    Senior
    Hourly pay
    Full time
    Remote work

    Resource 1, Inc.

    Chicago, IL
    1 day ago

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!