Job Title Google Cloud Data Engineer & Architect Lead

Division: L’Oreal IT

Location: New York, NY (can be flexible to New Jersey)

Reports To: AVP, Domain Lead

Who We Are:

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 each and 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:

We are looking for an experienced GCP Data Engineer & Architect who has applied technology solutions to grow and optimize digital analytics. You would be responsible for executing a growth strategy for multiple divisions and channels across L’Oreal USA. You would apply in depth knowledge of technology options, technology platforms, design techniques and approaches across the L’Oreal ecosystem to design systems that meet business needs · You will analyze the business problems and design reliable, scalable data storage and analytics systems that enable the business and our products to scale. Play a leading role in POCs and building platforms and datasets using software engineering best practices, data management fundamentals, data storage principles, and operational excellence best practices.

• Participate in architectural discussions, perform system analysis which involves a review of the existing systems and operating methodologies. Participate in the analysis of newest technologies and suggest the optimal solutions which will be best suited for satisfying the current requirements and will simplify the future modifications
• Design appropriate data models for the use in transactional and big data environments as an input into Machine Learning processing.
• Create and maintain optimal data pipeline architecture
• Assemble large, complex data sets that meet functional / non-functional business requirements.
• Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Design and Build the necessary infrastructure for optimal ETL from a variety of data sources to be used on GCP services
• Develop data and semantic interoperability specifications
• Collaborate with multiple stakeholders including Product Teams, Data Domain Owners, Infrastructure, Security and Global IT
• Identify, Implement, and continuously enhance the data automation process
• Support continuous improvement in DevOps Automation
• Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiency, and other key business performance metrics.
• Work with stakeholders including the Executive, Product, Data and Design teams to assist with data-related technical issues and support their data infrastructure needs.
• Develop proper Data Governance and Data Security

What We Are Looking For:

Required Qualifications:

• 10 + years of Data Engineering experience working with both distributed architectures, ETL, EDW and Big Data technologies
• 3+ years of experience with Google Cloud Services such as Streaming + Batch, Cloud Storage, Cloud Dataflow, Composer, DFunc, Big Query & Big Table
• Experience with data warehousing concepts and implementation of bronze, silver and gold layers and Integration with frontend tools
• Proven Experience in Snowflake will be a plus
• Experience with DWBI modelling framework is highly regarded
• Strong Python, Java Development Experience
• Extensive experience working with SQL across a variety of databases
• Experience with DBT, Integration with Frontend Tools
• Experience in Cross cloud, Inter-region data transfers/migration will be a plus
• Experience in Analytics/Visualization tools like PowerBI, Looker, Tableau
• Proven knowledge in implementing security & IAM requirements
• Knowledge and proven use of contemporary data mining, cloud computing and data management tools including but not limited to Microsoft Azure, AWS Cloud, Google Cloud, Hadoop, HDFS, mapr and spark.

What’s In It For You:

• Salary Range: $139,700-$199,100 (The actual compensation will depend on a variety of job-related factors which may include geographic location, work experience, education, and skill level)
• Competitive Benefit Package (Medical, Dental, Vision, 401K, Pension Plan)
• Hybrid Work Policy (3 Days in Office, 2 Days Work from Home)
• Flexible Time Off (Paid Company Holidays, Paid Vacation, Vacation Buy Program, Volunteer Time, Summer Fridays & More!)
• Access to Company Perks (VIP Access to L’Oréal’s Internal Shop for Discounted Products, Monthly Mobile Allowance)
• Learning & Development Opportunities (Unlimited Access to E-learnings, Lunch & Learn Sessions, Mentorship Programs, & More!)
• Employee Resource Groups (Think Tanks and Innovation Squads)
• Access to Mental Health & Wellness Programs

Don’t meet every single requirement? At L'Oréal, we are dedicated to building a diverse, inclusive, and innovative workplace. If you’re excited about this role but your past experience doesn’t align perfectly with the qualifications listed in the job description, we encourage you to apply anyways! You may just be the right candidate for this or other roles!

We are an Equal Opportunity Employer and take pride in a diverse environment. We would love to find out more about you as a candidate and do not discriminate in recruitment, hiring, training, promotion, or other employment practices for reasons of race, color, religion, gender, sexual orientation, national origin, age, marital or veteran status, medical condition or disability, or any other legally protected status.

If you are a qualified individual with a disability or a disabled veteran, you may request a reasonable accommodation if you are unable or limited in your ability to access job openings or apply for a job on this site as a result of your disability. You can request reasonable accommodations by contacting [email protected]. If you need assistance to accommodate a disability, you may request an accommodation at any time. 

Our Safe Together Plan: Your safety is our highest priority. We will proceed with caution and adhere to enhanced protection standards to ensure our sites are safe for all employees. We must all operate with the shared responsibility for each other’s health & safety in mind.