Snowflake Architect

Brillio takes pride in its status as an employer of choice, consistently attracting the most exceptional and talented individuals due to its unwavering emphasis on contemporary, groundbreaking technologies, and exclusive digital projects. Brillio's relentless commitment to providing an exceptional experience to its Brillians and nurturing their full potential consistently garners them the Great Place to Work® certification year after year.

Role: Snowflake Architect
Location: Jersey City, NJ
Experience Range: 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
Key Responsibilities:
Design scalable, secure, and high-performance data architecture and data models using Snowflake
Develop and implement robust ETL and ELT pipelines and data integration strategies leveraging 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 seamless cloud data operations
Provide technical leadership to data engineering teams, establishing 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
Required Skills:
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
Data modeling for cloud data warehousing
ETL and ELT development using modern data platforms
Python programming for data engineering
Experience with DataStream for real-time data processing
Time Travel and Fail Safe features in Snowflake
SnowSQL command-line interface for managing Snowflake environments
PLSQL or T-SQL for stored procedures and database scripting
Preferred Skills:
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
Desired Qualifications:
Bachelor's degree in Computer Science, Information Technology, Engineering, or a closely related discipline
Snowflake certification such as SnowPro Core or Advanced Architect
Why should you apply for this role?
As Brillio continues to gain momentum as a trusted partner for our clients in their digital transformation journey, we strive to set new benchmarks for speed and value creation. The DI team at Brillio is at the forefront of leading this charge by reimagining and executing how we structure, sell and deliver our services to better serve our clients.
Know what it’s like to work and grow at Brillio: https://www.brillio.com/join-us/
Equal Employment Opportunity Declaration
Brillio is an equal opportunity employer to all, regardless of age, ancestry, colour, disability (mental and physical), exercising the right to family care and medical leave, gender, gender expression, gender identity, genetic information, marital status, medical condition, military or veteran status, national origin, political affiliation, race, religious creed, sex (includes pregnancy, childbirth, breastfeeding, and related medical conditions), and sexual orientation.
#LI-CH1

Know what it’s like to work and grow at Brillio: Click here