Remote Snowflake Data Engineer for Scalable Analytics

Beacon Hill Staffing Group, LLC; Montpelier (VT); 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 Data Engineer to design, develop, and maintain Snowflake databases and data models for analytics and BI initiatives. This remote, 6+ month contract role offers a competitive hourly rate and the opportunity to work with cross-functional teams.

You'll optimize queries, implement dimensional modeling, and ensure data quality, governance, and cost efficiency across Snowflake environments while collaborating with data architects, analysts, and stakeholders.

Qualifications

• 5+ years as a Data Engineer or similar role.
• Snowflake Certification required.
• Strong Snowflake experience and database object management.
• Advanced SQL development and query optimization.
• Experience with dimensional modeling and star schemas.
• Experience with large-scale data warehousing.

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, tables, views, and objects.
• Create and optimize data models to support analytics and BI initiatives.
• Develop and maintain fact and dimension tables using dimensional modeling.
• Write and optimize complex Snowflake SQL queries and data transformations.
• Implement performance tuning, including clustering keys and warehouse sizing.
• Monitor Snowflake performance, scalability, and cost efficiency.
• Collaborate with data architects, analysts, and stakeholders to design scalable solutions.
• Ensure data quality, integrity, security, and governance across Snowflake environments.
• Support enhancements to the enterprise data warehouse and analytics ecosystem.

Skills

Data engineering

Snowflake SQL

Data modeling

Data warehousing

Performance tuning

Tools

Snowflake

Job description

Beacon Hill Staffing Group, LLC is seeking a Data Engineer to design, develop, and maintain Snowflake databases and data models for analytics and BI initiatives. This remote, 6+ month contract role offers a competitive hourly rate and the opportunity to work with cross-functional teams.

You'll optimize queries, implement dimensional modeling, and ensure data quality, governance, and cost efficiency across Snowflake environments while collaborating with data architects, analysts, and stakeholders.