ETL Developer (Snowflake, SQL, Python)
Metasys Technologies, Orlando, FL, United States
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)
Metasys Technologies is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identify, national origin, veteran or disability status.
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)
Metasys Technologies is an equal opportunity employer. All applicants will be considered for employment without attention to race, color, religion, sex, sexual orientation, gender identify, national origin, veteran or disability status.