Snowflake Architect

Aroha Technologies, Inc; Raritan (NJ); Hybrid; USD 96,000 - 165,000; Part time

Job summary

Aroha Technologies, Inc. is seeking an experienced Snowflake Architect in Raritan, NJ. This contract role requires designing, developing, and deploying scalable data warehouse solutions using Snowflake across cloud platforms.

You will optimize SQL, build ETL/ELT pipelines, and implement advanced Snowflake features. Collaboration with data teams and governance implementation are key responsibilities in this hybrid onsite role.

Qualifications

• 8+ years in Data Warehousing or Data Engineering.
• 5+ years hands-on Snowflake architecture and development.
• Strong SQL, performance tuning, and query optimization.
• Experience designing ETL/ELT pipelines and data integration.
• Strong data modeling knowledge (dimensional modeling).
• Hands-on Snowflake features: Snowpipe, Streams, Tasks, Time Travel.
• Experience with cloud platforms (AWS, Azure, GCP).
• Knowledge of data security, RBAC, governance, and access management.
• Experience with ETL tools like Informatica, Matillion, Fivetran, dbt.
• Strong communication, problem-solving, and stakeholder management.

Responsibilities

• Design scalable, high-performance Snowflake data warehouse architectures.
• Develop and optimize complex SQL queries and Snowflake objects.
• Design and implement ETL/ELT pipelines from multiple sources.
• Implement Snowflake features like Virtual Warehouses, Streams, Tasks, Time Travel.
• Develop data models including Star and Snowflake schemas.
• Optimize query performance, warehouse utilization, and data processing costs.
• Implement data security, RBAC, data masking, and governance policies.
• Integrate Snowflake with AWS, Azure, or GCP.
• Collaborate with data engineers, analysts, and stakeholders on data needs.
• Establish architecture standards and best practices.

Skills

Snowflake Architecture

SQL

ETL/ELT Pipelines

Data Modeling

Cloud Platforms

Data Security & RBAC

Stakeholder Management

Communication Skills

Snowflake Features

Tools

Informatica

Matillion

Fivetran

dbt

Git / CI/CD

Job description

Job Title:

Snowflake Architect

Location:

Raritan, NJ (Hybrid 2 3 days onsite per week)

Job Type:

Contract

Job Description

We are looking for an experienced Snowflake Architect to design, develop, and implement scalable, secure, and high-performance data warehouse solutions using Snowflake. The ideal candidate will have strong expertise in cloud data architecture, data modeling, ETL/ELT pipelines, and data integration, along with experience working with enterprise-scale data platforms.

Key Responsibilities

• Design and implement scalable, high-performance data warehouse architectures using Snowflake.
• Develop and optimize complex SQL queries, stored procedures, and Snowflake database objects.
• Design and implement ETL/ELT data pipelines for integrating data from multiple sources.
• Implement Snowflake features such as Virtual Warehouses, Streams, Tasks, Snowpipe, Time Travel, and Zero-Copy Cloning.
• Develop data models, including dimensional modeling, Star Schema, and Snowflake Schema.
• Optimize query performance, warehouse utilization, and overall data processing costs.
• Implement data security, access controls, RBAC, data masking, and governance policies.
• Integrate Snowflake with cloud platforms such as AWS, Azure, or GCP.
• Collaborate with data engineers, business analysts, and stakeholders to understand data requirements.
• Establish architecture standards, best practices, and data management strategies.

Required Skills

• 8+ years of experience in Data Warehousing, Data Engineering, or related roles.
• 5+ years of hands‑on experience with Snowflake architecture and development.
• Strong expertise in SQL, Snowflake performance tuning, and query optimization.
• Experience designing ETL/ELT pipelines and data integration solutions.
• Strong understanding of data modeling, dimensional modeling, and database concepts.
• Hands‑on experience with Snowflake features such as Snowpipe, Streams, Tasks, and Time Travel.
• Experience with cloud platforms (AWS, Azure, or GCP).
• Knowledge of data security, RBAC, governance, and access management.
• Experience with ETL tools such as Informatica, Matillion, Fivetran, dbt, or similar.
• Strong communication, problem‑solving, and stakeholder management skills.

Preferred Qualifications

• SnowPro Core or SnowPro Advanced certification.
• Experience with Python and data engineering frameworks.
• Experience with CI/CD, Git, and automated deployment processes.
• Experience working in large enterprise environments.