Remote Snowflake Data Engineer - Contract (6+ months)

Beacon Hill Staffing Group, LLC; Concord (NH); Remote; USD 229,233,000 - 286,541,000; Full time

Job summary

Beacon Hill Staffing Group, LLC seeks a seasoned Snowflake Data Engineer for a remote, 6+ month contract. You will design, optimize, and maintain Snowflake databases, schemas, and data models to support analytics and BI initiatives.

Candidate must have 5+ years in data engineering, Snowflake certification, strong SQL, data modeling, and performance tuning experience, with a track record of delivering scalable data solutions in large warehousing environments.

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.
• Experience with data modeling methodologies, including dimensional modeling, star schemas, and fact/dimension design.
• Proven experience with Snowflake performance tuning and optimization.
• Experience working with large-scale data warehousing and analytics environments.
• Strong understanding of database design principles and best practices.

Responsibilities

• Design, develop, and maintain Snowflake databases, schemas, tables, views, and other database objects.
• Create and optimize logical and physical data models to support analytics, reporting, and business intelligence 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

Snowflake

SQL

Data modeling

Data warehousing

Performance tuning

Job description

Beacon Hill Staffing Group, LLC seeks a seasoned Snowflake Data Engineer for a remote, 6+ month contract. You will design, optimize, and maintain Snowflake databases, schemas, and data models to support analytics and BI initiatives.

Candidate must have 5+ years in data engineering, Snowflake certification, strong SQL, data modeling, and performance tuning experience, with a track record of delivering scalable data solutions in large warehousing environments.