We are seeking a highly experienced freelance Snowflake Data Architect to lead the optimization and re-architecture of an advanced reporting layer within a Snowflake data warehouse.
This is a fully remote, contract role lasting at least 6 months, requiring 40 hours of work per week.
The role involves enhancing compute efficiency, reducing costs, and supporting analytic engineering initiatives that drive business intelligence and reporting.
You will collaborate with engineering, analytics, and business teams to implement performance improvements without compromising data integrity.
Key accountabilities include optimizing Snowflake data warehouse reporting layers, enhancing query performance, designing efficient data models, collaborating on ETL processes, implementing best practices, developing materialized views, supporting compute tuning, and partnering with business stakeholders.
Requirements:
Candidates must have 4–5+ years of experience in data architecture or analytic engineering, particularly with Snowflake.
Advanced proficiency in SQL and Snowflake-specific optimization techniques is required.
A strong understanding of Snowflake architecture, including virtual warehouses, storage, and clustering, is essential.
Experience in optimizing query execution, compute utilization, and data processing efficiency is necessary.
Familiarity with data modeling and performance tuning in large-scale analytics environments is expected.
A proven track record of working with ETL pipelines and transforming data into accessible formats is required.
Strong communication skills for cross-functional collaboration and problem-solving are essential.
Candidates must be based in the United States and available for 40 hours per week of contract work.
Benefits:
This position offers 100% remote work with flexible scheduling.
The hourly pay range is $85–$100 USD.
There is an opportunity to work with a high-impact team focused on data democratization.
You will gain exposure to advanced Snowflake use cases and performance architecture.
The work environment is collaborative and mission-driven.
The role provides high autonomy with the ability to lead optimization strategy.
It is a contract role with potential for future engagement.
