Remote Snowflake Architect & Data Engineer

Beacon Hill Staffing Group, LLC; Nashville (TN); Remote; USD 83,000 - 138,000; Full time

Job summary

Beacon Hill Staffing Group, LLC is seeking a Data Engineer specialized in Snowflake for a remote, 6+ month contract. You will design, optimize Snowflake databases, implement data models, write complex SQL, and collaborate with analytics teams to support BI initiatives.

The role requires 5+ years of data engineering experience, Snowflake Certification, and hands-on Snowflake development. This contract offers remote work from the United States with competitive hourly compensation.

Qualifications

• 5+ years of experience as a Data Engineer or similar role.
• Snowflake Certification is required.
• Hands-on Snowflake development experience.
• Experience with dimensional modeling, star schemas, and fact/dimension design.
• Proven Snowflake performance tuning and optimization experience.

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, tables, views, and other Snowflake objects.
• Create and optimize logical and physical data models to support analytics, reporting, and BI initiatives.
• Develop and maintain fact and dimension tables using dimensional modeling best practices.
• Write, optimize, and troubleshoot complex Snowflake SQL queries, stored procedures, and data transformations.
• Implement performance tuning strategies, including query optimization, clustering keys, and warehouse sizing.
• Monitor and improve Snowflake performance, scalability, and cost efficiency.
• Build and maintain materialized views, streams, tasks, and other Snowflake-native features.
• Partner with data architects, analysts, and business stakeholders to design scalable data solutions.
• Ensure data quality, integrity, security, and governance across Snowflake environments.
• Support ongoing enhancements to the enterprise data warehouse and analytics ecosystem.

Skills

5+ years experience

SQL development

Snowflake optimization

Data modeling

Performance tuning

Education

Snowflake Certification

Tools

Snowflake

SQL

Data Modeling

Job description

Beacon Hill Staffing Group, LLC is seeking a Data Engineer specialized in Snowflake for a remote, 6+ month contract. You will design, optimize Snowflake databases, implement data models, write complex SQL, and collaborate with analytics teams to support BI initiatives.

The role requires 5+ years of data engineering experience, Snowflake Certification, and hands-on Snowflake development. This contract offers remote work from the United States with competitive hourly compensation.