What are the responsibilities and job description for the Snowflake Architect position at Aroha Technologies, Inc?
Job Title: Snowflake Architect
Location: Raritan, NJ (Hybrid 2 3 days onsite per week)
Pay Rate: $64/hr. on W2
Job Type: Contract
Job Description
Location: Raritan, NJ (Hybrid 2 3 days onsite per week)
Pay Rate: $64/hr. on W2
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.
- 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.
- 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.
- 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.
Salary : $60 - $64