Snowflake Architect

Job ID: 21235Requisition: R01573082Location: Jersey City, United StatesCategory: AI & Data EngineeringAbout Brillio: Brillio is one of the fastest growing digital technology service providers and a partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Brillio, renowned for its world-class professionals, referred to as “Brillians”, distinguishes itself through their capacity to seamlessly integrate cutting-edge digital and design thinking skills with an unwavering dedication to client satisfaction. 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 ArchitectLocation: Jersey City, NJExperience 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 implementationKey Responsibilities:Design scalable, secure, and high-performance data architecture and data models using SnowflakeDevelop and implement robust ETL and ELT pipelines and data integration strategies leveraging modern data platform toolsOptimize query performance, resource utilization, and Snowflake costs through advanced tuning techniquesEnsure data security, governance, and access control compliance within Snowflake and across cloud environmentsIntegrate Snowflake with AWS, Azure, or GCP platforms for seamless cloud data operationsProvide technical leadership to data engineering teams, establishing best practices and standardsImplement and manage Snowpipe, Streams, Tasks, and Dynamic Tables for real-time and batch data processingCollaborate with stakeholders to translate business requirements into scalable data solutionsRequired Skills:Advanced expertise in Snowflake architecture and administrationStrong proficiency in SQL, including advanced query optimizationHands-on experience with Snowpipe, Streams, Tasks, and Dynamic TablesData modeling for cloud data warehousingETL and ELT development using modern data platformsPython programming for data engineeringExperience with DataStream for real-time data processingTime Travel and Fail Safe features in SnowflakeSnowSQL command-line interface for managing Snowflake environmentsPLSQL or T-SQL for stored procedures and database scriptingPreferred Skills:Experience integrating Snowflake with AWS, Azure, or GCPExpertise in data governance and compliance frameworksFamiliarity with performance tuning and cost optimization in cloud data warehousesKnowledge of emerging Snowflake features and best practicesExperience leading technical teams in enterprise data architectureSnowflake certification such as SnowPro Core or Advanced ArchitectDesired Qualifications:Bachelor’s degree in Computer Science, Information Technology, Engineering, or a closely related disciplineSnowflake certification such as SnowPro Core or Advanced ArchitectWhy 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: Equal Employment Opportunity DeclarationBrillio 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-CH1Know what it’s like to work and grow at Brillio: Click here Salary: 140,000-160,000 USD per year salary