Remote Snowflake Data Engineer — 6+ Month Contract

Beacon Hill Staffing Group, LLC; Richmond (VA); Remote; USD 110,000 - 138,000; Full time

Job summary

Beacon Hill Staffing Group, LLC is seeking a Data Engineer with Snowflake expertise for a remote 6+ month contract. The role focuses on designing and optimizing Snowflake databases, data models, and ETL processes to support analytics and BI initiatives.

The ideal candidate has 5+ years in data engineering, Snowflake certification, and hands-on experience building and tuning Snowflake objects, with a strong emphasis on data quality, governance, and scalable solutions.

Qualifications

• 5+ years of experience as a Data Engineer, Data Warehouse Engineer, Snowflake Developer, or similar role.
• Snowflake Certification required.
• Strong hands-on experience developing directly within Snowflake.
• Expertise creating and managing databases, schemas, tables, views, and other Snowflake objects.
• Advanced SQL development and query optimization skills.

Responsibilities

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

Skills

Advanced SQL development

Dimensional modeling

Snowflake performance tuning

Data modeling methodologies

Large-scale data warehousing

Database design principles

Query optimization

Data quality and governance

SQL troubleshooting

Education

Snowflake Certification

Tools

Snowflake

Job description

Beacon Hill Staffing Group, LLC is seeking a Data Engineer with Snowflake expertise for a remote 6+ month contract. The role focuses on designing and optimizing Snowflake databases, data models, and ETL processes to support analytics and BI initiatives.

The ideal candidate has 5+ years in data engineering, Snowflake certification, and hands-on experience building and tuning Snowflake objects, with a strong emphasis on data quality, governance, and scalable solutions.