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

Snowflake Data Engineer

$150k
Temporary

Business Centric Technology

Our Addison, TX-based client is seeking a Data Engineer to build and maintain data pipelines for a cloud-native analytics platform on Azure and Snowflake. Responsibilities include data ingestion, transformation using Bronze/Silver/Gold medallion architecture, and production reliability. The role is initially fully onsite, with potential for two remote days per week after a few months and is available as a six-month contract-to-hire or direct hire.

COMP: Up to $150K, dependent on candidate's experience

WHAT OUR CLIENT OFFERS:

  • Competitive salary with performance-based bonus opportunities
  • Comprehensive health, dental, and vision insurance
  • 401(k) plan with 3% non-discretionary company contribution
  • Paid holidays, PTO, and professional development support
  • A collaborative and growth-oriented work environment

WHAT YOU'LL DO:

  • Build and maintain ELT pipelines in Azure Data Factory (ADF) ingesting data disparate data sources into Azure Data Lake Storage Gen2.
  • Implement Snowflake Bronze Silver Gold layer transformations: incremental loads, SCD Type 2, and fact/dimension modeling aligned to business requirements.
  • Write and optimize T-SQL against SQL Server for performant source extraction without disrupting operational workloads.
  • Maintain pipeline monitoring, alerting, and error recovery - pipelines support 24/7 revenue operations and uptime matters.
  • Handle PHI/PII data in full compliance with HIPAA: field masking, access controls, and audit-ready data handling at every layer.
  • Collaborate with our AI/ML engineer to ensure Silver-layer data structures are ML-ready and consistently documented.

WHAT YOU'LL BRING:

  • Bachelor's degree in Computer Science, Information Systems, or equivalent experience.
  • 5 8+ years of data engineering experience, including 2+ years with Azure and hands-on production experience with Azure Data Factory, ADLS Gen2, and Snowflake.
  • Strong SQL Server/T-SQL skills, including complex queries, CTEs, window functions, and SCD Type 2, plus experience with Snowflake tasks, streams, incremental loading, query optimization, and RBAC.
  • Strong understanding of ETL/ELT patterns, idempotency, error handling, and working with regulated data (HIPAA, PCI, or similar).
  • Preferred: Healthcare data experience, Python for data transformation and pipeline testing, dbt for Silver/Gold layer management, and Azure DevOps/CI/CD for pipeline deployment.

APPLY TODAY! CP # 8595

Vacancy posted 3 days ago
Similar jobs that could be interesting for youBased on the Snowflake Data Engineer in Addison, IL vacancy
  •  ...The Data Analyst leverages deep expertise in statistical analysis, data modeling, and visualization to partner with business operations...  ...and building AI-ready semantic layers within the AWS Snowflake environment. Responsibilities Duties and Responsibilities include... 
    Suggested
    Work experience placement
    Local area

    e.biT Consulting

    Schaumburg, IL
    23 hours ago
  • $150k - $170k

    DescriptionWe are seeking a Solution Architect & Data Engineer to help design, build, and scale a strategic market analytics platform serving...  ...Data integration and ETL/ELT development (Spark/Databricks, Snowflake, Kafka, and cloud-native services) | Data modeling and... 
    Suggested
    Full time
    Temporary work
    Work at office
    Immediate start
    Remote work
    Relocation

    AAR

    Wood Dale, IL
    15 hours ago
  • $99k - $164.8k

     ...Position Summary: We are seeking a highly skilled Senior Data Engineer to guide the design, development, and delivery of our enterprise...  ...platforms. This role requires deep technical expertise with Snowflake, Core AWS Services, cloud-based architecture, and modern data... 
    Suggested
    Full time
    Temporary work
    For contractors
    Casual work
    Work at office
    Local area
    Remote work

    Kemper

    Downers Grove, IL
    2 days ago
  •  ...Job Description Job Description Summary: The engineer in this position should have a wealth of experience engineering/installing...  ...cohesive package. This would include the complete engineering of data centers including, but not limited to, infrastructure, overhead... 
    Suggested
    For contractors
    Work at office
    Local area

    ADEX

    Elk Grove Village, IL
    23 hours ago
  •  ...Position Title: Infrastructure Engineer Sr Position Location: on-site 4 days in office ~ Itasca, IL 60143 WORK ARRANGEMENT:...  ...Sunday – Wednesday WORKING HOURS: 3:00 PM - 1:30 AM EST The Data Center team oversees the design, build, operation, and... 
    Suggested
    Work at office
    Remote work
    Flexible hours
    Night shift

    Consulting Solutions

    Itasca, IL
    4 days ago
  • $90k - $105k

     ...Data & Analytics Engineer Opportunity At GoEngineer, data connects nearly every part of the business. We're looking for a Data & Analytics...  ...solving. You won't spend your days building massive Spark or Snowflake pipelines. Instead, you'll dig into how systems connect,... 
    Temporary work

    Computer Aided Technology (CATI) (Now GoEngineer)

    Arlington Heights, IL
    1 day ago
  • $91.7k - $163.7k

     ...Senior Data Engineer / Senior Database Administrator Optum is a global organization that delivers care, aided by technology to help...  ...database performance tuning, implement task automation, manage Snowflake administration and security, and collaborate with cross-functional... 
    Minimum wage
    Full time
    Work experience placement
    Local area
    Flexible hours

    divvyDOSE

    Schaumburg, IL
    23 hours ago
  •  ...and leads with purpose. How you'll make an impactThe Lead Data Solution and AI Engineer developer provides guidance, leadership, and solid...  ...database and application performance tuningExperience in Snowflake and Microsoft Fabric a plusBachelor’s degree in computer... 
    Local area

    Arthur J. Gallagher & Co.

    Rolling Meadows, IL
    23 hours ago
  • $86k - $115k

     ...Tuesday's in Schaumburg office**Objective of Position: The Data Analytics Engineer is responsible for analyzing, designing, developing, and implementing...  ...implement database models (Relational, Dimensional, Star/Snowflake schema).Prepare process and data flow diagrams.Develop... 
    Work at office
    Remote work

    Byline Bank

    Schaumburg, IL
    3 days ago
  • $90k - $110k

     ...Lisle, IllinoisCompany: MolexCareer Field: Data & AnalyticsJob Number: 193720Apply:...  ...seeking an experienced AI Data Analytics Engineer to accelerate data-driven engineering across...  ...warehousing / columnar stores (BigQuery, Redshift, Snowflake) or time-series DBs (TimescaleDB,... 
    Flexible hours

    Molex

    Lisle, IL
    3 days ago
  •  ...for our very own DoD SkillBridge Fellowship Program, supporting Data Center Operations and Critical Facilities. The training will be...  ...'s degree or relevant experience w/1-4 years in Mechanical Engineering or related fieldComprehensive knowledge of critical infrastructure... 
    Contract work
    Traineeship
    Internship
    Work at office

    Navstar

    Elk Grove Village, IL
    2 days ago
  • $99k - $164.8k

     ...delivers on our promises.POSITION SUMMARY:Kemper is seeking a Data Quality Engineer specializing in Data Testing and Quality Engineering to...  ...analytics, and business applications using SQL, Informatica, IICS, Snowflake, and Python.Data Validation and Quality AssuranceDevelop... 
    Full time
    Work experience placement
    Work at office
    Local area
    Remote work

    Kemper Corporation

    Downers Grove, IL
    4 days ago
  • $120k - $150k

     ...Information Systems & TechnologyJob Number: 195632Apply: JobAs a Data & AI Solutions Engineer at Molex, you will be a vital contributor to our...  ...maintain, and optimize data pipelines using tools such as Snowflake, AWS Glue, and Lambda. Design and implement data modeling... 
    Flexible hours

    Molex

    Lisle, IL
    4 days ago
  •  ...Datacenter Operations Engineer Sprout is a rapidly growing IT Asset Disposition (ITAD) provider and electronics recycler. We are a growing...  ...ERP platform to manage our business. Sprout leverages data and analytics to make IT asset disposition flawless for the world... 
    Contract work
    Remote work

    SMR | Worldwide

    Elk Grove Village, IL
    23 hours ago
  •  ...Job Description Job Description Seeking a Data Center Technician/Data Center Engineer to be part of a team responsible for the continuous operation and performance of Client's Data Centers. The person in this position will be part of a team responsible for all parts... 
    Full time
    For contractors
    Work experience placement
    H1b
    Local area
    Remote work
    Work visa

    Ampcus Incorporated

    Elk Grove Village, IL
    2 days ago
  •  ...That’s what it means to live The Gallagher Way.OverviewThe Data Engineering Manager owns the design, delivery, and operation of the data...  ...-native tooling such as Azure Data Factory, Databricks, and Snowflake.Construct and maintain enterprise-level integrations across... 
    Permanent employment
    Local area

    Arthur J. Gallagher & Co.

    Palatine, IL
    4 days ago
  • $120k

     ...Data Engineer Location: Hybrid – 2–3 days onsite, Tuesday–Thursday in the Chicago Suburbs Compensation: Up to $120K Benefits - Medical, Dental, PTO eligiable, Life Our client a well established organization is seeking a hands-on Data Engineer to support data... 

    Addison Group

    Schaumburg, IL
    2 days ago
  •  ...Lead Software/Data Engineer Location - Schaumburg IL or Remote In the role of Lead Software Engineer, you will work independently and in a team as needed, in developing new features to build new products and enhance our applications as needed. Our platforms are primarily... 
    Work experience placement
    Remote work

    Samprasoft

    Schaumburg, IL
    23 hours ago
  • $80k - $120k

    ResponsibilitiesWe are seeking a highly motivated Snowflake/dbt/Power BI Analyst to join our growing Data & Analytics team. This is a hands-on role for a technically...  ...4+ years of hands-on experience in data engineering, analytics engineering, business intelligence, or... 
    Full time
    Temporary work
    Flexible hours

    Sentinel Technologies

    Downers Grove, IL
    4 days ago
  • $45 - $55 per hour

     ...Job Description Job Description Data Engineer - New York, NY - Contract - $45-55 per HRDescription Join a dynamic team leading a finance data modernization project for a global reinsurer. Based in New York, this hybrid contract role involves spearheading workshops... 
    Contract work

    Mitchell Martin

    Des Plaines, IL
    21 days ago
  •  ...That’s what it means to live The Gallagher Way.OverviewThe Data Engineering Lead is a hands-on technical leader responsible for designing...  ...reliable data engineering frameworks and pipelines.Work across Snowflake, Azure Data Factory, Databricks, Spark, ADLS Gen2, Azure... 
    Permanent employment
    Local area

    Arthur J. Gallagher & Co.

    Palatine, IL
    3 days ago
  •  ...job board, applicant tracking, and client data into information our clients use to hire better and spend smarter. The Data Engineer owns the ingestion, transformation, and architecture...  ...ingestion, dbt for transformation, Snowflake as our central warehouse, and AWS for... 
    Full time

    Shaker Recruitment Marketing

    Oak Park, IL
    3 hours ago
  •  ...sustainable transportation solutions powered by digital innovation, data, and AI. We are investing in the technologies, products, and...  ...our industry.We have an exciting opportunity for a Senior Data Engineer & Data Scientist - Commercial Intelligence to help build the data... 
    Permanent employment
    Full time
    H1b
    Work at office
    Remote work
    Visa sponsorship
    Monday to Thursday

    International Motors

    Lisle, IL
    3 days ago
  • $167k - $202.3k

     ...manufacturing platform, MISUMI Americas empowers engineers and procurement teams to accelerate...  ...companies in the Americas. Senior Data Engineer - Schaumburg MISUMI | Data...  ...Data Engineer to be the go-to owner of our Snowflake warehouse, dbt project, and data... 
    Remote work

    Fictiv

    Schaumburg, IL
    28 days ago
  •  ...Position Overview Join our Pipeline Team as a Senior Data Engineer - a role designed for a software engineer who thrives at the...  ...modular design, and automated testing) to solve complex puzzles in Snowflake optimization and native data-tier security.  Primary... 
    Remote work
    Worldwide

    Paylocity

    Schaumburg, IL
    2 days ago
  • $150k - $180k

    Descriptiona leading professional services firm that specializes in real estate and investment management. hiring 4 Data Engineers as an effort to invest in on shore full time talent. This talent is to sit with business stakeholders in the US, to work on producing AI Agents... 
    Permanent employment
    Full time
    Shift work

    TEKsystems

    Westmont, IL
    23 hours ago
  •  ...HybridSchedule: Full timePosted: 2026-10-28Minimum Salary: $142,530Maximum Salary: $178,110About the RoleIAA is seeking a Senior Staff Data Engineer to be a senior individual contributor and technical leader within our data engineering function. This is a hands-on, deeply... 
    Full time
    Worldwide

    RB Global

    Westchester, IL
    3 days ago
  •  ...Must Have Experience with Power Platform (Power Automate, Power Apps), Copilot Studio, and Visual Studio Code Proficiency in data analytics and Power BI Skills in process automation and solution development Microsoft 365 and SharePoint integration... 
    Full time
    Remote work

    LanceSoft Inc

    Oak Brook, IL
    2 days ago
  • $111.12k

     ...Data Scientist Join KEYENCE as a Data Scientist Location: Keyence U.S. Headquarters – Itasca, IL Total Compensation (Base + Bonus...  .... Build reliable data pipelines and reusable tools with solid engineering practices (Git, testing, documentation, CI/CD). Own solutions from... 

    KEYENCE Corporation OF AMERICA

    Itasca, IL
    3 days ago
  •  ...Quantitative ResearcherEssential Requirements:Master's or PhD in a quantitative field such as Mathematics, Statistics, Physics, Financial Engineering, or a related discipline.2+ years of experience in quantitative research within trading or a related field.Strong proficiency in... 

    Goliath Partners LP

    Elmhurst, IL
    2 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Snowflake Data Engineer. Be the first to apply!