Remote Snowflake Data Engineer - Scale Analytics

Beacon Hill Staffing Group, LLC; Columbia (SC); 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 Remote Data Engineer specializing in Snowflake to design, develop, and optimize Snowflake databases and data models. The role supports analytics, BI, and enterprise data warehouse initiatives, ensuring data quality and governance across environments.

Requirements include 5+ years in data engineering/warehouse roles, Snowflake Certification, and strong SQL and data modeling skills.

Qualifications

• 5+ years of experience in 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 objects: databases, schemas, tables, views, and objects
• Advanced SQL development and query optimization skills
• Experience with dimensional modeling, star schemas, and fact/dimension design
• Experience with large-scale data warehousing and analytics environments

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 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.

Job description

Beacon Hill Staffing Group, LLC is seeking a Remote Data Engineer specializing in Snowflake to design, develop, and optimize Snowflake databases and data models. The role supports analytics, BI, and enterprise data warehouse initiatives, ensuring data quality and governance across environments.

Requirements include 5+ years in data engineering/warehouse roles, Snowflake Certification, and strong SQL and data modeling skills.