remote
Data Engineer - Colgate Palmolive
Data Engineer
Data Engineer responsible for designing, building, and maintaining scalable data pipelines and infrastructure using Python, SQL, and AWS services. Focus on data modeling, ETL processes, and ensuring high data quality for analytics and business intelligence.
About the role
Key Responsibilities
- Design, develop, and maintain robust data pipelines to ingest, transform, and load data from diverse sources into cloud data warehouses.
- Implement data modeling best practices to support analytics, reporting, and machine learning initiatives.
- Optimize ETL workflows for performance, reliability, and cost-efficiency using Python and SQL.
- Collaborate with data scientists, analysts, and business stakeholders to understand data requirements and deliver actionable insights.
- Monitor data quality, troubleshoot issues, and implement automated validation and alerting mechanisms.
Requirements
- Strong experience with Python for data engineering tasks and automation.
- Proficient in SQL and relational database design.
- Hands‑on experience with AWS services such as S3, Redshift, Glue, and Lambda.
- Solid understanding of data modeling, ETL concepts, and data warehousing principles.
- Excellent problem‑solving skills and ability to work collaboratively in a fast‑paced environment.