ETL Developer (Snowflake, SQL, Python)

ETL Developer (Snowflake, SQL, Python)
Location: Orlando, FL (onsite)
Duration: 12+ months

Client is seeking a skilled ETL Developer with strong expertise in Snowflake, SQL, and Python to design, develop, and optimize scalable data pipelines. The ideal candidate will have hands-on experience in data warehousing, ETL/ELT processes, and cloud-based data platforms.

Key Responsibilities

• Design, develop, and maintain ETL/ELT pipelines using Python and SQL
• Build and optimize data models in Snowflake (Star/Snowflake schema)
• Develop scalable data ingestion frameworks for structured and semi-structured data
• Write complex SQL queries for data transformation, validation, and performance tuning
• Work with large datasets and ensure high data quality and integrity
• Implement data loading strategies (batch and incremental loads)
• Monitor, troubleshoot, and optimize ETL jobs for performance and reliability
• Collaborate with Data Engineers, Analysts, and Business teams for data requirements
• Implement best practices for data governance, security, and compliance
• Automate workflows using orchestration tools (e.g., Airflow or similar)

Required Skills

• Strong experience with Snowflake (data modeling, performance tuning, SnowSQL, Snowpipe)
• Advanced SQL skills (joins, window functions, CTEs, query optimization)
• Proficiency in Python for data processing (Pandas, PySpark is a plus)
• Hands-on experience in ETL/ELT tools or frameworks
• Experience with cloud platforms (AWS / Azure / GCP)
• Knowledge of data warehousing concepts and dimensional modeling
• Experience with file formats like JSON, Parquet, CSV
• Familiarity with version control tools like Git

Preferred Qualifications

• Experience with orchestration tools like Apache Airflow
• Knowledge of Dataiku or similar data science platforms
• Experience with CI/CD pipelines in data engineering
• Understanding of data lake architectures
• Exposure to R programming (nice to have)