ETL Developer

BuzzClan LLC; Orlando (FL); Hybrid; USD 120,000 - 150,000; Full time

Job summary

BuzzClan LLC is seeking a Development Lead to own end-to-end data ingestion, transformation, and distribution. You will lead onsite presence in Orlando (Mon-Thu) and can work remotely on Fridays, guiding offshore teams and enforcing code quality.

You will work hands-on developing critical data pipelines, collaborating with architects and analysts to align data workflows with BI and analytics requirements.

Qualifications

• Bachelor’s degree in computer science, Information Technology, or a related field.
• 6+ years of experience in data warehousing, data engineering, or ETL/ELT development, with 1–2 years in a lead role.
• Advanced proficiency in SQL and scripting languages like Python or Java.
• Hands-on experience with modern data integration platforms (AWS Glue, Apache Spark, Kafka).
• Deep understanding of data modeling (snowflake schemas) and real-time streaming architectures.
• Exceptional communication, stakeholder management, and project management capabilities.

Responsibilities

• Develop data/ETL pipelines and review artefacts from offshore engineers.
• Conduct code reviews, facilitate agile ceremonies, and oversee delivery timelines.
• Design scalable batch and real-time data ingestion pipelines.
• Oversee ETL/Streaming processes across heterogeneous sources to data warehouses and lakes.
• Implement data profiling, validation, and automated testing for data integrity.
• Collaborate with data architects, admins, product owners, and analysts to translate requirements.
• Troubleshoot bottlenecks and optimize SQL queries; manage incidents.

Skills

SQL

Snowflake

Python

Good communication

ETL/ELT

Data warehousing

Data pipelines

Education

Bachelor’s degree in Computer Science/Information Technology

Tools

AWS Glue

Apache Spark

Kafka

Job description

Strong Key Skills - SQL, Snowflake, Python, Good communication

Role Overview

As a Development Lead, you will drive the end-to-end lifecycle of data ingestion, transformation, and distribution. You will provide onsite presence and technical leadership to offshore team, enforce best practices for code quality and testing, collaborate with enterprise architects to align data pipelines with critical business intelligence and analytics requirements. You will also be working hands-on developing critical data pipeline artefacts. This role requires working from Client location in Orlando from Mon-Thu and can work remotely on Fri.

Key Responsibilities

Develop data/ETL pipelines and assess review the artefacts generated by a team of Data Engineers working from Offshore. 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 the Extraction, Transformation, and Loading (ETL) or Streaming Data processes across heterogeneous source systems (e.g., APIs, relational databases, flat files, and cloud storage) to centralized data warehouses and data lakes.

Implement data profiling, Data reconciliation processes, validation frameworks, and automated testing procedures to ensure data integrity, consistency, and compliance.

Partner with data architects, Data admins, product owners, and business analysts to translate complex business requirements into technical specifications.

Troubleshoot critical data pipeline bottlenecks, optimize SQL queries, and manage incident resolution.

Qualifications

Required Qualifications

Bachelor’s degree in computer science, Information Technology, or a related field.

6+ years of experience in data warehousing, data engineering, or ETL/ELT development, with at least 1–2 years in a technical lead or senior engineering capacity.

Advanced proficiency in SQL and scripting languages like Python or Java.

Hands-on experience with modern data integration platforms (e.g., AWS Glue, Apache Spark, or Kafka).

Deep understanding of data modeling (snowflake schemas), real-time streaming architectures, and performance tuning large datasets.

Exceptional communication, stakeholder management, and project management capabilities.

Additional Information

All your information will be kept confidential according to EEO guidelines.