Lumicity

Snowflake Data Architect

⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Snowflake Data Architect on a long-term contract, offering a competitive hourly rate. It requires strong Snowflake Data Engineering and SQL expertise, experience with ELT pipelines, and knowledge of Databricks. Remote or hybrid work is available.
🌎 - Country
United States
πŸ’± - Currency
$ USD
-
πŸ’° - Day rate
520
-
πŸ—“οΈ - Date
December 16, 2025
πŸ•’ - Duration
More than 6 months
-
🏝️ - Location
Hybrid
-
πŸ“„ - Contract
Unknown
-
πŸ”’ - Security
Unknown
-
πŸ“ - Location detailed
Santa Clara, CA
-
🧠 - Skills detailed
#Data Engineering #dbt (data build tool) #Snowflake #SQL (Structured Query Language) #Cloud #Datasets #Databricks #Data Architecture #Data Warehouse #Spark (Apache Spark) #Security
Role description
Senior Snowflake Data Engineer (Contract | Long-Term) We’re partnering with an enterprise data platform team on a long-term initiative where Snowflake is the primary cloud data warehouse supporting analytics and reporting at scale. This role is ideal for someone whose core strength is Snowflake, with some experience working alongside Databricks in modern data ecosystems. What you’ll be doing β€’ Building and maintaining ELT pipelines primarily in Snowflake β€’ Writing, optimizing, and troubleshooting complex Snowflake SQL β€’ Managing Snowflake objects: virtual warehouses, schemas, streams, tasks, and secure views β€’ Supporting performance tuning, cost optimization, and warehouse sizing β€’ Collaborating with analytics and business teams to deliver trusted datasets β€’ Integrating upstream or adjacent processing from Databricks where applicable What we’re looking for β€’ Strong, hands-on Snowflake Data Engineering experience (primary platform) β€’ Advanced SQL expertise within Snowflake β€’ Experience designing ELT pipelines and analytical data models β€’ Working knowledge of Databricks / Spark in a production environment β€’ Understanding of Snowflake governance, security, and cost controls Nice to have β€’ dbt experience β€’ Experience supporting enterprise analytics or reporting teams β€’ Exposure to cloud-based data platforms in large-scale environments Engagement details β€’ Contract (long-term) β€’ Competitive hourly rate β€’ Remote or hybrid (US-based) This role is best suited for engineers who go deep in Snowflake and can collaborate across platforms when Databricks is part of the stack.