Design, implement, and optimize Snowflake data storage and ETL solutions. Write and tune SQL, integrate data sources and BI tools, ensure data security and compliance, and collaborate with teams to meet business objectives.
This is a remote position.
Remote Snowflake Data Engineer - US Citizens only.
Responsibilities and Duties
- Design and implement scalable and efficient data storage solutions using Snowflake.
- Write, optimize, and troubleshoot SQL queries within the Snowflake environment.
- Integrate Snowflake with various data sources and third-party tools.
- Ensure data security and compliance with industry standards.
- Collaborate with cross-functional teams to meet data-driven business objectives.
- Stay updated with the latest Snowflake features and best practices.
Requirements
Skills and qualifications
- Proficient in SQL and familiar with ETL processes
- Experience with data modeling and cloud computing environments
- Hands-on experience with Snowflake features like Time Travel and Zero-Copy Cloning
- Understanding of data compliance and security best practices
- Preferred skills and experience:
- Familiarity with BI tools integration, such as Tableau or Looker
- Proven track record of data migration and optimization within Snowflake
- Ability to translate business needs into technical specifications
- Experience in performance tuning and cost optimization in a cloud data platform
Similar Jobs
Information Technology • Consulting
Design, build, and maintain scalable Snowflake data pipelines and workflows. Ingest, transform, and deliver data from EHRs, claims, APIs, and CRM systems into analytics-ready structures. Optimize Snowflake performance and costs through warehouse sizing, query tuning, data modeling, and security design. Implement orchestration, DevOps, version control, and CI/CD practices while collaborating with client architects and analysts. The role also involves explaining technical tradeoffs, supporting repeatable deployments, adapting to unfamiliar challenges, and mentoring others.
Top Skills:
Apache AirflowAWSAzureAzure Data FactoryBigQueryCi/CdDatabricksDbtDynamic TablesEpic CaboodleEpic ClarityFhirFlywayGCPGitHl7IcebergJavaKafkaKinesisLiquibaseNetezzaOraclePub/SubPythonRedshiftScalaSchemachangeSnowflakeSnowflake Cortex AiSnowflake StreamsSnowflake TasksSnowparkSnowpipe StreamingSQLSQL ServerStreamlitTeradataTerraform
Software
Design and build modern GCP lakehouse architectures, including Python and Spark pipelines, BigQuery ingestion, Kafka CDC, Delta Lake and Iceberg UniForm integrations, Delta Sharing endpoints, Snowflake and Databricks connectivity, data lineage, governed access controls, and semantic-layer alignment. Collaborate cross-functionally, troubleshoot full-stack issues, and deliver reusable data-sharing adapters and end-to-end data features.
Top Skills:
Apache IcebergSparkBigQueryChange Data Capture (Cdc)DatabricksDatabricks Unity CatalogDelta LakeDelta SharingGCPGoogle Cloud StorageIceberg UniformKafkaLookmlPythonSnowflakeSnowflake Horizon Catalog
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
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
