Python and Snowflake developer

Tata Consultancy Services
Municipality of Seville, Spain
2 days ago

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Intermediate
Compensation
€ 70K

Job location

Remote
Municipality of Seville, Spain

Tech stack

API
Amazon Web Services (AWS)
Amazon Web Services (AWS)
Authentication Protocols
Automation of Tests
Azure
Software as a Service
Cloud Computing
Data Integration
ETL
Data Transformation
Database Queries
Github
Monitoring of Systems
JSON
Python
NoSQL
OAuth
Standard Sql
SQL Databases
SQLAlchemy
Systems Integration
Web Services
Cloud Platform System
Snowflake
Gitlab
GIT
Pandas
Api Design
REST
Software Version Control
Data Pipelines
Api Management

Job description

Tata Consultancy Services is looking for a skilled Python and Snowflake developer based in Sevilla, Spain. This role involves designing and implementing ETL/ELT workflows, API integrations, and optimizing data processes within Snowflake., * Design and implement ETL/ELT workflows using Python.

  • Build and manage REST/SOAP API integrations.
  • Write high-performance Snowpark or SQL code for data transformation.
  • Collaborate on data schema design for efficient reporting.
  • Develop automated testing and monitoring systems.
  • Ensure data integrations comply with security standards.

Conocimientos

Python Skills Snowflake Expert SQL Proficiency API Architecture Version Control Cloud Infrastructure Intermediate level of English Descripción del empleo

Are you a Python and Snowflake developer seeking a new interesting challenge? If your answer is yes, it's your lucky day so keep reading, it can be just what you're looking for. WHAT WILL YOU DO?

  • Pipeline Development: Design and implement ETL/ELT workflows using Python to ingest data from various sources (SaaS APIs, SQL databases, NoSQL) into Snowflake.
  • System Integration: Build and manage REST/SOAP API integrations to synchronize data between Snowflake and third-party platforms.
  • Optimization: Write high-performance Snowpark or SQL code to transform data within Snowflake, ensuring cost-effective warehouse usage.
  • Data Modeling: Collaborate with data architects to design schemas that support efficient reporting and analytics.
  • Automation & Monitoring: Develop automated testing, error handling, and alerting systems to ensure pipeline reliability.
  • Security: Ensure all data integrations comply with security standards (encryption at rest/transit, OAuth, etc.).

Requirements

The ideal candidate will have at least 3 years of Python experience, deep knowledge of Snowflake, and be comfortable with SQL and cloud infrastructures. A permanent contract and a hybrid work model are offered., * Minimum 3 years of experience in Python development.

  • Deep understanding of Snowflake architecture.
  • Ability to write and optimize complex analytical SQL queries.
  • Proven experience with RESTful services and authentication protocols.
  • Professional experience with Git (GitHub/GitLab).
  • Familiarity with AWS, Azure, or GCP is a plus., * Python Skills: Minimum 3 years of experience. Expert knowledge of libraries like pandas, requests, SQLAlchemy, and ideally Snowpark.
  • Snowflake Expert: Deep understanding of Snowflake architecture (Virtual Warehouses, Micro-partitions, Snowpipe, and Tasks).
  • SQL Proficiency: Ability to write and optimize complex analytical queries.
  • API Architecture: Proven experience working with RESTful services, JSON, and authentication protocols.
  • Version Control: Professional experience with Git (GitHub/GitLab).
  • Cloud Infrastructure: Familiarity with AWS, Azure, or GCP (specifically storage services like S3 or Blob Storage).
  • Intermediate level of English.

Benefits & conditions

  • Permanent contract: We offer indefinite contracts from the first day.
  • Pay and benefit.

Apply for this position