The Clorox Company Data Engineer IV in Indiana
Make your mark
At Clorox, we build big brands that make everyday life better, every day. We value our differences, and challenge each other to think and act boldly. We try new things, succeed, fail and keep learning. We work hard, and have busy personal lives. And we’re all able to make a positive impact – at Clorox, in our communities, and in the lives of millions of people who invite us into their homes. Make your mark and help us drive Good Growth – growth that is profitable, sustainable and responsible.
Clorox DTC (direct-to-consumer) is the owned & operated e-commerce arm of Clorox where daily interactions and conversations with customers translate into high growth and continuous learnings. The agile, growing team, well-positioned in the New York, San Francisco, and D.C. areas, is made up of cross-functional professionals who launch and grow DTC wellness brands, while simultaneously mobilizing the online presence of Clorox’s well-loved and established retail brands. Clorox DTC is where a start-up’s appetite for innovation, efficiency, and speed meets the stability and resources of a Fortune 500. Functions, similar to any scaled e-commerce company, are wide and varied across R&D; operations; product/experience; marketing; creative; data science/analytics and technology/engineering.
As part of the growing DTC Data Science & Analytics Team, the Senior Database Engineer will help define information architecture and build data integration systems that can process data at scale. Responsibilities include building data models, developing database & data warehouse objects, and building ETL pipelines. The Senior Database Engineer is empowered to implement processes and standards, participate in discussions to determine the best data integration tools, and the implementation of those tools.
Design & develop database schemas, tables, views, and stored procedures.
Build, monitor, and maintain ETL processes and data integration pipelines with Matillion ETL.
Build, monitor, and maintain custom ETL processes and data integration pipelines with Python.
Design and update relational and dimensional data models.
Develop data integration documentation including Data Dictionaries and Entity Relationship (ER) diagrams.
Assist the Data Operations Manager in defining the overall data infrastructure & information architecture for Clorox DTC.
Key Skills, Abilities and Experience Required
Required Education and Experience:
Bachelor's degree in Computer Science, Information Systems, or relevant field; or 10+ years of relevant work experience.
5+ years of SQL & database development experience (DDL, DML, Views, Triggers, Functions, Stored Procedures)
5+ years of database management & administration
5+ years of relational data modeling and data reporting
2+ years of data warehouse development and dimensional data modeling
5+ years of ETL & data migration experience
5+ years of Python development experience
Preferred Education and Experience:
2+ years of experience with Amazon Web Services (AWS) or other cloud technologies
Exposure to NoSQL databases, and JSON
Snowflake data warehouse experience
MySQL development & administration
Amazon Web Services (EC2, RDS, S3)
Bachelor’s Degree, College Diploma, or Equivalent (Required)
More About Clorox
The Clorox Company (NYSE: CLX) is a leading multinational manufacturer and marketer of consumer and professional products with approximately 8,800 employees worldwide and fiscal year 2020 sales of $6.7 billion. Clorox markets some of the most trusted and recognized consumer brand names, including its namesake bleach and cleaning products;
Liquid-Plumr® clog removers
Poett® home care products
Fresh Step® cat litter
Glad® bags, wraps and containers
Hidden Valley® dressings and sauces
Brita® water-filtration products; Burt's Bees® natural personal care products
RenewLife® digestive health products
Rainbow Light®, Natural Vitality™ and NeoCell® dietary supplements.
The company also markets industry-leading products and technologies for professional customers, including those sold under the CloroxPro™ and Clorox Healthcare® brand names. Nearly 80% of the company's sales are generated from brands that hold the No. 1 or No. 2 market share positions in their categories.
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 recruiters 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 fiscal year 2020. For more information, visit TheCloroxCompany.com at http://thecloroxcompany.com/ , including the Good Growth blog, and follow the company on Twitter at @CloroxCo
The Clorox Company and its subsidiaries is an EEO/AA/Protected Veteran/Disabled/LGBT employer.
Equal Opportunity Employer Minorities/Women/Protected Veterans/Disabled
The Clorox Company
- The Clorox Company Jobs