Senior Data Engineer- Snowflake Expert(Only w2)

Astir IT Solutions, Inc.; New Jersey; Remote; USD 140,000 - 190,000; Full time

Job summary

Astir IT Solutions, Inc. is seeking a Senior Data Engineer with hands-on Snowflake expertise to design scalable data pipelines and enterprise data applications for remote delivery.

You will build and optimize Snowflake-based solutions, and collaborate across analytics and AI teams to deliver production-ready data services. Key skills include Snowflake Native Apps, Snowpark, PySpark, Python, SQL, and Databricks integration.

Qualifications

• 12+ years of experience in data engineering or software engineering.
• Strong hands-on experience with Snowflake Native Apps, Snowpark (Python), and Snowflake SQL.
• Strong expertise in Python, SQL, Spark/PySpark, and Databricks.
• Experience building scalable ETL/ELT pipelines and data integration frameworks.

Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, Snowpark, Databricks, and PySpark.
• Build and optimize ETL/ELT workflows and enterprise data models.
• Develop Snowflake Native Apps and data-driven applications.
• Optimize data processing, SQL queries, and compute resources for performance and cost.
• Collaborate with architecture, analytics, and AI teams to deliver production-ready data solutions.
• Support data governance, quality, security, and CI/CD for data platforms.

Skills

12+ years experience

Snowflake Native Apps

Snowpark (Python)

Snowflake SQL

Python

SQL

Apache Spark/PySpark

Databricks

ETL/ELT pipelines

REST APIs

CI/CD

AI-ready data solutions

Tools

Snowflake

Snowpark

Databricks

Spark/PySpark

CI/CD

Job description

Role : Senior Data Engineer- Snowflake Expert(Only w2)

Location : Remote

Visa Type : Only US Citizen

Minimum 12+ Years of Experience required.

JD:

Seeking a Senior Data Engineer with strong hands-on experience in Snowflake, Snowpark, Snowflake Native Apps, and Databricks. The ideal candidate will design and develop scalable data pipelines, enterprise data applications, and AI-ready data solutions, with expertise in Python, SQL, PySpark, and Snowflake/Databricks integration.

Required Skills

• 12+ years of experience in Data Engineering, Software Engineering, or related roles.
• Strong hands-on experience with Snowflake Native Apps, Snowpark (Python), and Snowflake SQL.
• Strong expertise in Python, SQL, Apache Spark/PySpark, and Databricks.
• Experience building scalable ETL/ELT pipelines, data transformations, and data integration frameworks.
• Experience with Snowflake Cortex AI, Cortex Search, or Cortex Analyst.
• Experience integrating Snowflake and Databricks for enterprise data and analytics workloads.
• Understanding of data modeling, data quality, governance, distributed computing, and performance tuning.
• Experience supporting AI applications, RAG pipelines, LLMs, or AI-powered data solutions.
• Knowledge of REST APIs, CI/CD, automated testing, and production deployment practices.

Preferred Skills

• Databricks Unity Catalog, Delta Lake, MLflow, Mosaic AI, and Workflows.
• LangChain, LangGraph, LlamaIndex, OpenAI SDK, or Anthropic Claude SDK.
• FastAPI, microservices, Docker, Kubernetes, and Terraform.
• Experience publishing Snowflake Native Apps to the Snowflake Marketplace.
• SnowPro or Databricks certifications.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using Snowflake, Snowpark, Databricks, and PySpark.
• Build and optimize ETL/ELT workflows and enterprise data models.
• Develop Snowflake Native Apps and data-driven applications.
• Optimize data processing, SQL queries, and compute resources for performance and cost.
• Integrate enterprise data sources, APIs, Snowflake, and Databricks.
• Support AI/ML use cases through reliable, governed, AI-ready data pipelines.
• Implement data quality, security, access controls, CI/CD, and engineering best practices.
• Collaborate with architecture, analytics, and AI teams to deliver production-ready data solutions.