

Intellectt Inc
Senior Data Engineer with AWS & AI Experience - W2 Position
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior Data Engineer with 10+ years of experience in AWS, Python, SQL, and Spark. It requires expertise in Generative AI, ETL/ELT pipelines, and financial services experience. The position is W2, on-site in "Raritan, NJ / Boston, MA / NYC, NY" for an unspecified contract length at an undisclosed pay rate.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
August 8, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
On-site
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
New York City Metropolitan Area
-
🧠 - Skills detailed
#Cloud #Data Warehouse #REST API #Security #SQL (Structured Query Language) #Data Science #REST (Representational State Transfer) #Data Lake #Spark (Apache Spark) #ML (Machine Learning) #Data Engineering #Databases #AI (Artificial Intelligence) #Python #Data Processing #Compliance #Infrastructure as Code (IaC) #Scala #Batch #Data Pipeline #"ETL (Extract #Transform #Load)" #Microservices #Datasets #AWS (Amazon Web Services) #Data Quality
Role description
Title: Senior Data Engineer (AWS & Generative AI Experience)
Location: Raritan, NJ / Boston, MA / NYC, NY (5 Days Onsite)
Looking for Visa Independent Consultants - W2 Position
Job Description:
We are seeking an experienced Senior Data Engineer with strong expertise in AWS Cloud, Data Engineering, and Generative AI (Gen AI) to design, build, and optimize scalable data platforms and AI-enabled solutions. The ideal candidate should have extensive experience developing cloud-native data pipelines, modern data lake architectures, and integrating Large Language Models (LLMs) into enterprise applications. Experience in financial services is highly preferred.
Required Skills
• 10+ years of experience in Data Engineering.
• Strong hands-on experience with AWS Cloud services.
• Expertise in Python, SQL, and Spark.
• Experience building ETL/ELT pipelines.
• Strong knowledge of data warehousing concepts.
• Experience with Generative AI and Large Language Models (LLMs).
• Experience with Retrieval-Augmented Generation (RAG).
• Knowledge of vector databases and embeddings.
• Experience with prompt engineering and AI model integration.
• Strong understanding of REST APIs and microservices.
• Experience with CI/CD and Infrastructure as Code.
• Excellent communication and stakeholder management skills.
Responsibilities
• Design and develop scalable data pipelines on AWS.
• Build and maintain enterprise data lakes and data warehouses.
• Develop batch and real-time data processing solutions.
• Optimize ETL/ELT workflows for performance and reliability.
• Integrate Generative AI capabilities into enterprise applications.
• Design and implement RAG-based AI solutions.
• Develop APIs for AI-powered applications.
• Work with structured and unstructured datasets.
• Build data models to support analytics and machine learning workloads.
• Implement data quality, governance, security, and compliance standards.
• Collaborate with Data Scientists, ML Engineers, Product Owners, and Business Stakeholders.
• Optimize cloud infrastructure for scalability and cost efficiency.
• Mentor junior engineers and establish engineering best practices.
• Troubleshoot production issues and improve platform reliability.
• Participate in architecture discussions and technical design reviews.
Title: Senior Data Engineer (AWS & Generative AI Experience)
Location: Raritan, NJ / Boston, MA / NYC, NY (5 Days Onsite)
Looking for Visa Independent Consultants - W2 Position
Job Description:
We are seeking an experienced Senior Data Engineer with strong expertise in AWS Cloud, Data Engineering, and Generative AI (Gen AI) to design, build, and optimize scalable data platforms and AI-enabled solutions. The ideal candidate should have extensive experience developing cloud-native data pipelines, modern data lake architectures, and integrating Large Language Models (LLMs) into enterprise applications. Experience in financial services is highly preferred.
Required Skills
• 10+ years of experience in Data Engineering.
• Strong hands-on experience with AWS Cloud services.
• Expertise in Python, SQL, and Spark.
• Experience building ETL/ELT pipelines.
• Strong knowledge of data warehousing concepts.
• Experience with Generative AI and Large Language Models (LLMs).
• Experience with Retrieval-Augmented Generation (RAG).
• Knowledge of vector databases and embeddings.
• Experience with prompt engineering and AI model integration.
• Strong understanding of REST APIs and microservices.
• Experience with CI/CD and Infrastructure as Code.
• Excellent communication and stakeholder management skills.
Responsibilities
• Design and develop scalable data pipelines on AWS.
• Build and maintain enterprise data lakes and data warehouses.
• Develop batch and real-time data processing solutions.
• Optimize ETL/ELT workflows for performance and reliability.
• Integrate Generative AI capabilities into enterprise applications.
• Design and implement RAG-based AI solutions.
• Develop APIs for AI-powered applications.
• Work with structured and unstructured datasets.
• Build data models to support analytics and machine learning workloads.
• Implement data quality, governance, security, and compliance standards.
• Collaborate with Data Scientists, ML Engineers, Product Owners, and Business Stakeholders.
• Optimize cloud infrastructure for scalability and cost efficiency.
• Mentor junior engineers and establish engineering best practices.
• Troubleshoot production issues and improve platform reliability.
• Participate in architecture discussions and technical design reviews.






