About 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.
Responsibilities :
- Design and build scalable data pipeline architecture that can handle large volumes of data
- Develop ELT / ETL pipelines to extract, load and transform data from various sources into our data warehouse
- Optimize and maintain the data infrastructure to ensure high availability and performance
- Collaborate with data scientists and analysts to identify and implement improvements to our
data pipeline and models
Develop and maintain data models to support business needsEnsure data security and compliance with data governance policiesIdentify and troubleshoot data quality issuesAutomate and streamline processes related to data managementStay up-to-date with emerging data technologies and trends to ensure the continuous improvement of our data infrastructure and architecture.Analyze the data products and requirements to align with data strategyAssist in extracting or researching data for cross-functional business partners for consumerinsights, supply chain, and finance teams
Enhance the efficiency, automation, and accuracy of existing reportsFollow best practices in data querying and manipulation to ensure data integrityRequirements :
Must have 8+ years of experience as a Snowflake Data Engineer or related roleMust have experience with SnowflakeStrong Snowflake experience building, maintaining and documenting data pipelinesExpertise in Snowflake concepts like RBAC management, virtual warehouse, file format,streams, zero copy clone, time travel and understand how to use these features
Strong SQL development experience including SQL queries and stored proceduresStrong knowledge of ELT / ETL no-code / low-code tools like Informatica / SnapLogic.Well versed in data standardization, cleansing, enrichment, and modelingProficiency in one or more programming languages such as Python, Java, or C#Experience with cloud computing platforms such as AWS, Azure, or GCPKnowledge of ELT / ETL processes, data warehousing, and data modelingFamiliarity with data security and governance best practicesExcellent hands-on experience in problem-solving and analytical skills and improving the performance of processesStrong communication and collaboration skills(ref : hirist.tech)