Data Engineer (Snowflake)

TEK NINJAS; United States; Remote; USD 100,000 - 130,000; Full time

Job summary

A leading IT services provider is seeking a Mid-Senior level Data Engineer to design, develop, and optimize Snowflake data warehouses. The ideal candidate will have over 9 years of experience in data engineering, strong SQL skills, and hands-on experience with ETL/ELT tools. This remote position may require occasional travel and offers a full-time contract in the technology sector.

Qualifications

• 9+ years of experience in data engineering and data warehousing.
• 4+ years of experience with hands-on Snowflake development.
• Strong expertise in SQL, especially complex queries.
• Proficiency with various ETL/ELT tools.

Responsibilities

• Design and optimize Snowflake data warehouses for performance.
• Build and manage ETL/ELT pipelines using various tools.
• Integrate Snowflake with BI tools and cloud environments.
• Document solutions and workflows for future use.

Skills

Data engineering and data warehousing experience

Hands-on Snowflake development and administration

SQL expertise (complex queries, performance tuning)

Proficiency with ETL/ELT tools (dbt, Informatica, Talend)

Data modeling and schema design

CI/CD for data pipelines

Data security and governance knowledge

Problem-solving and debugging skills

Tools

Snowflake

Informatica

Talend

Apache Airflow

Azure Data Factory

Tableau

Power BI

Looker

Qlik

Python

Scala

Docker

Kubernetes

Git

Jenkins

Azure DevOps

GitHub Actions

Job description

Location: Remote (Occasional Travel Required)

Contract Type: Full-Time

Experience: 9+ Years

Responsibilities

• Design, develop, and optimize Snowflake data warehouses for performance and scalability.
• Build and manage ETL/ELT pipelines using tools such as Informatica, Talend, dbt, Apache Airflow, or Azure Data Factory.
• Implement data modeling (Star Schema, Snowflake Schema, Data Vault) and best practices for analytics and reporting.
• Work with SQL, stored procedures, UDFs, and tasks within Snowflake.
• Optimize Snowflake warehouses, partitions, clustering, caching, and query performance.
• Ensure data security and governance with RBAC, masking, and encryption.
• Integrate Snowflake with BI tools (Tableau, Power BI, Looker, Qlik) and external systems.
• Collaborate with cloud engineers to integrate Snowflake within AWS, Azure, or GCP ecosystems.
• Participate in code reviews, performance tuning, and troubleshooting.
• Document solutions, workflows, and design patterns for future use.

Required Skills

• 9+ years of data engineering and data warehousing experience.
• 4+ years of hands-on Snowflake development and administration.
• Strong expertise in SQL (complex queries, performance tuning, optimization).
• Proficiency with ETL/ELT tools (dbt, Informatica, Talend, Airflow, ADF, Glue).
• Experience with data modeling and schema design.
• Familiarity with CI/CD for data pipelines (Git, Jenkins, Azure DevOps, GitHub Actions).
• Strong understanding of data security, compliance, and governance.
• Excellent problem-solving and debugging skills.

Desired Skills

• Experience with real-time/streaming data ingestion (Kafka, Kinesis, Pub/Sub).
• Hands-on with Python or Scala for data transformations.
• Knowledge of containerization and orchestration (Docker, Kubernetes).
• Exposure to machine learning workflows integrated with Snowflake.
• Cloud certifications (SnowPro Core/Advanced, AWS Data Analytics Specialty, Azure Data Engineer, GCP Data Engineer).
• Strong leadership and mentoring abilities.

Seniority level

• Mid-Senior level

Employment type

• Full-time

Job function

• Information Technology

Industries

• IT Services and IT Consulting and Software Development