Senior, Hands-On Snowflake Architect

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Senior, Hands-On Snowflake Architect, offering a long-term, full-time remote contract. Requires 8+ years in data engineering, expertise in Snowflake, advanced SQL/Python skills, and Azure experience. Snowflake/Azure certifications preferred.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
-
πŸ—“οΈ - Date discovered
August 22, 2025
πŸ•’ - Project duration
More than 6 months
-
🏝️ - Location type
Remote
-
πŸ“„ - Contract type
Unknown
-
πŸ”’ - Security clearance
Unknown
-
πŸ“ - Location detailed
United States
-
🧠 - Skills detailed
#dbt (data build tool) #Monitoring #Data Encryption #SQL (Structured Query Language) #Consulting #Security #Data Engineering #Scala #SnowPipe #Azure cloud #Data Modeling #Strategy #Debugging #Azure #Data Strategy #Storage #Snowflake #JSON (JavaScript Object Notation) #Airflow #Cloud #Streamlit #Python
Role description
Senior, Hands-On Snowflake Architect Location: Remote Job Type: Full-time, Contract, longterm Must be eligible to work in the USA About Us We are a U.S.-based technology consulting firm with distributed engineering teams across Latin America, Eastern Europe, and TΓΌrkiye. We specialize in building high-performance global teams to deliver innovative software solutions. Our focus is on empowering great people to build great software. Job Description β€’ We are seeking a Senior Data Engineer with 8+ years of experience in end-to-end data engineering and Snowflake development. β€’ Expert in Snowflake native features: Snowpipe, Streams, Tasks, Time Travel, Zero-Copy Cloning, and Secure Data Sharing. β€’ Skilled in designing scalable ELT pipelines, advanced SQL/Python development, and dimensional data modeling (star/snowflake). β€’ Experienced in analyzing file formats (Parquet, ORC, Avro, JSON, CSV) and recommending performance/storage best practices. β€’ Strong in cost/performance optimization, handling semi-structured data, and compute/storage tuning in Snowflake. β€’ Azure cloud experience is preferred, along with integration using DBT, Airflow, and other modern data tools. β€’ Hands-on experience with Streamlit; familiarity with Snowflake Container Services is a strong plus. β€’ Knowledge of Snowflake security best practices including RBAC, data masking, access control, and data encryption. β€’ Experience with monitoring Snowflake performance using Resource Monitors, Query Profiling, and usage analytics. β€’ Snowflake and Azure certifications are preferred (not mandatory); must excel in architecture, debugging, and data strategy. Why Work With Us? β€’ 100% Remote Opportunities β€’ Coursera Access & Continuous Learning β€’ Flexible Paid Time Off β€’ Exposure to Global Clients and Technologies β€’ Career Growth and Advancement Pathways β€’ Inclusive and Supportive Team Culture