Senior Python Developer with Snowflake

PETADATA; West Lake Hills (TX); On-site; USD 150,000 - 210,000; Full time

Job summary

PETADATA is seeking a Senior Python Developer with Snowflake to build scalable data solutions, optimize data pipelines, and support enterprise platforms. The ideal candidate has 12+ years of Python development, Snowflake, SQL, ETL/ELT, and cloud tech across AWS/Azure/GCP, with a focus on performance and reliability.

The role involves designing data warehouses, developing robust Python APIs and automation, and collaborating with data architects and business stakeholders to translate requirements

Qualifications

• 12+ years of experience in Python development, data engineering, or related fields.
• Strong Python programming (OOP, multithreading, APIs, data processing).
• Extensive Snowflake Data Cloud experience.
• SQL proficiency with query optimization and performance tuning.
• ETL/ELT development and data integration expertise.
• Data warehousing, data modeling, and dimensional modeling knowledge.
• Hands-on PySpark and large-scale data processing experience.
• Cloud platforms: AWS, Azure, or GCP.
• Airflow or similar workflow orchestration expertise.
• REST APIs, JSON, and third-party integrations.
• Git/GitHub version control proficiency.
• CI/CD, Docker, and Kubernetes experience.
• DBT knowledge preferred.
• Kafka or streaming tech familiarity is a plus.
• Strong analytical, troubleshooting, and problem-solving 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, Information Technology, Engineering, or related field

Tools

GitHub

Docker

Kubernetes

CI/CD tools

Airflow

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.

Contact No: [phone]