Senior Python & Snowflake Data Engineer

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

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