Snowflake Architect
⭐ - Featured Role | Apply direct with Data Freelance Hub
This role is for a Snowflake Architect in Jersey City, NJ, with a contract length of over 6 months and a full-time W2 pay structure. Key skills include Snowflake, DBT, SQL performance tuning, and data modeling. Preferred qualifications include Snowflake and DBT certifications, with experience in banking or financial services.
🌎 - Country
United States
💱 - Currency
$ USD
-
💰 - Day rate
-
🗓️ - Date discovered
August 7, 2025
🕒 - Project duration
More than 6 months
-
🏝️ - Location type
On-site
-
📄 - Contract type
W2 Contractor
-
🔒 - Security clearance
Unknown
-
📍 - Location detailed
New Jersey, United States
-
🧠 - Skills detailed
#GCP (Google Cloud Platform) #SQL (Structured Query Language) #Data Modeling #Cloud #Code Reviews #Oracle #Oracle Exadata #Clustering #Monitoring #dbt (data build tool) #SnowSQL #Deployment #AWS (Amazon Web Services) #Version Control #Data Architecture #Data Pipeline #Data Engineering #Azure #Data Warehouse #"ETL (Extract #Transform #Load)" #Scala #Documentation #Snowflake #Data Governance #Automation
Role description
Job Title: Snowflake Architect – Snowflake & DBT Modernization
Location: Jersey City, NJ – 3-4 Days onsite
Job Type: Fulltime & W2 Only
Key Responsibilities:
• Architecture Review & Optimization
• Assess the current Snowflake-based data platform architecture.
• Identify bottlenecks and inefficiencies in data transformation and processing.
• Recommend architectural improvements for scalability, performance, and cost-efficiency.
• Code & SQL Review
• Conduct detailed reviews of DBT models, SnowSQL scripts, and transformation logic.
• Validate adherence to best practices in modularity, reusability, and performance tuning.
• Suggest improvements for query optimization and resource utilization.
• Performance Tuning
• Analyze slow-running queries and transformation pipelines.
• Implement strategies for warehouse sizing, clustering, caching, and materialization.
• Guide the team on Snowflake-specific performance features (e.g., result caching, automatic clustering).
• Best Practices & Governance
• Establish coding standards and naming conventions for DBT and SnowSQL.
• Define data governance, lineage, and documentation practices.
• Recommend monitoring and alerting mechanisms for data pipeline health.
• Collaboration & Mentorship
• Work closely with data engineers, analysts, and platform teams.
• Mentor junior developers on Snowflake and DBT development.
• Participate in sprint planning, code reviews, and architectural discussions.
Required Skills & Experience:
• Proven experience as a Cloud Data Architect or Senior Data Engineer in Snowflake and other Cloud DB environments.
• Strong hands-on expertise in DBT, SnowSQL, and SQL performance tuning.
• Familiarity with Oracle Exadata and PL/SQL is a plus for comparative analysis.
• 10+ years experience in data modeling ( logical and physical ), ETL/ELT design, and designing and implementing data warehouse , performance tuning and optimization.
• Understanding of CI/CD pipelines, version control, and deployment automation.
• Excellent communication skills and ability to translate technical findings into actionable recommendations.
Preferred Qualifications:
• Snowflake Architect Certification , DBT Certification.
• Experience in banking or financial services data platforms.
• Exposure to cloud platforms like AWS, Azure, or GCP.
Job Title: Snowflake Architect – Snowflake & DBT Modernization
Location: Jersey City, NJ – 3-4 Days onsite
Job Type: Fulltime & W2 Only
Key Responsibilities:
• Architecture Review & Optimization
• Assess the current Snowflake-based data platform architecture.
• Identify bottlenecks and inefficiencies in data transformation and processing.
• Recommend architectural improvements for scalability, performance, and cost-efficiency.
• Code & SQL Review
• Conduct detailed reviews of DBT models, SnowSQL scripts, and transformation logic.
• Validate adherence to best practices in modularity, reusability, and performance tuning.
• Suggest improvements for query optimization and resource utilization.
• Performance Tuning
• Analyze slow-running queries and transformation pipelines.
• Implement strategies for warehouse sizing, clustering, caching, and materialization.
• Guide the team on Snowflake-specific performance features (e.g., result caching, automatic clustering).
• Best Practices & Governance
• Establish coding standards and naming conventions for DBT and SnowSQL.
• Define data governance, lineage, and documentation practices.
• Recommend monitoring and alerting mechanisms for data pipeline health.
• Collaboration & Mentorship
• Work closely with data engineers, analysts, and platform teams.
• Mentor junior developers on Snowflake and DBT development.
• Participate in sprint planning, code reviews, and architectural discussions.
Required Skills & Experience:
• Proven experience as a Cloud Data Architect or Senior Data Engineer in Snowflake and other Cloud DB environments.
• Strong hands-on expertise in DBT, SnowSQL, and SQL performance tuning.
• Familiarity with Oracle Exadata and PL/SQL is a plus for comparative analysis.
• 10+ years experience in data modeling ( logical and physical ), ETL/ELT design, and designing and implementing data warehouse , performance tuning and optimization.
• Understanding of CI/CD pipelines, version control, and deployment automation.
• Excellent communication skills and ability to translate technical findings into actionable recommendations.
Preferred Qualifications:
• Snowflake Architect Certification , DBT Certification.
• Experience in banking or financial services data platforms.
• Exposure to cloud platforms like AWS, Azure, or GCP.
