Remote Snowflake Data Engineer - Analytics & Performance

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

Job summary

Beacon Hill Staffing Group, LLC is seeking a Remote Data Engineer with 5+ years of Snowflake experience for a 6+ month contract. You will design, develop, and optimize Snowflake databases, schemas, and data models to support analytics and BI initiatives.

Responsibilities include building fact/dimension tables, writing advanced SQL, tuning performance, and ensuring data quality and governance across Snowflake environments. Collaboration with architects, analysts, and stakeholders is essential.

Qualifications

• 5+ years 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 Snowflake 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 data models to support analytics, reporting, and BI initiatives.
• Develop and maintain fact and dimension tables using dimensional modeling best practices.
• Write, optimize, and troubleshoot 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

5+ years experience

Snowflake Certification

Snowflake development

SQL optimization

Data modeling

Snowflake performance tuning

Large-scale data warehousing

Database design principles

Job description

Beacon Hill Staffing Group, LLC is seeking a Remote Data Engineer with 5+ years of Snowflake experience for a 6+ month contract. You will design, develop, and optimize Snowflake databases, schemas, and data models to support analytics and BI initiatives.

Responsibilities include building fact/dimension tables, writing advanced SQL, tuning performance, and ensuring data quality and governance across Snowflake environments. Collaboration with architects, analysts, and stakeholders is essential.