PamTen Inc · 5 months ago
Sr Data Snowflake Engineer
United States
Full-time
Remote
Senior Level
5+ years expPamTen Inc is seeking an experienced Snowflake Data Engineer to join their dynamic data engineering team. The role involves designing, implementing, and optimizing Snowflake-based data solutions while utilizing SQL, Airflow, and UNIX for data transformations and workflow orchestration.
Enterprise Software
Responsibilities
Design, build, and maintain Snowflake data warehouses and ETL pipelines
Develop and optimize SQL queries for data extraction, transformation, and reporting
Create and manage DAGs (Directed Acyclic Graphs) using Airflow for data workflows
Implement best practices for Snowflake performance tuning, cost optimization, and scalability
Manage UNIX-based environments, perform shell scripting, and automate system processes
Collaborate with data analysts, data scientists, and other stakeholders to deliver high-quality data solutions
Troubleshoot and resolve performance issues in Snowflake, Airflow, and UNIX environments
Qualification
Required
In-depth understanding of Snowflake architecture, security, and performance optimization
Strong ability to write and optimize complex SQL queries for data manipulation and reporting
Hands-on experience with designing, building, and maintaining data pipelines using Apache Airflow
Experience in UNIX/Linux environments, with proficiency in shell scripting and system administration
Experience with ETL processes and data warehousing concepts
Ability to analyze and solve complex technical issues across different environments
Bachelor's degree in Computer Science, Information Systems, or a related field
5 years of experience in Snowflake development, SQL, Airflow, and UNIX
Preferred
Experience with cloud services (AWS, Azure, GCP) for deploying and managing Snowflake environments
Familiarity with Python or other scripting languages for data pipeline automation
Knowledge of version control systems (e.g., Git)
Experience working in an Agile development environment
Company
PamTen Inc
PAMTEN is established in the year 2007 as a technology services company, and a Women Owned Business Enterprise registered in New Jersey.
51-200 employees
H1B Sponsorship
PamTen Inc has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (84)
2024 (112)
2023 (100)
2022 (100)
2021 (109)
2020 (237)
Funding
Current Stage
Growth StageLeadership Team
Chaya Pamula
Co-Founder, President & CEO
Anthony Pirozzi
Chief Financial Officer
Recent News
2023-12-23
Company data provided by crunchbase