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
Fintech • Payments • Financial Services
Design, develop, test, maintain, and support secure, scalable data solutions using Snowflake and Databricks. Lead technical design, author specifications, review code, mentor engineers, ensure SDLC, audit/security compliance, and drive technical strategy while collaborating with architects and business partners. Participate in Agile ceremonies, be on-call as needed, and travel occasionally.
Top Skills:
AzureDatabricksEltETLPysparkPythonSnowflakeSQL
Fintech
Build and own data quality and observability for the data platform: profile data, define quality rules, set metrics/SLAs, monitor and alert, investigate and resolve data issues at source, and partner with data engineering and business stakeholders on standards and reporting.
Top Skills:
Claude CodeCursorDbtGitGreat ExpectationsMonte CarloOpenai CodexSnowflakeSodaSQL
Healthtech • Insurance • Retail • Social Impact
Designs, builds, and maintains scalable ETL/ELT data pipelines and integrations. Profiles and cleanses data, creates mappings and SQL, documents metadata, monitors data quality, participates in code reviews, and collaborates with analytics, DBAs, and business partners to enable accurate analytics and data warehousing.
Top Skills:
Apache AirflowApache KafkaAWSAws GlueAxwayAzureCi/CdConfluentData VaultDataopsDenodoGCPGitIbm Infosphere DatastageInformatica PowercenterMs SsisMulesoftNetezzaOracle Data IntegratorRedshiftSnowflakeSQLTeradata
What you need to know about the Chicago Tech Scene
With vibrant neighborhoods, great food and more affordable housing than either coast, Chicago might be the most liveable major tech hub. It is the birthplace of modern commodities and futures trading, a national hub for logistics and commerce, and home to the American Medical Association and the American Bar Association. This diverse blend of industry influences has helped Chicago emerge as a major player in verticals like fintech, biotechnology, legal tech, e-commerce and logistics technology. It’s also a major hiring center for tech companies on both coasts.
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
