Senior Remote Snowflake Data Engineer

Beacon Hill Staffing Group, LLC; Bismarck (ND); Remote; USD 110.000 - 138.000; Teilzeit

Benefits dieser Stelle

Remote work

Zusammenfassung

Beacon Hill Staffing Group, LLC is seeking a seasoned Data Engineer to design, develop, and optimize Snowflake data assets for analytics and BI initiatives. The role is remote with a 6+ month contract and an hourly rate of 80–100 USD, requiring hands-on Snowflake experience and a Snowflake Certification.

You will build and maintain Snowflake databases, models, and ETL/ELT processes, ensuring data quality, performance, and governance across environments, while collaborating with data architects,

Qualifikationen

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

Aufgaben

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

Kenntnisse

Snowflake data engineering

SQL development

Data modeling (dimensional)

Performance tuning

Large-scale data warehousing

Data governance

Stakeholder collaboration

Tools

Snowflake

Jobbeschreibung

Beacon Hill Staffing Group, LLC is seeking a seasoned Data Engineer to design, develop, and optimize Snowflake data assets for analytics and BI initiatives. The role is remote with a 6+ month contract and an hourly rate of 80–100 USD, requiring hands-on Snowflake experience and a Snowflake Certification.

You will build and maintain Snowflake databases, models, and ETL/ELT processes, ensuring data quality, performance, and governance across environments, while collaborating with data architects,