Snowflake Architect - R01573082

Brillio • Jersey City, NJ

17h

About The Position

Brillio is hiring a Snowflake Architect to design and implement scalable, secure, high-performance data architectures and models. The role develops ETL and ELT pipelines and data integration strategies, optimizes Snowflake query performance, resource utilization, and costs, and ensures data security, governance, and access-control compliance. The architect integrates Snowflake with cloud platforms, implements Snowflake capabilities for real-time and batch processing, and provides technical leadership to data engineering teams. The role also works with stakeholders to translate business requirements into scalable data solutions.

The position is based in Jersey City, New Jersey. The stated experience range is 7–10 years in data engineering, data warehousing, or cloud data platforms, including at least four years of hands-on Snowflake architecture and implementation. A bachelor's degree in a related discipline is listed among the desired qualifications.

Requirements

• 7–10 years of experience in data engineering, data warehousing, or cloud data platforms, with at least 4 years specifically in hands-on Snowflake architecture and implementation.
• Advanced expertise in Snowflake architecture and administration.
• Strong proficiency in SQL, including advanced query optimization.
• Hands-on experience with Snowpipe, Streams, Tasks, and Dynamic Tables.
• Experience with data modeling for cloud data warehousing.
• ETL and ELT development using modern data platforms.
• Python programming for data engineering.
• Experience with Snowflake Time Travel and Fail Safe features.
• Experience with SnowSQL command-line interface for managing Snowflake environments.
• PLSQL or T-SQL experience for stored procedures and database scripting.

Nice To Haves

• Experience integrating Snowflake with AWS, Azure, or GCP.
• Expertise in data governance and compliance frameworks.
• Familiarity with performance tuning and cost optimization in cloud data warehouses.
• Knowledge of emerging Snowflake features and best practices.
• Experience leading technical teams in enterprise data architecture.
• Snowflake certification such as SnowPro Core or Advanced Architect.
• Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline.

Responsibilities

• Design scalable, secure, and high-performance data architecture and data models using Snowflake.
• Develop and implement ETL and ELT pipelines and data integration strategies using modern data platform tools.
• Optimize query performance, resource utilization, and Snowflake costs through advanced tuning techniques.
• Ensure data security, governance, and access-control compliance within Snowflake and across cloud environments.
• Integrate Snowflake with AWS, Azure, or GCP platforms for cloud data operations.
• Provide technical leadership to data engineering teams and establish best practices and standards.
• Implement and manage Snowpipe, Streams, Tasks, and Dynamic Tables for real-time and batch data processing.
• Collaborate with stakeholders to translate business requirements into scalable data solutions.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior