Snowflake Data Architect

Qode • Columbia, SC

3d

About The Position

We are seeking an experienced Snowflake Data Architect with strong expertise in Snowflake data platform and Business Intelligence (BI) reporting. The ideal candidate will be responsible for designing scalable data architectures, optimizing Snowflake data warehouses, and enabling high-quality analytics and reporting solutions. This role requires strong experience in data modeling, data pipelines, performance optimization, and collaboration with BI teams to deliver actionable insights.

Requirements

• Strong experience in Snowflake Data Warehouse architecture and administration.
• Hands-on experience with SQL and performance tuning in Snowflake.
• Experience building ETL/ELT pipelines using tools such as Informatica, dbt, Talend, or similar.
• Strong experience with BI reporting tools such as Tableau, Power BI, Looker, or similar platforms.
• Expertise in data modeling and dimensional modeling techniques.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Strong understanding of data governance, security, and best practices for data architecture.

Nice To Haves

• Experience working in large-scale data warehouse environments.
• Knowledge of data lake architecture and modern data stack tools.
• Experience with Python or scripting languages for data processing.
• Strong communication and stakeholder management skills.

Responsibilities

• Design and implement scalable data architecture using Snowflake to support enterprise analytics and reporting needs.
• Develop and optimize Snowflake data warehouse solutions, including schema design, performance tuning, and cost optimization.
• Build and manage data pipelines and ELT/ETL processes to ingest and transform data from multiple sources into Snowflake.
• Design data models (Star/Snowflake schema) to support reporting and analytics use cases.
• Collaborate with BI teams to develop dashboards and reports using tools such as Tableau, Power BI, or similar platforms.
• Ensure data quality, governance, and security across the data platform.
• Optimize query performance and data storage strategies within Snowflake.
• Work with cross-functional teams including Data Engineers, BI Developers, and Business Analysts to understand reporting requirements.
• Implement best practices for data integration, data transformation, and reporting frameworks.
• Support data migration and modernization initiatives from legacy data warehouses to Snowflake.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed