Ampstek

NEED ONLY US CITIZENS :: Data Engineer/Architect with Dbt, Snowflake, AWS

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is a Data Engineer/Architect contract position in Denver, CO, requiring expertise in dbt, Snowflake, AWS, Python, SQL, and Airflow. Candidates must be U.S. citizens with experience in ETL/ELT pipelines and data modeling.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
Unknown
-
🗓️ - Date
June 23, 2026
🕒 - Duration
Unknown
-
🏝️ - Location
Hybrid
-
📄 - Contract
Unknown
-
🔒 - Security
Unknown
-
📍 - Location detailed
Denver, CO
-
🧠 - Skills detailed
#Hadoop #Security #Cloud #Scala #Azure #Data Security #GitHub #dbt (data build tool) #Qlik #Langchain #Tableau #"ETL (Extract #Transform #Load)" #PySpark #Kafka (Apache Kafka) #AI (Artificial Intelligence) #Monitoring #Data Engineering #BI (Business Intelligence) #AWS (Amazon Web Services) #Deployment #Snowflake #Spark (Apache Spark) #Microsoft Power BI #ML (Machine Learning) #Data Lake #SQL (Structured Query Language) #Airflow #Python
Role description
Title: Data Engineer/Architect Location: Denver,CO(Hybrid mode onsite) Job Type: Contract Mandatory Skills • dbt, ETL/ELT pipeline development • Snowflake, AWS/Azure Data Lake • Python, SQL, PySpark, Spark • Airflow / workflow orchestration • CI/CD (GitHub Actions) Desired/Secondary Skills • AI/ML & GenAI (LLMs, Snowflake Cortex AI, LangChain) • Kafka / streaming pipelines • Hadoop, Hive ecosystem • Tableau, Power BI, Qlik • Data security (RBAC, masking) Job Description • Lead design of Snowflake-based cloud data platforms and enterprise data modernization • Build scalable ELT pipelines using dbt / Airflow. • Migrate legacy pipelines to governed dbt frameworks improving efficiency & cost • knowledge on data models (Kimball) • Manage workflow orchestration (Airflow/Astronomer) with SLA monitoring • Establish CI/CD pipelines (GitHub Actions) for reliable deployments Thanks Aatmesh aatmesh.singh@ampstek.com