Remote Jobs RockRemote Jobs Rock

Snowflake Architect - R01573082

🕒 yesterday
SQLQuery OptimizationSnowpipeStreams
Apply Now

📜 Description

  • Design scalable, secure, high-performance Snowflake architectures and data models.
  • Build ETL/ELT pipelines and data integration strategies using modern data platform tools.
  • Tune queries and resource use to improve performance and control Snowflake costs.
  • Manage data security, governance, and access controls across Snowflake and cloud environments.
  • Integrate Snowflake with AWS, Azure, or GCP; implement Snowpipe, Streams, Tasks, and Dynamic Tables.
  • Set engineering standards and translate stakeholder requirements into scalable solutions.

🛠️ Requirements

  • 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
Full job description
About 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 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
About 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. Know what it’s like to work and grow at Brillio: Click here
Miratech

Senior Data Architect

🕒 2 days ago
Miratech👥 501 - 1000 employees🏢 Information Technology And Services

Own the end-to-end data architecture for a Databricks platform, designing ingestion, Medallion pipelines, and Kimball reporting models while ensuring data integrity, performance, and a controlled legacy-system migration.

DatabricksDelta LakeSnowflakeKimball Dimensional Modeling
Shyftlabs

Forward Deployed - Data Architect

🕒 yesterday
Shyftlabs👥 51 - 200 employees🏢 Management Consulting

Lead client-facing data architecture for enterprise platforms, translating business needs into secure, scalable solutions while guiding implementation, engineering standards, governance, and delivery from discovery through production.

Data ArchitectureAzure DatabricksDelta LakeUnity Catalog
Snowflake

Senior AI/ML Architect, Applied Field Engineering

🕒 4 days ago
Snowflake👥 10,000+ employees🏢 Software Development

Architect and demonstrate cloud-based AI and machine learning solutions for customer teams, lead proofs of concept, and partner across sales, product, and engineering to drive adoption and influence product roadmaps.

PythonMachine LearningGenerative AIRAG
Inetum

Salesforce Technical Architect

🕒 4 days ago
Inetum👥 10,000+ employees🏢 Information Technology And Services

Define and govern Salesforce solution architecture, setting technical standards and overseeing integrations, security, performance, and platform evolution to support complex business needs.

Salesforce ArchitectureSalesforce PlatformGovernor LimitsSalesforce Design Patterns

Trusted by Remote Workers