Senior Python Developer with Snowflake

Senior Python Developer with Snowflake at PETADATA will design, develop, and maintain scalable data processing applications, build and optimize ETL/ELT pipelines, and implement Snowflake data warehouse solutions. The role involves collaborating with stakeholders, optimizing SQL queries, integrating data from multiple sources, ensuring data quality and governance, leading code reviews, and participating in Agile ceremonies.

• 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.

• 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 Google Cloud Platform.
• 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.