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
Database • Analytics
Leads the design, development, optimization, and migration of modern data platforms in Snowflake. Builds pipelines with dbt, Python, and cloud services; gathers client requirements; creates solution designs and project plans; advises on Snowflake performance, cost, security, and workload management; integrates BI, governance, and AI/ML tools; contributes to accelerators and mentors junior engineers. The role is remote, client-facing, consultative, and focused primarily on technical delivery rather than sales.
Top Skills:
Apache AirflowAWSAzureCloverdxDbtFivetranGoogle Cloud PlatformInformaticaLookerPower BIPythonSnowflakeSnowparkSnowpipeSQL
Artificial Intelligence • Cloud • Information Technology • Consulting
Design and optimize Snowflake data warehouses, dbt transformation models, and scalable ETL/ELT pipelines. Develop ingestion utilities, improve SQL and warehouse performance, establish data quality and governance controls, and maintain CI/CD workflows using Git. Collaborate with analysts, data scientists, and business stakeholders across manufacturing, supply chain, and operations. The role also supports modern DataOps practices and may involve orchestration tools and cloud platforms.
Top Skills:
Apache AirflowAWSAzureDagsterDbtGCPGitGithub ActionsGitlab CiOraclePrefectPythonSAPScalaSnowflakeSQL
Artificial Intelligence • Cloud • Information Technology • Consulting
Build and maintain scalable ETL/ELT pipelines using Azure Data Factory, Snowflake, dbt, and SQL. Develop data models, transformations, tests, and documentation; ingest data from APIs, databases, files, and enterprise applications; optimize performance; ensure data quality; troubleshoot failures; and support production deployments and monitoring.
Top Skills:
AzureAzure Data FactoryAzure DevopsAzure FunctionsAzure Key VaultAzure StorageCi/CdCsvDatabricksDbtGitJinjaJSONPysparkPythonRest ApisSnowflakeSQL
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
