Data Engineer

Data Engineer – Snowflake, AI & Application Development

Company: Confidential Global Hospitality Organization

Location: Remote (Preferably in the Greater Chicago Area)

Duration: 6+ Months

Rate: $65-$75 per hour (C2C), depending on experience

Position Overview

We are seeking an experienced Data Engineer with deep expertise in the Snowflake ecosystem, modern data pipelines, AI-enabled solutions, and backend application development. This role will be responsible for designing and developing scalable data solutions using Snowflake-native technologies , while also building applications, APIs, and AI-powered capabilities that enable enterprise data products and business processes.

The ideal candidate combines strong data engineering expertise with software engineering fundamentals and hands-on experience leveraging Snowflake Cortex AI and other artificial intelligence capabilities.

Key Responsibilities

• Design, develop, and maintain scalable Snowflake-native data pipelines supporting enterprise data and analytics workloads.
• Build data applications and services leveraging the Snowflake Native App Framework and related Snowflake capabilities.
• Develop interactive data applications and user experiences using Streamlit in Snowflake .
• Design and implement Python-based Snowpark Container Services workloads for applications, APIs, AI/ML solutions, and specialized data-processing requirements.
• Develop and optimize data ingestion, transformation, orchestration, and processing solutions within Snowflake.
• Design and implement AI-enabled solutions using Snowflake Cortex AI , including appropriate large language model and generative AI capabilities.
• Integrate AI capabilities into data applications, workflows, APIs, and enterprise business processes.
• Develop scalable backend services and APIs using object-oriented programming languages such as Python, Java, Go, and TypeScript/JavaScript .
• Design and implement RESTful APIs and application integration patterns connecting Snowflake with internal and external systems.
• Apply strong software engineering principles, including object-oriented design, modular architecture, reusable components, automated testing, version control, and CI/CD.
• Partner with data architects, application developers, data scientists, product teams, and business stakeholders to translate requirements into scalable technical solutions.
• Troubleshoot data pipelines, applications, APIs, and production workloads and identify opportunities to improve reliability, scalability, security, and performance.
• Develop technical documentation covering architecture, data flows, application components, APIs, deployment processes, and operational procedures.
• Follow enterprise standards for data security, access management, governance, observability, and software development.

Required Qualifications

• 4+ years of strong hands-on data engineering experience , including significant experience developing solutions on Snowflake.
• 4+ years of experience with Snowflake-native data pipelines and data engineering capabilities.
• Strong hands-on experience with the Snowflake Native App Framework and development of applications within the Snowflake ecosystem.
• Experience developing applications using Streamlit , preferably Streamlit in Snowflake.
• Hands-on experience with Snowpark Container Services , including development and deployment of Python-based containerized workloads.
• 2+ years of experience developing or implementing AI-enabled solutions , including generative AI, machine learning, or LLM-based capabilities.
• Hands-on experience with Snowflake Cortex AI , including incorporating Cortex capabilities into enterprise data or application solutions.
• 4+ years of demonstrated application and backend API development experience using object-oriented programming and one or more of the following:
• Python
• Java
• Go
• TypeScript/JavaScript
• Strong Python development skills, particularly for data processing, application development, APIs, and Snowflake workloads.
• Experience designing and developing REST APIs, backend services, and application integrations .
• Strong SQL skills and experience working with complex enterprise datasets.
• Solid understanding of object-oriented programming, software design patterns, API architecture, and modern application-development practices.
• Experience with Git-based source control and modern CI/CD practices.

Preferred Qualifications

• Experience with additional Snowflake capabilities such as Snowpark, Streams, Tasks, Dynamic Tables, Snowpipe, and Snowpipe Streaming .
• Experience building production-grade generative AI or LLM applications.
• Knowledge of RAG (Retrieval-Augmented Generation), embeddings, vector search, prompt engineering, and AI application architecture .
• Experience integrating Snowflake Cortex AI with enterprise applications and data products.
• Experience designing containerized applications and working with Docker or Kubernetes concepts.
• Knowledge of cloud platforms such as AWS, Azure, or Google Cloud.
• Experience with enterprise data architecture, data modeling, data governance, and data security.
• Experience working in Agile/Scrum software development environments.

Key Skills

Snowflake Data Engineering: Advanced Snowflake development, native pipelines, Snowpark, Streams, Tasks, Dynamic Tables, Snowpipe, and performance optimization.

Snowflake Application Development: Snowflake Native Apps, Streamlit in Snowflake, Snowpark Container Services, and application architecture.

Artificial Intelligence: Snowflake Cortex AI, generative AI/LLMs, AI application integration, and intelligent data processing.

Software & API Engineering: Python, Java, Go, TypeScript/JavaScript, object-oriented programming, REST APIs, backend services, and application integration.

Enterprise Engineering Practices: Git, CI/CD, testing, security, observability, documentation, and scalable solution design.