Senior Data Engineer (San Francisco, CA, US, USA_520418) - Sephora

At Sephora we inspire our customers, empower our teams, and help them become the best versions of themselves.  We create an environment where people are valued, and differences are celebrated. Every day, our teams across the world bring to life our purpose: to expand the way the world sees beauty by empowering the ExtraOrdinary in each of us.

We are united by a common goal - to reimagine the future of beauty.

The opportunity:
 

Our Technology team works fast and smart. With San Francisco as our home, we take bringing new tech to market seriously, developing the latest in mobile technologies, scalable architecture, and the coolest in-store client experience. We love what we do and have fun doing it. The Technology group is comprised of motivated self-starters and true team players who are absolutely integral to Sephora's growth and future success.

Your role at Sephora:

As a Senior Engineer in Data Engineering, you will design and implement innovative analytical solutions and work alongside the product engineering team, evaluating new features and architecture. Reporting to the Engineering Manager, Data Platform, you will work closely with other team members like data architects and business analysts to understand what the business is trying to achieve, move data from source to target, and design optimal data models. You will also be responsible for building and maintaining the data platform. This hands-on technical role demands excellent knowledge and can demonstrate best practices in the industry. Be a part of a team that is starting this new journey.

Responsibilities

• Streamline the intake of the raw data into our Azure Data lake.
• Perform production support and deployment activities.
• Proactively drive the execution of our core data engineering, business intelligence, and data warehouse frameworks
• Build data pipelines from systems such as CRM, Ecommerce etc. with the emphasis on scalability and reliability
• Leverage central data warehouse along with other data sources to create enriched customer information into CRM system
• Understand and translate business needs into data models to support long-term, scalable, and reliable solutions
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Drive data quality across the organization; develop best practices for standard naming conventions and coding practices to ensure consistency of data models and tracking
• Define and manage SLA’s for data sets and processes running in production
• Continuously improve our data infrastructure and stay ahead of technology
• Design a system for data backup in case of system failure
• Build strong cross-functional partnerships with Data Scientists, Analysts, Product Managers and Software Engineers to understand data needs and deliver on those needs

We’re excited about you if you have: 

• 8+ years experience as a Senior Data Engineer or similar position
• Experience with large-scale data warehouse projects.
• Advanced Proficiency in Scala, Spark and SQL.
• Excellent knowledge in data structures and design patterns
• Preferred experience with data integration tools
• Experience working with Retail/CRM/Finance datasets preferred
• Knowledge in designing facts, dimensions, snapshots, SCDs, etc
• Write SQL for processing raw data, data validation and QA
• Knowledge working with APIs to collect or ingest data
• Strong Database knowledge, SQL & No-SQL preferred
• Experience designing and implementing cloud based and SaaS data warehouse (e.g. WS, Hadoop, NoSQL) and developing ETL/ELT pipelines
• Experience integrating and building data platform in support of BI, Analytics, Data Science, and real-time applications
• Strong communication skills, with the ability to initiate and drive projects proactively and accurately

While at Sephora, you’ll enjoy...

• The people. You will be surrounded by some of the most talented leaders and teams – people you can be proud to work with.

• The learning. We invest in training and developing our teams, and you will continue evolving and building your skills through personalized career plans.

• The culture. As a leading beauty retailer within the LVMH family, our reach is broad, and our impact is global. It is in our DNA to innovate and, at Sephora, all 40,000 passionate team members across 35 markets and 3,000 stores, are united by a common goal - to reimagine the future of beauty.

You can unleash your creativity, because we’ve got disruptive spirit. You can learn and evolve, because we empower you to be your best. You can be yourself, because you are what sets us apart. This, is the future of beauty. Reimagine your future, at Sephora.

Sephora is proud to be an equal opportunity workplace for all. We do not discriminate in recruitment, hiring, training, advancement, or other employment practices. We celebrate diversity and are committed to creating and fostering an inclusive environment for all employees.