Remote Snowflake Data Engineer — Scale & Optimize Analytics

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

Job summary

Beacon Hill Staffing Group, LLC is seeking a seasoned Data Engineer to design, develop, and optimize Snowflake databases and data models for analytics and BI initiatives. The role focuses on building scalable data solutions, ensuring data quality, and collaborating with stakeholders in a remote, 6+ month contract.

Candidates should have 5+ years in data engineering, Snowflake Certification, and expert SQL skills, with experience in dimensional modeling and performance tuning.

Qualifications

• 5+ years of experience as a Data Engineer or similar role.
• Snowflake Certification required
• Advanced SQL development and query optimization skills.
• Experience with dimensional modeling, star schemas, and fact/dimension design.
• Snowflake performance tuning and optimization experience.

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

5+ years experience

Snowflake

SQL development

Data modeling

Performance tuning

Tools

Snowflake

Job description

Beacon Hill Staffing Group, LLC is seeking a seasoned Data Engineer to design, develop, and optimize Snowflake databases and data models for analytics and BI initiatives. The role focuses on building scalable data solutions, ensuring data quality, and collaborating with stakeholders in a remote, 6+ month contract.

Candidates should have 5+ years in data engineering, Snowflake Certification, and expert SQL skills, with experience in dimensional modeling and performance tuning.