Comerit Logo

Comerit

Snowflake Data Engineer

Reposted 14 Days Ago
Remote
Hiring Remotely in USA
Mid level
Remote
Hiring Remotely in USA
Mid level
This role involves designing, building, and maintaining data pipelines on Snowflake. Responsibilities include ensuring data quality and collaborating with stakeholders to deliver solutions.
The summary above was generated by AI

This is a remote position.

The Snowflake Data Engineer will be a member of the data engineering team for creating a data vault and data warehouse on Snowflake. This role will focus on building and maintaining scalable, efficient, and reliable data pipelines using the Snowflake Data Cloud. The ideal candidate will have extensive knowledge of Snowflake's architecture, features, and best practices.


Responsibilities:


1. Design, build, and maintain efficient, scalable, and reliable data pipelines using Snowflake and other relevant data integration tools.

2. Collaborate with data architects, analysts, and business stakeholders to understand data needs and deliver end-to-end solutions.

3. Optimize and performance-tune Snowflake data processes using best practices such as clustering keys, materialized views, and caching.

4. Ensure data quality, accuracy, and security by implementing proper validation, monitoring, and access controls.

5. Monitor data processing operations to ensure timely and successful completion, and proactively troubleshoot any issues.

6. Stay updated with the latest Snowflake features, upgrades, and best practices to continually improve data processes.

7. Translate complex functional and technical requirements into detailed designs.

8. Contribute to the team's knowledge by providing guidance, conducting code reviews, and sharing expertise.



Requirements
•    Minimum of [specific number, e.g., "3"] years of experience as a Data Engineer or similar role with hands-on experience with Snowflake.
•    Strong SQL skills and experience with Snowflake utilities like SnowSQL, SnowPipe, and SnowPark.
•    Familiarity with data modeling concepts and ETL processes.
      o    Data Vault 2.0
      o    Kimball Data Marts
•    Snowflake SnowPro certification
•    Familiarity with scripting languages like Python.
•    Strong problem-solving skills and attention to detail.
•    Excellent communication and collaboration skills
•    Experience with AWS cloud platforms
•    Experience with Agile methodology

Similar Jobs

7 Days Ago
In-Office or Remote
Senior level
Senior level
Software
Design, develop, and maintain scalable ETL/ELT pipelines and Snowflake data models; optimize performance; ensure data quality and integrations with CRM/ERP/billing systems; collaborate with stakeholders and evolve a Snowflake/dbt cloud-native data platform.
Top Skills: MatillionSnowflakeSQL
12 Days Ago
In-Office or Remote
98K-163K Annually
Senior level
98K-163K Annually
Senior level
Consulting
Design, build, and optimize Snowflake-based data platforms, ELT/ETL pipelines, and lakehouse architectures. Implement Snowpipe, Streams, Tasks, Snowpark and Cortex features, secure/RBAC controls, performance tuning, production support, and integrations across cloud/on-prem/SaaS sources to support analytics and AI initiatives.
Top Skills: AWSAzureCdcCi/CdDbtDynamic TablesEltETLGCPGitInfrastructure As CodePythonRbacSnowflakeSnowflake CortexSnowparkSnowpipeSQLStored ProceduresStreamsTasksUdfs
12 Days Ago
In-Office or Remote
113K-188K Annually
Senior level
113K-188K Annually
Senior level
Consulting
Design, build, and optimize enterprise Snowflake data solutions and scalable ELT/ETL pipelines. Implement Snowflake-native ingestion (Snowpipe, Streams, Tasks, Dynamic Tables), Snowpark, SQL-based transformations, governance (RBAC), performance tuning, production support, and integrations across cloud, on‑prem, API, and SaaS sources. Support AI initiatives using Snowflake Cortex and Snowpark.
Top Skills: AWSAzureCdcCi/CdDbtDynamic TablesEltETLGCPGitInfrastructure As CodePythonRbacSnowflakeSnowflake CortexSnowparkSnowpipeSQLStored ProceduresStreamsTasksUdfs

What you need to know about the Colorado Tech Scene

With a business-friendly climate and research universities like CU Boulder and Colorado State, Colorado has made a name for itself as a startup ecosystem. The state boasts a skilled workforce and high quality of life thanks to its affordable housing, vibrant cultural scene and unparalleled opportunities for outdoor recreation. Colorado is also home to the National Renewable Energy Laboratory, helping cement its status as a hub for renewable energy innovation.

Key Facts About Colorado Tech

  • Number of Tech Workers: 260,000; 8.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Lockheed Martin, Century Link, Comcast, BAE Systems, Level 3
  • Key Industries: Software, artificial intelligence, aerospace, e-commerce, fintech, healthtech
  • Funding Landscape: $4.9 billion in VC funding in 2024 (Pitchbook)
  • Notable Investors: Access Venture Partners, Ridgeline Ventures, Techstars, Blackhorn Ventures
  • Research Centers and Universities: Colorado School of Mines, University of Colorado Boulder, University of Denver, Colorado State University, Mesa Laboratory, Space Science Institute, National Center for Atmospheric Research, National Renewable Energy Laboratory, Gottlieb Institute

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account