ETL Developer

BuzzClan LLC • Orlando, FL

4h • Hybrid

About The Position

The ETL Developer will drive the end-to-end lifecycle of data ingestion, transformation, and distribution while providing onsite presence and technical leadership to an offshore team. The role combines hands-on development of critical data pipeline artifacts with oversight of code quality, testing, and project delivery, and collaboration with enterprise architects to align pipelines with business intelligence and analytics requirements.

The position is based at the client location in Orlando, Florida, Monday through Thursday, with remote work on Friday. The posting lists SQL, Snowflake, Python, and good communication as strong key skills.

Requirements

• Bachelor’s degree in computer science, information technology, or a related field.
• At least 6 years of experience in data warehousing, data engineering, or ETL/ELT development.
• At least 1–2 years in a technical lead or senior engineering capacity.
• Advanced proficiency in SQL and scripting languages such as Python or Java.
• Hands-on experience with modern data integration platforms such as AWS Glue, Apache Spark, or Kafka.
• Deep understanding of data modeling, including snowflake schemas, real-time streaming architectures, and performance tuning of large datasets.
• Strong communication, stakeholder management, and project management capabilities.

Responsibilities

• Develop data and ETL pipelines and assess and review artifacts generated by offshore Data Engineers.
• Conduct code reviews, facilitate agile ceremonies, and oversee project delivery timelines.
• Design scalable, robust, and fault-tolerant batch and real-time data ingestion pipelines; establish coding standards and integration design patterns.
• Oversee ETL or streaming data processes across heterogeneous source systems, including APIs, relational databases, flat files, and cloud storage, into centralized data warehouses and data lakes.
• Implement data profiling, data reconciliation processes, validation frameworks, and automated testing procedures to support data integrity, consistency, and compliance.
• Partner with data architects, data administrators, product owners, and business analysts to translate business requirements into technical specifications.
• Troubleshoot data pipeline bottlenecks, optimize SQL queries, and manage incident resolution.

What This Job Offers

• Job Type: Full-time
• Career Level: Senior