Senior Python Developer with Snowflake

4 days ago

Lake, TX, United States Petadata Full-time
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.

  • Stron