The ETL Developer III is a senior-level technical expert responsible for designing, developing, testing, and optimizing complex Extract, Transform, and Load (ETL) data pipelines to support company data-integrated shelf-edge technology solutions. Operating with minimal supervision in a complex environment, this role serves as a subject matter expert in data architecture, integration, and database development. The ETL Developer III collaborates closely with cross-functional teams across Platform, Cloud, Data Engineering, and Quality Assurance to ensure data integrity, high performance, and continuous integration/delivery across large-scale retail systems. This role requires understanding of cloud computing models and optimization methods for maximizing process efficiency and cost while integrating seamlessly with existing systems within the enterprise.Key Responsibilities:Operating in a hybrid remote work environment, lead the design, specification, development, and maintenance of robust ETL processes, data integration workflows, and data pipelines for high-volume retail and CPG data streams.Monitor system performance, troubleshoot malfunctions, execute root cause analysis, and perform code, query, and database optimizations to ensure optimal, cost-effective data flows.Partner with Platform, Cloud, Data Engineering, and QA teams to translate complex business requirements into scalable, production-ready data pipelines and integration modules.Conduct data modeling studies, design physical schemas, and maintain data dictionaries and entity-relationship diagrams to protect data integrity, security, and enterprise standards.Establish software engineering best practices, automated data quality controls, CI/CD patterns, reusable workflow standards, and maintain data recovery procedures in strict compliance with internal policies and SOX Section 404 requirements.
