Looking for a seasoned Snowflake Data Architect with the ability to combine deep technical expertise with architectural leadership. The role will focus on designing scalable Snowflake solutions, modern data architectures, migration strategies, performance optimization and data integration frameworks.
Data Warehousing, Snowflake Data Exchange, Time Travel and Fail Safe, Snowpipe, SnowSQL,
Modern Data Platform Fundamentals, Data Modelling Fundamentals, PLSQL, T-SQL, Stored Procedures
Exp- 10+yrs
Job Location - All Brillio (Hybrid mode)
Notice- 0-45days max
3 technical round includes one in-person interview at Brillio office(mandatory)
Specialization
Snowflake Data Architecture: Data Architect
Snowflake certification
Job requirements
Experience Range: With 10 to 18 years of experience in data architecture, including significant hands-on expertise in designing and implementing Snowflake data platforms.
Key Responsibilities:
1. Architect and deliver scalable, high-performance data solutions utilizing Snowflake, ensuring reliability and optimal resource utilization across the organization.
2. Develop, automate, and maintain robust ETL pipelines to enable seamless data integration, transformation, and loading from diverse sources.
3. Configure and administer advanced Snowflake features such as Zero Copy Cloning, Time Travel, Fail Safe, and Snowpipe to maximize data accessibility and recovery capabilities.
4. Optimize complex SQL queries and stored procedures (PLSQL, T-SQL) to enhance data warehousing efficiency and throughput for analytics workloads.
5. Leverage Snowflake Data Exchange and SnowSight to facilitate secure data sharing and deliver actionable analytics to business stakeholders.
6. Design and model intricate data structures to support business intelligence, reporting, and analytics initiatives, ensuring scalability and performance.
7. Establish and enforce data governance, security, and compliance standards across the Snowflake platform in collaboration with cross-functional teams. 8. Diagnose and resolve data architecture challenges, ensuring high standards of data quality, consistency, and availability.
Required Skills:
1. Expert-level proficiency in Snowflake data architecture
2. Advanced ETL pipeline development and automation
3. Complex SQL query optimization and stored procedure development (PLSQL, T-SQL)
4. Administration of Snowflake features including Zero Copy Cloning, Time Travel, Fail Safe, and Snowpipe
5. Hands-on experience with SnowSQL and Python for data engineering
6. Deep understanding of data warehousing concepts and data modeling
7. Experience with Snowflake Data Exchange
Preferred Skills:
1. Proficiency with SnowSight for advanced analytics and visualization
2. Experience with cloud-based data integration tools such as Informatica, Talend, or Matillion
3. Expertise in optimizing large-scale, distributed data workloads
4. Experience with real-time data streaming solutions such as Kafka or AWS Kinesis
5. Advanced troubleshooting and performance tuning in Snowflake environments
Desired Qualifications:
1. Bachelor's degree in Computer Science, Information Technology, Data Engineering, or a closely related field
2. Snowflake SnowPro Certification
3. Certification in data warehousing or cloud data platforms, such as AWS Certified Data Analytics or Microsoft Certified: Azure Data Engineer Associate
These cookies are necessary for the website to function and cannot be turned off in our systems. You can set your browser to block these cookies, but then some parts of the website might not work.
Security
User experience
Target group oriented cookies
These cookies are set through our website by our advertising partners. They may be used by these companies to profile your interests and show you relevant advertising elsewhere.
Google Analytics
Google Ads
We use cookies
🍪
Our website uses cookies and similar technologies to personalize content, optimize the user experience and to indvidualize and evaluate advertising. By clicking Okay or activating an option in the cookie settings, you agree to this.
The best remote jobs via email
Join 5'000+ people getting weekly alerts with remote jobs!