Snowflake Data Engineer - ETL (W2)

Snowrelic Inc; United States; On-site; USD 100,000 - 130,000; Full time

Job summary

Snowrelic Inc is hiring a Data Engineer to design and build scalable data pipelines and migrate legacy systems to AWS and Snowflake. This remote role requires strong experience in data engineering, including proficiency in AWS, Snowflake, and Python. Responsibilities include developing and optimizing ETL/ELT processes, implementing data governance, and collaborating with stakeholders. Ideal candidates have experience with various relational databases and data modeling. This position is a 6-month contract to hire.

Qualifications

• Strong experience with AWS and Snowflake.
• Proficiency in Python for data engineering.
• Experience building ETL/ELT pipelines.
• Data warehousing and data modeling experience.
• Experience with relational databases (Oracle, SQL Server).
• Git-based version control.

Responsibilities

• Design, build, and maintain scalable data pipelines.
• Migrate legacy pipelines (Informatica, Teradata) to AWS/Snowflake.
• Develop and optimize ETL/ELT processes.
• Build and manage data warehouse and data models.
• Implement data governance, security, and quality standards.

Skills

AWS (Glue, CDK, cloud data services)

Snowflake

Python

ETL/ELT Data Pipeline Development - Informatica

Tools

Informatica

MongoDB

Oracle

SQL Server

Job description

Role: Data Engineer

Location: Remote

Duration: 6 month contract to hire

Visa: USC, GC, EAD-GC

A Data Engineer who will design, build and modernize data pipelines and data platforms in a cloud environment. This role focuses on migrating legacy data systems to AWS and Snowflake, developing scalable ETL/ELT pipelines, and supporting analytics and business intelligence through strong data modeling and architecture. Day to day, this person will work hands‑on with pipelines, collaborate with cross‑functional teams, and contribute to a cloud data modernization initiative.

Legacy to Snowflake Migration

Snowflake Migration Expert

Top 5 Skills

• AWS (Glue, CDK, cloud data services)
• Snowflake
• Python
• ETL/ELT Data Pipeline Development - Informatica is preferred

Responsibilities

• Design, build, and maintain scalable data pipelines
• Migrate legacy pipelines (Informatica, Teradata) to AWS/Snowflake
• Develop and optimize ETL/ELT processes
• Build and manage data warehouse and data models (star schema, dimensional)
• Work with RDBMS (Oracle, SQL Server, RDS) and MongoDB
• Implement data governance, security, and quality standards
• Collaborate with business stakeholders and data teams
• Develop and test data features and integrations
• Monitor performance and optimize cloud costs
• Contribute to Agile development processes

Qualifications

Required

• Strong experience with AWS and Snowflake
• Proficiency in Python for data engineering
• Experience building ETL/ELT pipelines
• Data warehousing and data modeling experience
• Experience with relational databases (Oracle, SQL Server)
• Git-based version control

Nice To Have

• MongoDB or document database experience
• Experience migrating legacy data platforms
• AWS Glue and CDK
• Agile tools (JIRA, Confluence)
• Experience mentoring junior engineers