Remote Snowflake Data Engineer — 6+ Month Contract

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

Benefits offered by this job

Remote work

Job summary

Beacon Hill Staffing Group, LLC is seeking a Snowflake Data Engineer for a remote, 6+ month contract. You will design, develop, and optimize Snowflake databases, schemas, tables, and queries to support analytics and BI initiatives.

Required: 5+ years in data engineering or Snowflake roles; Snowflake Certification; strong SQL and data modeling; experience with large-scale data warehouses. This position offers a remote arrangement and competitive hourly pay.

Qualifications

• 5+ years in data engineering / data warehousing or similar.
• Snowflake Certification required
• Hands-on experience developing directly within Snowflake
• Experience with Snowflake objects (databases, schemas, tables, views)
• Advanced SQL development and query optimization
• Data modeling experience (dimensional, star schemas)
• Experience with large-scale data warehousing and analytics

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 and optimize complex Snowflake SQL queries, procedures, and data transformations.
• Implement performance tuning, query optimization, clustering, and warehouse sizing.
• Monitor Snowflake performance, scalability, and cost efficiency.
• Build and maintain materialized views, streams, tasks, and Snowflake-native features.
• Collaborate 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

Snowflake development

SQL optimization

Data modeling

Data warehousing

Performance tuning

Tools

Snowflake

Job description

Beacon Hill Staffing Group, LLC is seeking a Snowflake Data Engineer for a remote, 6+ month contract. You will design, develop, and optimize Snowflake databases, schemas, tables, and queries to support analytics and BI initiatives.

Required: 5+ years in data engineering or Snowflake roles; Snowflake Certification; strong SQL and data modeling; experience with large-scale data warehouses. This position offers a remote arrangement and competitive hourly pay.