JOBSEARCHER

ETL developer

AmpcusMillbrae, CAL6 LeadSeptember 22nd, 2026
Overview: In this Development Lead role, you will guide end-to-end data ingestion, transformation, and distribution initiatives. You’ll lead an offshore team, establish coding and testing standards, and align pipelines with BI and analytics needs. You’ll also contribute hands-on to develop critical data artefacts and ensure data quality. This position offers the chance to shape scalable data platforms while collaborating with architects and product stakeholders.
Responsibilities: Develop data/ETL pipelines and review artefacts from offshore Data EngineersConduct code reviews, facilitate agile ceremonies, and oversee delivery timelinesDesign scalable fault-tolerant batch and real-time ingestion pipelinesOversee ETL/Streaming across heterogeneous sources to data warehouses/data lakesImplement data profiling, reconciliation, validation frameworks, and automated testingTranslate complex business requirements into technical specs with stakeholdersTroubleshoot bottlenecks, optimize SQL, and manage incidents
Key requirements: Bachelor’s degree in computer science, Information Technology, or related field 6+ years in data warehousing, data engineering, or ETL/ELT, with 1–2 years in technical lead roleAdvanced proficiency in SQL and scripting (Python or Java) Hands-on experience with modern data integration platforms (AWS Glue, Apache Spark, Kafka) Deep understanding of data modeling (Snowflake schemas), real-time streaming architectures, and performance tuningExcellent communication, stakeholder management, and project management abilitiesGood communicationStakeholder managementProject managementSQLPythonJava