Snowflake Architect

Brillio; Dallas (TX); A distancia; USD 150.000 - 210.000; Jornada completa

Descripción de la vacante

Brillio seeks a Principal Data Architect for Snowflake engineering to design scalable, secure data solutions across enterprise initiatives. The role emphasizes advanced Snowflake features, data modeling, and optimized ETL pipelines to support critical business decisions.

Ideal candidates bring 15–18 years in data architecture, strong SQL and Python, and hands-on experience with Snowflake Streams, Snowpipe, and SnowSQL.

Formación

• 15–18 years of experience in data architecture and engineering.
• Deep expertise in Snowflake and modern data platforms.
• Strong SQL and Python proficiency with data pipelines.

Responsabilidades

• Design scalable Snowflake data solutions aligned with enterprise goals.
• Develop ETL pipelines using Snowflake Streams, Python and SQL.
• Optimize Snowflake environments for performance and cost.
• Lead Snowflake data warehouse modeling and governance.
• Automate data processing with SnowSQL and stored procedures.
• Collaborate with cross-functional teams to define data platform requirements.
• Troubleshoot architectural and operational Snowflake issues.
• Mentor junior architects and engineers in best practices.

Conocimientos

Snowflake architecture

SQL

Python

ETL pipelines

Snowflake Streams

Time Travel

Fail Safe

Snowpipe

SnowSQL

Snowflake data modeling

Stored procedures

Educación

Bachelor's degree

SnowPro Advanced Architect

Cloud data platform certs (AWS/Azure)

Herramientas

AWS

Azure

Airflow

dbt

Descripción del empleo

Brillio is the partner of choice for many Fortune 1000 companies seeking to turn disruption into a competitive advantage through innovative digital adoption. Backed by Bain Capital private equity and Orogen Group, and growing rapidly since its inception, Brillio is one of the fastest growing digital technology service providers. We help clients harness the transformative potential of the four superpowers of technology - cloud computing, internet of things (IoT), artificial intelligence (AI), and mobility. Born digital in 2014, we apply Customer Experience Solutions, Data Analytics and AI, Digital Infrastructure and Security, and Platform and Product Engineering expertise to help clients quickly innovate for growth, create digital products, build service platforms, and drive smarter, data-driven performance. With delivery locations across the United States, Romania, Canada, Mexico, and India, our growing global workforce of over 5500 Brillians blends the latest technology and design thinking with digital fluency to solve complex business problems and drive competitive differentiation for our clients. Brillio was awarded ‘Great Place To Work consistently. Learn more www.Brillio.com

About the Role

Role: Snowflake Engineering: Principal Data Architect

Location: Remote

15 to 18 years of experience in data architecture and engineering, including extensive expertise in Snowflake and modern data platforms.

Responsibilities

• Design and architect scalable, secure, and high-performance Snowflake data solutions to drive enterprise data initiatives.
• Develop and implement robust ETL pipelines using Snowflake Streams, Python, and SQL to enable efficient data ingestion and transformation.
• Optimize Snowflake environments for performance, cost, and reliability by leveraging features such as Time Travel, Fail Safe, and Snowpipe.
• Lead the modeling and structuring of complex Snowflake data warehouses, ensuring data integrity, accessibility, and scalability.
• Configure and manage SnowSQL, stored procedures, and advanced SQL scripts to automate data processing and analytics workflows.
• Collaborate with cross-functional teams to define data platform requirements and deliver modern data solutions aligned with business objectives.
• Troubleshoot and resolve architectural and operational issues within Snowflake and related data platforms, ensuring minimal downtime.
• Mentor and guide junior architects and engineers on best practices in Snowflake engineering and data platform fundamentals.

Required Skills

• Expertise in Snowflake architecture and engineering
• Advanced proficiency in SQL
• Strong experience with Python for data processing and automation
• Deep understanding of ETL pipeline development
• Hands-on experience with Snowflake Streams for real-time data ingestion
• Proficiency in Time Travel and Fail Safe features within Snowflake
• Implementation and management of Snowpipe for automated data loading
• Skilled in SnowSQL for scripting and data management
• Experience in Snowflake-specific data modeling and warehouse design
• Expertise in developing and managing Snowflake stored procedures

Preferred Skills

• Experience integrating Snowflake with cloud platforms such as AWS or Azure
• Expertise in advanced data security and governance practices
• Knowledge of performance tuning and optimization for large-scale Snowflake workloads
• Familiarity with emerging data engineering technologies and frameworks
• Experience with orchestration tools for automating data pipelines (e.g., Apache Airflow, dbt)
• Hands-on experience with real-time analytics and streaming data solutions

Qualifications

• Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related discipline
• Snowflake SnowPro Advanced Architect certification or equivalent
• Certification in data warehousing or cloud data platform architecture (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer Associate)

Required Skills – Critical Leadership Qualities

• Customer Advocacy – Lead with the client's business priorities and build relationships grounded in relevance, trust and measurable value.
• Owner's Mindset – Take accountability for the territory, pipeline and results; approach every target account with a clear ambition to build a meaningful Brillio franchise.
• Innovation Ethos – Bring new ideas and perspectives that challenge conventional thinking and create reasons for clients to engage.
• Execution with Pace – Maintain urgency, discipline and momentum from initial access through contract closure.
• Big Picture Thinking – Connect individual opportunities to broader client transformation agendas and Brillio's long term growth strategy.
• Winning Through Teams – Mobilize the best of Brillio and its ecosystem to create differentiated propositions and win together.