Remote Snowflake Data Engineer (6+ Month Contract)

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

Job summary

Beacon Hill Technologies, a premier National Information Technology Staffing Group, is seeking a Senior Data Engineer with Snowflake expertise for a remote, 6+ month contract. The role focuses on designing and optimizing Snowflake databases, implementing scalable data models, and delivering high-performance data transformations.

Responsibilities include building and maintaining Snowflake objects, tuning queries, and collaborating with stakeholders to support analytics and BI initiatives.

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

Data engineering

SQL

Snowflake

Data modeling

Performance tuning

ETL/ELT

Tools

Snowflake

SQL

Job description

Beacon Hill Technologies, a premier National Information Technology Staffing Group, is seeking a Senior Data Engineer with Snowflake expertise for a remote, 6+ month contract. The role focuses on designing and optimizing Snowflake databases, implementing scalable data models, and delivering high-performance data transformations.

Responsibilities include building and maintaining Snowflake objects, tuning queries, and collaborating with stakeholders to support analytics and BI initiatives.