Snowflake Data Engineer

Beacon Hill Staffing Group, LLC; Carson City (NV); Remote; USD 110,000 - 138,000; Full time

Job summary

Beacon Hill Staffing Group is seeking an experienced Data Engineer for a remote 6+ month contract focused on Snowflake data warehousing. You will design, develop, and optimize Snowflake databases, schemas, and data models to support analytics and BI initiatives.

The role requires hands-on Snowflake work, advanced SQL, and strong data modeling skills, with a focus on performance tuning, scalability, and governance across environments. Competitive hourly rate offered.

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 Snowflake databases, schemas, tables, views, and 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.

Responsibilities

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

Data modeling

Performance tuning

Data warehousing

Education

Snowflake Certification

Job description

Beacon Hill was founded to set a new standard in search, career placement and flexible staffing.

Location: Remote
Duration: 6+ month contract
Rate: 80-100/hr

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.

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

Beacon Hill is an equal opportunity employer and individuals with disabilities and/or protected veterans are encouraged to apply.

California residents: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.

Company Profile

Beacon Hill Technologies, a premier National Information Technology Staffing Group, provides world class technology talent across all industries utilizing a complete suite of staffing services. Beacon Hill Technologies' dedicated team of recruiting and staffing experts consistently delivers quality IT professionals to solve our customers' technical and business needs. Beacon Hill Technologies covers a broad spectrum of IT positions, including Project Management and Business Analysis, Programming/Development, Database, Infrastructure, Quality Assurance, Production/Support and ERP roles. Learn more about Beacon Hill and our specialty divisions, Beacon Hill Associates, Beacon Hill Financial, Beacon Hill HR, Beacon Hill Legal, Beacon Hill Life Sciences and Beacon Hill Technologies by visiting www.bhsg.com.

Benefits Information

• Beacon Hill offers a robust benefit package including, but not limited to, medical, dental, vision, and federal and state leave programs as required by applicable agency regulations to those that meet eligibility. Upon successfully being hired, details will be provided related to our benefit offerings.

We look forward to working with you. Beacon Hill. Employing the Future