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
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
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
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 NYC Tech Scene
As the undisputed financial capital of the world, New York City is an epicenter of startup funding activity. The city has a thriving fintech scene and is a major player in verticals ranging from AI to biotech, cybersecurity and digital media. It also has universities like NYU, Columbia and Cornell Tech attracting students and researchers from across the globe, providing the ecosystem with a constant influx of world-class talent. And its East Coast location and three international airports make it a perfect spot for European companies establishing a foothold in the United States.
Key Facts About NYC Tech
- Number of Tech Workers: 549,200; 6% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Capgemini, Bloomberg, IBM, Spotify
- Key Industries: Artificial intelligence, Fintech
- Funding Landscape: $25.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Greycroft, Thrive Capital, Union Square Ventures, FirstMark Capital, Tiger Global Management, Tribeca Venture Partners, Insight Partners, Two Sigma Ventures
- Research Centers and Universities: Columbia University, New York University, Fordham University, CUNY, AI Now Institute, Flatiron Institute, C.N. Yang Institute for Theoretical Physics, NASA Space Radiation Laboratory
