Holistic Partners, Inc
Data Engineer
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Data Engineer with 3+ years of ETL/ELT experience, focusing on Matillion, Snowflake, AWS, and Looker. It is a remote position for 6+ months, requiring U.S. Citizens/Green Card holders only, with a W2 pay structure.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
June 18, 2026
🕒 - Duration
More than 6 months
-
🏝️ - Location
Remote
-
📄 - Contract
W2 Contractor
-
🔒 - Security
Unknown
-
📍 - Location detailed
United States
-
🧠 - Skills detailed
#Azure #GitHub #Snowflake #Azure DevOps #Scrum #Documentation #AWS (Amazon Web Services) #Data Pipeline #Triggers #SQL (Structured Query Language) #Looker #Matillion #Cloud #Datasets #Scala #Data Engineering #Data Warehouse #"ETL (Extract #Transform #Load)" #Agile #DevOps #Data Mapping #Data Quality #SQL Queries #Unit Testing #Security #Lambda (AWS Lambda)
Role description
Job Title: Data Engineer
Location: Remote
Duration: 6+ Months
Interview Process: Online Interview
Tax Term: W2 Only
Visa: U.S. Citizens/Green Card ONLY due to legal or government contract requirement
Role Overview
We are seeking a Data Engineer with strong experience in designing, building, and optimizing cloud-based ETL/ELT data pipelines. The ideal candidate will have hands-on expertise with Matillion, Snowflake, AWS, and Looker, along with a solid background in SQL, Change Data Capture (CDC), and modern data engineering practices.
Required Skills
• 3+ years of hands-on ETL/ELT development experience
• Strong experience with Matillion (Required)
• Expertise in Snowflake data warehouse
• Experience with Looker for reporting and analytics
• Strong knowledge of AWS, including Lambda and data pipeline orchestration
• Advanced SQL skills, including stored procedures, triggers, functions, and performance tuning
• Experience implementing Change Data Capture (CDC)
• Full SDLC experience, including testing and data validation
• Strong troubleshooting, data mapping, and ELT documentation skills
• Knowledge of security best practices for data engineering
Preferred Skills
• CI/CD tools such as GitHub Actions or Azure DevOps
• Experience with Agile/Scrum methodologies
• Unit testing and data quality frameworks
• Job optimization and pipeline performance tuning
• Ability to mentor junior engineers and lead small initiatives
Responsibilities
• Design, develop, and maintain scalable ETL/ELT pipelines using Matillion and Snowflake
• Build and orchestrate AWS-based data workflows, including Lambda functions
• Develop and optimize complex SQL queries for large datasets
• Implement and maintain CDC solutions for reliable data movement
• Create source-to-target mappings and technical documentation
• Perform data validation, testing, and troubleshooting
• Collaborate with cross-functional teams in an Agile environment
• Participate in production support and ETL on-call rotation
• Recommend process improvements and follow DevOps/CI-CD best practices
Job Title: Data Engineer
Location: Remote
Duration: 6+ Months
Interview Process: Online Interview
Tax Term: W2 Only
Visa: U.S. Citizens/Green Card ONLY due to legal or government contract requirement
Role Overview
We are seeking a Data Engineer with strong experience in designing, building, and optimizing cloud-based ETL/ELT data pipelines. The ideal candidate will have hands-on expertise with Matillion, Snowflake, AWS, and Looker, along with a solid background in SQL, Change Data Capture (CDC), and modern data engineering practices.
Required Skills
• 3+ years of hands-on ETL/ELT development experience
• Strong experience with Matillion (Required)
• Expertise in Snowflake data warehouse
• Experience with Looker for reporting and analytics
• Strong knowledge of AWS, including Lambda and data pipeline orchestration
• Advanced SQL skills, including stored procedures, triggers, functions, and performance tuning
• Experience implementing Change Data Capture (CDC)
• Full SDLC experience, including testing and data validation
• Strong troubleshooting, data mapping, and ELT documentation skills
• Knowledge of security best practices for data engineering
Preferred Skills
• CI/CD tools such as GitHub Actions or Azure DevOps
• Experience with Agile/Scrum methodologies
• Unit testing and data quality frameworks
• Job optimization and pipeline performance tuning
• Ability to mentor junior engineers and lead small initiatives
Responsibilities
• Design, develop, and maintain scalable ETL/ELT pipelines using Matillion and Snowflake
• Build and orchestrate AWS-based data workflows, including Lambda functions
• Develop and optimize complex SQL queries for large datasets
• Implement and maintain CDC solutions for reliable data movement
• Create source-to-target mappings and technical documentation
• Perform data validation, testing, and troubleshooting
• Collaborate with cross-functional teams in an Agile environment
• Participate in production support and ETL on-call rotation
• Recommend process improvements and follow DevOps/CI-CD best practices
