Remote Snowflake Data Engineer for Scalable Analytics

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

Job summary

Beacon Hill Staffing Group, LLC is seeking a remote Data Engineer specialized in Snowflake for a 6+ month contract. The role requires 5+ years in Snowflake/data warehousing, with Snowflake Certification and strong SQL skills.

You will design, implement, and optimize Snowflake objects, models, and queries to support analytics and BI initiatives. Responsibilities include building fact/dimension tables, tuning performance, and ensuring data quality and governance across environments.

Qualifications

• 5+ years in Data Engineer / Snowflake roles.
• Snowflake Certification required.
• Experience with dimensional modeling, star schemas and fact/dimension design.
• Advanced SQL development and query optimization skills.
• Knowledge of data governance and security practices.

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, tables, views, and other Snowflake objects.
• Create and optimize data models to support analytics and BI initiatives.
• Develop fact and dimension tables using dimensional modeling.
• Write, optimize, and troubleshoot Snowflake SQL queries and stored procedures.
• Implement performance tuning strategies, including clustering keys and warehouse sizing.
• Monitor and improve Snowflake performance, scalability, and cost efficiency.
• Build and maintain materialized views, streams, and tasks.
• 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

Data modeling

SQL optimization

Data warehousing

Performance tuning

ETL/ELT

Data governance

Tools

Snowflake

SQL

ETL tools

Job description

Beacon Hill Staffing Group, LLC is seeking a remote Data Engineer specialized in Snowflake for a 6+ month contract. The role requires 5+ years in Snowflake/data warehousing, with Snowflake Certification and strong SQL skills.

You will design, implement, and optimize Snowflake objects, models, and queries to support analytics and BI initiatives. Responsibilities include building fact/dimension tables, tuning performance, and ensuring data quality and governance across environments.