Snowflake Architect - R01573082

Brillio • Jersey City, NJ

2d • $140,000 - $160,000

About The Position

Brillio is hiring a Snowflake Architect to design and implement scalable, secure, and high-performance data architecture and data models. The role focuses on developing ETL and ELT pipelines, optimizing Snowflake query performance and costs, and ensuring data security, governance, and access-control compliance. It also integrates Snowflake with cloud platforms and supports real-time and batch data processing using Snowflake capabilities.

The Snowflake Architect will provide technical leadership to data engineering teams, establish best practices, and collaborate with stakeholders to turn business requirements into scalable data solutions. The position is located in Jersey City, New Jersey, and seeks a candidate with 7–10 years of data engineering, data warehousing, or cloud data platform experience, including at least four years of hands-on Snowflake architecture and implementation. The stated salary range is $140,000–$160,000 per year.

Requirements

• 7–10 years of experience in data engineering, data warehousing, or cloud data platforms.
• At least 4 years of hands-on Snowflake architecture and implementation experience.
• 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.
• Experience developing ETL and ELT pipelines using modern data platforms.
• Python programming for data engineering.
• Experience with DataStream for real-time data processing.
• Knowledge of Snowflake Time Travel and Fail Safe features.
• Experience using the SnowSQL command-line interface to manage Snowflake environments.
• Experience with PL/SQL or T-SQL for stored procedures and database scripting.
• Bachelor’s degree in Computer Science, Information Technology, Engineering, or a closely related discipline.

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.

Responsibilities

• Design scalable, secure, and high-performance data architectures 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