ETL developer
Location - Orlando, Florida (4 days WFO, 1 day remote)
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.
QualificationsRequired 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 InformationAll your information will be kept confidential according to EEO guidelines.
Skills Required
- 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
- 1-2 years of experience in a technical lead or senior engineering capacity
- Advanced proficiency in SQL
- Proficiency in scripting languages such as Python or Java
- Hands-on experience with modern data integration platforms such as AWS Glue, Apache Spark, or Kafka
- Understanding of data modeling, snowflake schemas, real-time streaming architectures, and performance tuning of large datasets
- Strong communication, stakeholder management, and project management capabilities
What We Do
BuzzClan is a technology consulting firm collaborating to provide software, advisory, implementation, transformation and staffing services. We provide systems integration, IT consulting, managed services and workforce solutions to public and private sector clients. BuzzClan is a certified partner for most Tier-1 Cloud, Software & Hardware Providers, including Oracle, Amazon, Microsoft & Saviynt. BuzzClan is committed to providing substantive business value on each and every client engagement. We do this through a combination of industry-specific business expertise, technical skills, proven project management methods and our “onsite - off-site - offshore” delivery model. We strive to work in partnership with our customers to build high-performance teams and create business solutions that will last. Vertically Integrated solutions company Full ownership of the solution The combined experience of more than 250+ years Various OEM Certifications such as OCP, PMP, AWS, MS Azure, etc. Onsite presence across the North American(US & Canada) clients Near-Shore & Offshore presence
