Senior Python Developer with Snowflake

Petadata; Austin (TX); On-site; USD 140,000 - 190,000; Part time

Job summary

PETADATA is seeking a Senior Python Developer with Snowflake experience to design and optimize scalable data solutions for enterprise platforms. You will build and maintain Python-based processing and ETL/ELT pipelines, implement Snowflake data warehouses, and collaborate with data architects and stakeholders.

The role requires 12+ years in Python/data engineering, strong SQL, Airflow, and cloud experience across AWS/Azure/GCP.

Qualifications

• 12+ years of experience in Python development, Data Engineering, or related fields.
• Strong expertise in Python Programming (OOP, Multithreading, APIs, Data Processing).
• Extensive hands-on experience with Snowflake Data Cloud.
• Strong experience in SQL, query optimization, and database performance tuning.
• Expertise in ETL/ELT Development and data integration methodologies.
• Experience with Data Warehousing, Data Modeling, and dimensional modeling techniques.
• Hands-on experience with PySpark and large-scale data processing frameworks.
• Experience with cloud platforms such as AWS, Azure, or GCP.
• Strong knowledge of Apache Airflow, workflow orchestration, and scheduling tools.
• Experience with REST APIs, JSON, and third-party integrations.
• Proficiency in version control tools such as Git/GitHub.
• Experience with CI/CD Pipelines, Docker, and Kubernetes.
• Knowledge of DBT (Data Build Tool) is highly preferred.
• Familiarity with Kafka or other streaming technologies is a plus.
• Strong analytical, troubleshooting, and problem-solving skills.
• Excellent communication and stakeholder management skills.

Responsibilities

• Design, develop, and maintain scalable data processing applications using Python and Snowflake.
• Build and optimize enterprise-level ETL/ELT pipelines for data ingestion, transformation, and loading.
• Design and implement efficient Snowflake data warehouse solutions, including schema design, data modeling, and performance optimization.
• Develop reusable and scalable Python frameworks, APIs, and automation solutions.
• Collaborate with business stakeholders, data architects, and cross-functional teams to gather requirements and translate them into technical solutions.
• Optimize SQL queries, stored procedures, and data workflows for maximum performance and reliability.
• Integrate data from various sources including relational databases, APIs, cloud storage, and third-party applications.
• Implement data quality, governance, security, and compliance best practices across the data ecosystem.
• Monitor, troubleshoot, and resolve production issues related to data pipelines and Snowflake environments.
• Lead code reviews, establish development standards, and mentor junior team members.
• Participate in Agile ceremonies including sprint planning, daily stand-ups, and retrospectives.
• Work closely with DevOps teams to implement CI/CD pipelines and automate deployment processes.
• Evaluate and recommend new technologies and best practices to improve platform efficiency and scalability.

Skills

Python

Snowflake

SQL

ETL/ELT

Data Warehousing

Data Modeling

PySpark

AWS

Azure

GCP

Apache Airflow

DBT

REST APIs

Git

CI/CD

Docker

Kubernetes

Kafka

Data Integration

Performance Tuning

Education

Bachelor's or Master's degree in Computer Science/IT/Engineering

Tools

Snowflake

Apache Airflow

Git

Docker

Kubernetes

PySpark

DBT

Job description

Job Title: Senior Python Developer with Snowflake

Experience: 12+ Years

Location: TX (Onsite)

Work type: C2C

Visa Type: GC and US Citizen, H1B,H4-EAD

Job Summary:

PETADATA is seeking a Senior Python Developer with Snowflake having 12+ years of experience in Python development, Snowflake, SQL, ETL/ELT, Data Warehousing, and Cloud Technologies (AWS/Azure/GCP). The candidate will be responsible for building scalable data solutions, optimizing data pipelines, and supporting enterprise data platforms.

Roles & Responsibilities:

• Design, develop, and maintain scalable data processing applications using Python and Snowflake.

• Build and optimize enterprise-level ETL/ELT pipelines for data ingestion, transformation, and loading.

• Design and implement efficient Snowflake data warehouse solutions, including schema design, data modeling, and performance optimization.

• Develop reusable and scalable Python frameworks, APIs, and automation solutions.

• Collaborate with business stakeholders, data architects, and cross-functional teams to gather requirements and translate them into technical solutions.

• Optimize SQL queries, stored procedures, and data workflows for maximum performance and reliability.

• Integrate data from various sources including relational databases, APIs, cloud storage, and third-party applications.

• Implement data quality, governance, security, and compliance best practices across the data ecosystem.

• Monitor, troubleshoot, and resolve production issues related to data pipelines and Snowflake environments.

• Lead code reviews, establish development standards, and mentor junior team members.

• Participate in Agile ceremonies including sprint planning, daily stand-ups, and retrospectives.

• Work closely with DevOps teams to implement CI/CD pipelines and automate deployment processes.

• Evaluate and recommend new technologies and best practices to improve platform efficiency and scalability.

Required Qualifications:

• 12+ years of experience in Python development, Data Engineering, or related fields.

• Strong expertise in Python Programming (OOP, Multithreading, APIs, Data Processing).

• Extensive hands-on experience with Snowflake Data Cloud.

• Strong experience in SQL, query optimization, and database performance tuning.

• Expertise in ETL/ELT Development and data integration methodologies.

• Experience with Data Warehousing, Data Modeling, and dimensional modeling techniques.

• Hands-on experience with PySpark and large-scale data processing frameworks.

• Experience with cloud platforms such as AWS, Azure, or GCP.

• Strong knowledge of Apache Airflow, workflow orchestration, and scheduling tools.

• Experience with REST APIs, JSON, and third-party integrations.

• Proficiency in version control tools such as Git/GitHub.

• Experience with CI/CD Pipelines, Docker, and Kubernetes.

• Knowledge of DBT (Data Build Tool) is highly preferred.

• Familiarity with Kafka or other streaming technologies is a plus.

• Strong analytical, troubleshooting, and problem-solving skills.

• Excellent communication and stakeholder management skills.

Main Skills:

Python, Snowflake, SQL, ETL/ELT, Data Warehousing, Data Modeling, PySpark, AWS, Azure, GCP, Apache Airflow, DBT, REST APIs, Git, CI/CD, Docker, Kubernetes, Kafka, Data Integration, Performance Tuning.

Education:

Bachelor's or Master's degree in Computer Science, Information Technology, Engineering, or related field.

Candidates are required to attend Phone/video calls and in-person interviews. After the Selection, the candidate (He/She) should undergo all background checks on Education and Experience.

After carefully reviewing your experience and skills, one of our HR team members will contact you on the next steps.