Senior Python Developer with Snowflake

PETADATA; Austin (TX); On-site; USD 180,000 - 240,000; Full time

Job summary

PETADATA is seeking a Senior Python Developer with Snowflake to join our data engineering team in Texas. The role requires 12+ years of Python development experience, expertise in Snowflake, SQL, ETL/ELT, data warehousing and cloud technologies (AWS/Azure/GCP).

You will design, build, and optimize scalable data solutions and data pipelines for enterprise platforms. You will lead development, mentor junior engineers, and collaborate with stakeholders to translate requirements into robust

Qualifications

• 12+ years of experience in Python development or data engineering.
• Strong Python programming skills (OOP, multithreading, APIs, data processing).
• Extensive experience with Snowflake Data Cloud."
• Strong SQL, query optimization and DB performance tuning."
• ETL/ELT development and data integration expertise."
• Experience with Data Warehousing, Data Modeling and dimensional modeling."
• Hands-on PySpark and large-scale data processing experience."
• Cloud experience with AWS, Azure or GCP."
• Knowledge of Apache Airflow, orchestration and scheduling tools."
• Experience with REST APIs, JSON, and third-party integrations.

Responsibilities

• Design, develop, and maintain scalable data processing apps using Python and Snowflake.
• Build and optimize enterprise ETL/ELT pipelines for data ingestion and transformation.
• Design Snowflake data warehouses with efficient schemas and performance tuning.
• Develop reusable Python frameworks, APIs, and automation solutions.
• Collaborate with stakeholders to translate requirements into technical solutions.
• Optimize SQL queries, stored procedures, and data workflows for performance.
• Integrate data from relational databases, APIs, cloud storage, and third-party apps.
• Implement data quality, governance, security, and compliance practices.
• Monitor, troubleshoot, and resolve production data pipeline issues.
• Lead code reviews, establish standards, and mentor juniors.
• Participate in Agile ceremonies and CI/CD pipeline enhancements.
• Work with DevOps to automate deployments and CI/CD pipelines.
• Evaluate new technologies 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

Git/GitHub

Docker

Kubernetes

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.

Contact No: [phone]