About the Company:
The company, publicly traded on the NYSE, reports annual revenues of approximately $450 million and holds a market capitalization near $3.5 billion. As a member of the S&P 600 Cosmetics Index since 2004, it has steadily expanded its brand portfolio. Today, it offers a diverse range of cosmetics, including Well People, a clean beauty label, and Keys Soulcare, a lifestyle beauty brand developed in collaboration with Alicia Keys. Its products are widely available online and at major U.S. retailers, with a steadily growing international presence.
Roles and Responsibilities:
- Design, develop, and maintain scalable ELT/ETL data pipelines to process large volumes of data from multiple sources into the data warehouse.
- Must have skills: Strong Snowflake expertise (RBAC management, virtual warehouse, file format, streams, zero-copy clone, time travel), SQL development, ELT/ETL tools (Informatica/SnapLogic), Python/Java/C#, data modeling, and cloud platforms (AWS/Azure/GCP).
- Optimize and monitor data infrastructure for high availability, performance, and cost efficiency.
- Collaborate with data scientists, analysts, and business teams to deliver accurate and efficient data solutions.
- Implement data security, governance, and quality control measures to ensure compliance and integrity.
- Enhance and automate reporting processes for improved efficiency, accuracy, and scalability.
- Stay updated on emerging data technologies to drive continuous improvement of data architecture.
- Troubleshoot and resolve data quality, performance, and pipeline issues in a timely manner.