Snowflake Data Engineer with AI/ML | TekisHub | Plano, TX

TekisHub Consulting Services LLC; Plano (TX); On-site; USD 120,000 - 150,000; Full time

Job summary

TekisHub Consulting Services LLC in Plano, TX is seeking a Snowflake Data Engineer with AI/ML expertise to design, build, and scale data pipelines, modern data warehouses, and GenAI workflows using Snowflake, DBT, SQL, and Python. This onsite contract role requires hands-on architectural leadership and immediate availability.

You will own end-to-end data solutions, implement RAG pipelines and vector databases, optimize performance, and collaborate with data scientists and software engineers to

Qualifications

• Minimum 5+ years of data engineering, software engineering, or analytics experience.
• Strong Snowflake data warehousing and SQL performance tuning expertise.
• Hands-on DBT development and Python data pipelines.
• Experience with AI/ML, GenAI, RAG frameworks, and vector databases.

Responsibilities

• Design, build, optimize, and maintain scalable cloud data pipelines and modern data warehouses using Snowflake.
• Develop data transformations with DBT and advanced SQL.
• Write clean Python code for data processing and orchestration.
• Implement GenAI and Retrieval-Augmented Generation pipelines.
• Integrate vector databases to support semantic search and LLM embeddings.
• Troubleshoot ingestion bottlenecks and performance issues across cloud environments.
• Collaborate with data science and software teams to productionize ML models.
• Ensure data governance and security best practices in cloud computing.

Skills

Snowflake data warehousing

SQL performance tuning

DBT

Python

AI/ML

RAG pipelines

Vector databases

Cloud data engineering

Cross-functional collaboration

Tools

DBT

Snowflake

Apache Airflow

Job description

Position Summary

TekisHub is actively seeking a skilled and experienced Snowflake Data Engineer with AI/ML expertise to join our client team in Plano, TX on a full-time onsite contract basis (C2C). In this cutting-edge data and artificial intelligence role, you will be responsible for designing, building, and scaling robust data pipelines, modern data warehousing architectures, and advanced GenAI integration workflows utilizing Snowflake, DBT, SQL, and Python. You will bridge traditional data engineering with next-generation artificial intelligence, implementing Retrieval-Augmented Generation (RAG) pipelines and vector database integrations. This opportunity requires an innovative data professional with strong cloud data engineering fundamentals and immediate availability.

Detailed Job Description

As a Snowflake Data Engineer with AI/ML at TekisHub, you will take full ownership of architecting high-performance cloud data solutions and AI-driven data pipelines in Plano, TX. Your day-to-day responsibilities include developing modular data transformations using DBT, writing optimized SQL and Python scripts, and managing Snowflake data warehouses and data lakes. You will integrate modern AI/ML models, build generative AI applications, and deploy Retrieval-Augmented Generation (RAG) frameworks leveraging vector databases. Furthermore, you will collaborate with data scientists, software developers, and business stakeholders to ensure robust data governance, query optimization, and seamless production deployments.

Key Responsibilities

• Design, build, optimize, and maintain scalable cloud data pipelines and modern data warehouse architectures using Snowflake.
• Develop robust data transformation models and automated workflows using DBT and advanced SQL.
• Write clean, efficient, and maintainable Python code for data processing, ingestion, and pipeline orchestration.
• Implement cutting-edge AI/ML, Generative AI (GenAI), and Retrieval-Augmented Generation (RAG) pipelines.
• Integrate and manage vector databases to support semantic search, LLM embeddings, and context-aware AI applications.
• Troubleshoot data ingestion bottlenecks, query performance issues, and pipeline failures across cloud environments.
• Collaborate with data science and software engineering teams to operationalize machine learning models in production.
• Ensure uncompromising adherence to data security standards, data governance policies, and best practices in cloud computing.

Required Qualifications & Skills

• Minimum of 5+ years of professional experience in data engineering, software engineering, or analytics engineering.
• Strong, demonstrable expertise in Snowflake data warehousing, SQL performance tuning, and database administration.
• Practical hands-on experience building transformation models using DBT (Data Build Tool).
• Proficiency in Python programming and advanced SQL querying for data pipeline development.
• Proven practical experience working with AI/ML, Generative AI, RAG frameworks, and vector database technologies.
• Strong analytical, problem-solving, and cross-functional communication capabilities.
• Mandatory eligibility to work in the United States and availability for onsite work in Plano, TX.
• Readiness to work under Corp-to-Corp (C2C) contract employment terms.

Nice-to-Have Skills

• Professional certifications such as Snowflake SnowPro Core / Advanced Data Engineer or AWS/Azure Data Engineering credentials.
• Hands-on experience with vector databases such as Pinecone, Milvus, Qdrant, or pgvector.
• Familiarity with orchestration tools such as Apache Airflow, Prefect, or Dagster.
• Experience integrating Large Language Models (LLMs) via APIs (OpenAI, Anthropic, Hugging Face) into enterprise applications.
• Prior working experience within IT consultancy environments or fast-paced enterprise client sites.

Application Information

• Salary/Rate: Market Competitive / Contract Standard (C2C)
• Deadline: Open until filled
• Notice Period: Immediate to 15 Days
• Contract Duration: Contract / Corp-to-Corp (C2C) Onsite

Recruitment Pro Tip

When applying for this Snowflake Data Engineer with AI/ML role at TekisHub, ensure your resume explicitly highlights your hands-on experience with Snowflake, DBT, Python, RAG pipelines, and vector databases. Clearly state your C2C availability and readiness for onsite work in Plano, TX.