Principal Data Engineer

For more than a century, L’Oréal has devoted its energy, innovation, and scientific excellence solely to one business: Beauty. Our goal is to offer every person around the world the best of beauty in terms of quality, efficacy, safety, sincerity and responsibility to satisfy all beauty needs and desires in their infinite diversity.At L'Oréal, our IT teams design and build solutions to ensure high performance for all our business sectors by imagining new ways of doing things, from designing websites to building algorithms and predicting new trends. They can be found leading teams towards a more connected and digitalized future in IT retail, e-commerce, CRM, data, AI, cybersecurity, Cloud and E-Marketing. You never stop learning at L'Oréal IT because things change at the speed of light Come join our dynamic team**What you will do**:- Cloud Data Architecture: Design, implement, maintain, and optimize scalable, secure, and cost-effective data solutions within the AWS ecosystem, ensuring high availability and performance. This includes selecting and integrating appropriate AWS services to meet business requirements.- Data Pipeline Development: Develop, test, and maintain robust and efficient data pipelines for extracting, transforming, and loading (ETL) large datasets from a variety of sources, including GCP, AWS, Databricks, Salesforce, MySQL, Cassandra, Postgres, S3, and SFTP. Emphasis on automation, scalability, and reliability is crucial.- ELT Processes: Design, implement, and optimize Extract, Load, Transform (ELT) processes, ensuring data quality, accuracy, and accessibility for analytics, reporting, and data science initiatives. This includes data cleansing, validation, and transformation techniques. Design and implement process to create aggregated datasets that support analytics, reporting, and business intelligence uses cases.- Data Storage Solutions: Manage cloud-based data storage solutions, primarily AWS S3 and GCP, focusing on performance optimization, security, and scalability to meet current and future data storage needs.- Data Integration: Collaborate effectively with software engineers, Salesforce engineers, IT teams, and business stakeholders to integrate diverse data sources and ensure seamless data flow across operational systems.- Automation: Automate data-related workflows, including data ingestion, transformation, and movement, using tools like Airflow and Lambda to minimize manual intervention, improve efficiency, and reduce operational overhead.- Monitoring and Troubleshooting: Proactively monitor data pipeline, including streaming, performance, identify and resolve issues, and implement measures to ensure data reliability, accuracy, and availability.- Documentation: Maintain comprehensive and up-to-date documentation of all data pipelines, architectures, and processes, facilitating collaboration, knowledge sharing, and future development efforts.- Collaboration: Work closely with cross-functional teams, including data scientists, business analysts, and other stakeholders, to gather data requirements, translate business needs into technical solutions, and deliver valuable data-driven insights.**What we are looking for**:- Education: Bachelor's degree in Computer Science, Engineering, Information Systems, or a related field. A Master's degree is a plus.- Experience: 7+ years of demonstrable experience as a Cloud Data Engineer or Data Engineer with a significant focus on AWS cloud technologies, data management, and data warehousing. Experience with the consumer, marketing, and commerce domains is highly preferred.- Technical Skills: Expert-level proficiency in SQL and Python/PySpark,. Strong working knowledge of GCP, Databricks, dbt, AWS S3, AWS Lambda, Apache Airflow, and Terraform. Experience with other AWS services (e.g., Glue, EMR, DynamoDB, SQS, Fargate) is a plus.- Cloud Security: Solid understanding of data security best practices, governance principles, and compliance requirements within cloud environments.- Performance Optimization: Proven ability to optimize and tune cloud-based systems for cost efficiency and optimal performance.- Problem-Solving: Exceptional problem-solving skills, analytical thinking, and a meticulous attention to detail.- Communication: Excellent communication and interpersonal skills, with the ability to effectively interact with technical and non-technical audiences.