> Markdown version of [/jobs/ext/2879590-lead-etl-engineer](https://www.wearedevelopers.com/jobs/ext/2879590-lead-etl-engineer). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md). --- # Lead ETL Engineer - **Company:** Tranzeal, Inc. - **Location:** Los Angeles, CA, United States - **Experience:** Expert - **Contract:** Permanent contract - **Skills:** Amazon Web Services, Big Data, Continuous Integration, Data Governance, Extract Transform Load (ETL), Data Mart, Data Warehousing, Github, Python (Programming Language), Online Analytical Processing, Operational Data Store, PCI Data Security Standards, Performance Tuning, SQL Databases, Enterprise Data Management, Azure Data Factory, Informatica Cloud, Data Lakes, Data Lineage, Data Pipelines, Jenkins - **Published:** September 13, 2026 - **Apply:** https://www.dice.com/job-detail/a34a4bc8-11a5-46cb-b2dc-b2d4ac5ce432 ## About the Role * 8+ years of experience in data warehousing and ETL development. * 3+ years in a technical lead role. * 3+ years of hands-on experience with AWS Redshift and Informatica Cloud. * 3+ years of Python development experience. * Strong expertise in OLAP data modeling, performance tuning, and large-scale data environments. * Experience with CI/CD tools such as Jenkins and GitHub. * Knowledge of data governance, security, and compliance standards (SOC 2, PCI DSS). * Fintech or financial services experience. * Experience with business intelligence, compliance analytics, and enterprise data platforms. * Strong communication and stakeholder management skills. ## Description * Design and maintain ODS, EDW, data lakes, and data marts. * Develop scalable batch and real-time ETL pipelines using Informatica Cloud, AWS, Azure Data Factory, and SQL-based tools. * Create data models, architecture diagrams, and reusable ingestion frameworks. * Optimize data warehouse performance, scalability, and reliability. * Lead data governance initiatives including data lineage, cataloging, and data quality. * Troubleshoot production issues and deliver production-grade ETL solutions. * Build automated testing frameworks and integrate testing into CI/CD pipelines. * Collaborate with stakeholders to deliver scalable data solutions and proof-of-concepts. ## Related Videos - [Alibaba Big Data and Machine Learning Technology](https://www.wearedevelopers.com/videos/37-alibaba-big-data-and-machine-learning-technology) - [The Road to MLOps: How Verivox Transitioned to AWS](https://www.wearedevelopers.com/videos/1050-the-road-to-mlops-how-verivox-transitioned-to-aws) - [Modern Data Architectures need Software Engineering](https://www.wearedevelopers.com/videos/1030-modern-data-architectures-need-software-engineering) - [Innovating Developer Tools with AI: Insights from GitHub Next](https://www.wearedevelopers.com/videos/1268-innovating-developer-tools-with-ai-insights-from-github-next) - [PySpark - Combining Machine Learning & Big Data](https://www.wearedevelopers.com/videos/44-pyspark-combining-machine-learning-big-data) - [Our GitOps approach for deploying an Identity Provider and an API Gateway in a SaaS company](https://www.wearedevelopers.com/videos/776-our-gitops-approach-for-deploying-an-identity-provider-and-an-api-gateway-in-a-saas-company) ## Related Articles - [Making Data Warehouses Fast: A Developer’s Story](https://www.wearedevelopers.com/magazine/107-making-data-warehouses-fast-a-developer-s-story) - [Highest Paying Tech Companies for Developers](https://www.wearedevelopers.com/magazine/220-highest-paying-tech-companies-for-developers) - [How We Built a Worry-Free System That Runs for 10+ Years – And What We’d Do Again](https://www.wearedevelopers.com/magazine/751-how-we-built-a-worry-free-system-that-runs-for-10-years-and-what-we-d-do-again) - [What’s the Difference between a Junior, Mid, and Senior Developer?](https://www.wearedevelopers.com/magazine/238-what-s-the-difference-between-a-junior-mid-and-senior-developer) - [Coffee with Developers - Maria Apazoglou - Making AI understandable for all in production](https://www.wearedevelopers.com/magazine/475-coffee-with-developers-maria-apazoglou-making-ai-understandable-for-all-in-production) - [Data Engineer Salary UK](https://www.wearedevelopers.com/magazine/253-data-engineer-salary-uk)