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.
Skills Required
- 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 cloud data warehouse data modeling
- ETL and ELT development using modern data platforms
- Python programming for data engineering
- Experience with DataStream for real-time data processing
- Experience with Snowflake Time Travel and Fail-safe features
- Experience using SnowSQL command-line interface
- PL/SQL or T-SQL experience for stored procedures and database scripting
- Experience integrating Snowflake with AWS, Azure, or GCP
- Expertise in data governance and compliance frameworks
- Experience 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
Brillio Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Brillio and has not been reviewed or approved by Brillio.
-
Healthcare Strength — Healthcare is considered comprehensive, including medical coverage for employees and dependents alongside life, disability, and accidental death protections. Feedback suggests these protections are a core strength of the package.
-
Leave & Time Off Breadth — Time-off options include paid leave and parental leave, with flexible or ‘flexible PTO’ approaches cited in some contexts. Feedback suggests this breadth helps support work-life balance when team norms permit usage.
-
Wellbeing & Lifestyle Benefits — Wellbeing offerings span counseling, financial-management sessions, fitness programs, and travel insurance, plus region-specific extras like discounted IT hardware and work-from-home essentials. Feedback suggests these add-ons enhance perceived value beyond core insurance.
Brillio Insights
What We Do
Brillio is the leader in global digital business transformation, applying technology with a human touch. We help businesses define internal and external transformation objectives, and translate those objectives into actionable market strategies using proprietary technologies. With 2600+ experts and 13 offices worldwide, Brillio is the ideal partner for enterprises that want to quickly increase their core business productivity, and achieve a competitive edge, with the latest digital solutions.
