Snowflake Data Architect

$115,544 - $125,902/Yr

Learnbeyond Consulting - Spring, TX

Full-time - Mid Level

Spring, TX

Publishing Industries

About the position

The Snowflake Data Architect role involves developing analytics-based solutions to provide business insights, integrating systems and data, and leading the design and configuration of applications. The position requires expertise in Snowflake architecture, data modeling, and ELT processes, with a focus on delivering operational data warehouse solutions and managing client interactions.

Responsibilities

• Develop analytics-based solutions that produce quantitative and qualitative business insights.
• Integrate systems and data quickly and effectively, overcoming technical challenges.
• Lead the design, build, and configuration of applications as the primary point of contact for Snowflake architecture.
• Own end-to-end RFP or RFI processes, including client presentations and solution workshops.
• Contribute to estimation, building PoVs, offerings development, training, and capability building.
• Manage client-facing roles, including running solution workshops and handling large RFP pursuits.
• Resolve architecture issues and oversee the migration of existing applications to the AWS/Azure Snowflake platform.
• Demonstrate expertise in Snowflake data modeling and ELT using Snowflake SQL, implementing complex stored procedures and best practices.
• Deploy fully operational data warehouse solutions into production on Snowflake.
• Perform project management activities, including documentation, business requirements gathering, and project tracking.
• Write SQL queries against Snowflake and develop scripts in Unix and Python for data extraction, loading, and transformation.

Requirements

• Experience in designing and architecting Snowflake projects.
• Expertise in Snowflake data modeling and ELT using Snowflake SQL.
• Proficient in implementing stored procedures and standard DWH/ETL concepts.
• Solid understanding of Snowflake's advanced concepts, including virtual warehouses and query performance optimization.
• Hands-on experience with Snowflake utilities such as SnowSQL, SnowPipe, and data sharing.
• In-depth understanding of data warehouse, ODS, ETL concepts, and modeling structure principles.
• Experience in data warehousing, OLTP, OLAP, dimensions, facts, and data modeling.
• Ability to gather and analyze system requirements effectively.

Nice-to-haves

• Experience with any ETL tool.
• Good working knowledge of data platform architecture design.

Benefits

• Competitive hourly pay ranging from $55.55 to $60.53.
• Full-time employment with potential for career growth.