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
Designs, develops, and supports analytics data solutions for clients, including Snowflake and dbt ingestion and transformation pipelines, data marts, validation, monitoring, governance, and documentation. Manages multiple consulting projects, budgets, timelines, quality assurance, troubleshooting, client communication, and implementation planning. Requires strong data engineering experience, regulated-industry knowledge, stakeholder communication, and willingness to travel.
Top Skills:
AWSDbtSnowflakeSQL
Fintech • Financial Services
Design, develop, and maintain scalable ETL/ELT pipelines using Python, PySpark, Snowflake, and Azure technologies. Build data ingestion frameworks, dimensional data models, and enterprise warehouse solutions. Optimize Snowflake workloads, implement data quality and governance controls, monitor production pipelines, troubleshoot incidents, document data processes, and collaborate with architects, analysts, data scientists, and business stakeholders. Support secure, compliant, reliable data platforms for analytics, reporting, and operational use cases.
Top Skills:
AzureAzure Data FactoryAzure Data Lake Storage (Adls)Azure DevopsAzure Key VaultCi/CdGitPower BIPysparkPythonRest ApisSnowflakeSQLTableauTerraform
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
What you need to know about the Boston Tech Scene
Boston is a powerhouse for technology innovation thanks to world-class research universities like MIT and Harvard and a robust pipeline of venture capital investment. Host to the first telephone call and one of the first general-purpose computers ever put into use, Boston is now a hub for biotechnology, robotics and artificial intelligence — though it’s also home to several B2B software giants. So it’s no surprise that the city consistently ranks among the greatest startup ecosystems in the world.
Key Facts About Boston Tech
- Number of Tech Workers: 269,000; 9.4% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: Thermo Fisher Scientific, Toast, Klaviyo, HubSpot, DraftKings
- Key Industries: Artificial intelligence, biotechnology, robotics, software, aerospace
- Funding Landscape: $15.7 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Summit Partners, Volition Capital, Bain Capital Ventures, MassVentures, Highland Capital Partners
- Research Centers and Universities: MIT, Harvard University, Boston College, Tufts University, Boston University, Northeastern University, Smithsonian Astrophysical Observatory, National Bureau of Economic Research, Broad Institute, Lowell Center for Space Science & Technology, National Emerging Infectious Diseases Laboratories
