Snowflake / ETL/ELT Architect

Overview

Remote
Depends on Experience
Contract - Independent
Contract - W2
Contract - 24 Month(s)
Able to Provide Sponsorship

Skills

Amazon SES
Amazon Web Services
Cloud Computing
Data Modeling
Data Processing
Data Quality
ELT
Extract
Transform
Load
File Systems
Geocoding
Python
Real-time
Snow Flake Schema
Star Schema

Job Details

 

Infinite Solutions Inc, headquartered at Sacramento, California, focuses on global delivery model to meet the needs of its most valued customers. Infinite Solutions Inc provides services in the areas of IT consulting, development, training and mentoring.

Infinite Solutions Inc. is looking for a qualified individual to fill the role of a Snowflake ETL/ELT Architect

Mandatory skills

    1. Senior Data Engineer 

      1. Minimum of four (4) years of relevant experiences in authoring and monitoring data pipelines.
      2. Minimum three (3) years of experience with Snowflake, ETL/ELT (dbt, AWS file systems, SES/SNS, Lambda (Boto 3), Python.
      3. Minimum three (3) years of experience with micro-batch data processing, near real-time ingestion.  Expertise in data modeling (Data Vault 2, Star Schema).
      4. Minimum three (3) years of experience in Orchestrating data enrichment specifically geocoding of addresses to latitude and longitude as part of the ELT process
      5. Minimum three (3) years of experience with with modern data pipeline architecture using DBT, Snowflake on a cloud platform, preferably in AWS
      6. Minimum three (3) years of experience with DBT / Snowflake Incremental Refreshes and materializations and snowflake cost optimizations on large volumes of data received hourly.
      7. Minimum three (3) years of experience in handling PII and other types of privileged data.
      8. Minimum three (3) years in depth experience and knowledge of data quality management.

If you are qualified/interested for this position please send your resume to

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.