The Clorox Company Database Engineer III (Direct To Consumer) in New York, New York
At Clorox, we champion people to be well and thrive by doing the right thing, putting people at the center, and playing to win. Led by our IGNITE strategy, we build brands that make a positive difference in people’s lives around the world. And we know that success requires head, heart, AND guts — all three, every day — coming together to work simpler, faster, bolder, and more inclusively. Interested? Join us to #IgniteYourCareer (https://www.linkedin.com/feed/hashtag/?keywords=igniteyourcareer&highlightedUpdateUrns=urn%3Ali%3Aactivity%3A6815726741450039296) !
Your role at Clorox:
As part of the growing DTC Data Science & Analytics Team, reporting to our Data Engineering lead, the Data Engineer will help design the data architecture and build data integration systems that can process data at scale. Responsibilities include building data models, developing database & data
warehouse objects, and designing, building, and monitoring data pipelines. The Data Engineer is empowered to implement processes and standards, participate in discussions to determine the best designs, and implement those designs as needed.
Data collection, storage, accessibility and governance are core to the direct-to-consumer strategy, both within the DTC group and across the broader Clorox ecosystem. A solid data foundation empowers business stakeholders, analysts, and data scientists to build insights and tools that ensure we constantly to evolve our product and marketing offerings to be more personalized and relevant to our customers. Your role is critical to our ability to deliver on that objective.
In this role, you will:
Design & develop data pipelines using Airflow.
Develop database schemas, tables, & views.
Monitor and maintain ETL processes and data integration pipelines.
Troubleshoot & resolve inconsistencies in data e.g. duplicates, missing data, etc.
Design and update relational and dimensional data models.
What we look for:
Minimum of 4 years of experience:
2+ years of experience using Python for data handling & transportation
2+ years of SQL & database development experience
Airflow experience required
Experience with ETL & data pipelines as well as Amazon Web Services (EC2, RDS, S3) or other cloud technologies
Exposure to data warehouses, NoSQL databases, and JSON SQL coding & development skills (DDL, DML, Views, Triggers, Functions)
Relational data modeling (Entity Integrity, Referential Integrity, One-to-One relationships, One-to-Many relationships) Snowflake data warehouse experience preferred
We seek out and celebrate diverse backgrounds and experiences. We’re looking for fresh perspectives, a desire to bring your best, and a non-stop drive to keep growing and learning.
At Clorox, we have a Culture of Inclusion. We believe our values-based culture connects to our purpose and helps our people be the best versions of themselves, professionally and personally. This means building a workplace where every person can feel respected, valued, and fully able to participate in our Clorox community. Learn more about our I&D program & initiatives here (https://www.thecloroxcompany.com/company/our-people/inclusion-diversity/) .
[U.S .]Additional Information:
At Clorox, we champion people to be well and thrive, starting with our own people. To help make this possible, we offer comprehensive, competitive benefits that prioritize all aspects of wellbeing and provide flexibility for our teammates’ unique needs. This includes robust health plans, a market-leading 401(k) program with a company match, flexible time off benefits (including half-day summer Fridays depending on location), inclusive fertility / adoption benefits, and more.
We are committed to fair and equitable pay and are transparent with current and future teammates about our full salary ranges. We use broad salary ranges that reflect the competitive market for similar jobs, provide sufficient opportunity for growth as you gain experience and expand responsibilities, while also allowing for differentiation based on performance. Based on the breadth of our ranges, most new hires will start at Clorox in the first half of the applicable range. Your starting pay will depend on job-related factors, including relevant skills, knowledge, experience and location. The applicable salary range for every role in the U.S. is based on your work location and is aligned to one of three zones according to the cost of labor in your area.
–Zone A: $84,500 - $158,000
–Zone B: $77,500 - $144,800
–Zone C: $70,400 - $131,700
All ranges are subject to change in the future. Your recruiter can share more about the specific salary range for your location during the hiring process.
This job is also eligible for participation in Clorox’s incentive plans, subject to the terms of the applicable plan documents and policies.
Please apply directly to our job postings and do not submit your resume to any person via text message. Clorox does not conduct text-based interviews and encourages you to be cautious of anyone posing as a Clorox recruiter via unsolicited texts during these uncertain times.
Making a positive impact
Clorox is a signatory of the United Nations Global Compact and the Ellen MacArthur Foundation's New Plastics Economy Global Commitment. The company has been broadly recognized for its corporate responsibility efforts, named to the 2020 Axios Harris Poll 100 reputation rankings, Barron's 2020 100 Most Sustainable Companies list, and the Human Rights Campaign's 2020 Corporate Equality Index, among others. In support of its communities, The Clorox Company and its foundations contributed more than $25 million in combined cash grants, product donations, and cause marketing in the fiscal year 2020. For more information, visit TheCloroxCompany.com , including the Good Growth blog, and follow the company on Twitter at @CloroxCo
The Clorox Company and its subsidiaries are an EEO/AA/ Minorities/Women/LGBT/Protected Veteran/Disabled employer. You may view the Equal Employment Opportunity is the Law notice (https://www.dol.gov/agencies/ofccp/posters) by clicking on it.
Clorox is committed to providing reasonable accommodation for qualified applicants with disabilities and disabled veterans during the hiring and interview process. If you need assistance or accommodation due to a disability, contact us at People@clorox.com . Please note: This email is reserved for individuals with disabilities in need of assistance and is not a means of inquiry about positions/ application statuses.
The Clorox Company and its subsidiaries are an EEO/AA/ Minorities/Women/LGBT/Protected Veteran/Disabled employer.
The Clorox Company
- The Clorox Company Jobs