Remote Snowflake Data Engineer (6+ Month Contract)

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

Benefits offered by this job

Remote work

Equal opportunity employer

Job summary

Beacon Hill Staffing Group, LLC is seeking an experienced Data Engineer to design, develop, and optimize Snowflake data warehouses on a remote, contract basis.

Responsibilities include building Snowflake objects, developing dimensional models, writing advanced SQL, and tuning performance to support analytics and BI initiatives. 5+ years of relevant experience and Snowflake certification are required.

Qualifications

• 5+ years of experience as a Data Engineer, Data Warehouse Engineer, Snowflake Developer, or similar role.
• Snowflake Certification required.
• Hands-on experience developing directly within Snowflake.
• Experience with databases, schemas, tables, views and Snowflake objects.
• Advanced SQL development and query optimization skills.
• Experience with dimensional modeling, star schemas, and fact/dimension design.
• Proven Snowflake performance tuning and optimization experience.

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

Snowflake

SQL

Data Modeling

Performance Tuning

Data Warehousing

Big Data

Stakeholder Collaboration

Tools

dbt

Airflow

Python

ETL Tools

Snowflake UI

Job description

Beacon Hill Staffing Group, LLC is seeking an experienced Data Engineer to design, develop, and optimize Snowflake data warehouses on a remote, contract basis.

Responsibilities include building Snowflake objects, developing dimensional models, writing advanced SQL, and tuning performance to support analytics and BI initiatives. 5+ years of relevant experience and Snowflake certification are required.