The Clorox Company Consumer Data Engineer in Oakland, California
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.
This role serves as the Data Engineer and Data Architecture SME for Clorox’s KCD. This person is the lead engineer for end-to-end management and execution of our KCD. Primary responsibilities include:
• Maintain, grow and optimize Clorox’s data architecture
• Manage various data integrations between systems at scale
• Be the Data Engineering Center of Excellence by building processes and standards, participate in key discussions and help evolve related Clorox capabilities
This role supports the Marketing Function as part of the Marketing, Data & Technology Enablement (MDATE) team. S/he is comfortable working effectively across large matrixed organizations, can confidently create his/her own project plan and roadmap, and be able to clearly communicate with all types of stakeholders from the most technical to the most senior. S/he has a conceptual understanding of marketing programs and tactics, and how his/her work directly impacts these initiatives. The Data Engineer is comfortable working within most cloud-based marketing technology platforms and maintaining integrations with various Marketing Automation platforms (e.g. CDP, Email, DSP).
o Establish and maintain data integrations between Clorox’s datalake and receiving systems
o Build and automate data pipelines between Clorox’s datalake and external systems
o Lead the planning of database & data warehouse objects in partnership with our agency partners
o Build and manage API integrations
o Understand businesses’ use cases for KCD and their relative priority to help prioritize the engineering queue
o Lead acceptance testing around data integrations
o Identify any needs for additional tools or technology; make recommendations as necessary
o Continuously identify optimizations that improve business results
Build and manage technical integration with Clorox’s privacy software to support compliance procedures for CCPA and GDPR.
Data Quality & Security:
o Proactively manage data quality and connections via robust and reliable data validation processes. Ensure data is delivered to where it needs to be, on time, within budget and with minimal errors.
o Author data quality requirements and ensure they meet business and technical needs
o Manage various data quality processes including, but not limited to, de-duplication, identity unification, data completion, etc.
o Ensure KCD follows appropriate legal and regulatory guidance provided by Legal and IT (CCPA/GDPR, IT Security)
Data Modeling & Architecture
o Collaborate with agency partners to ensure Clorox’s overall KCD data architecture suits its use cases
o On-going management of data architecture as our KCD continues to scale: create structure, schema design, tables, views, stored procedures, and the creation and execution of multiple database queries.
o Maintain appropriate documentation such as Data dictionaries and Entity Relationship diagrams (ERD).
Maintain our growing data model in support of the business
Key Skills, Abilities, Experience and Education Required
Years and Type of Experience:
Degree in Applied Mathematics, Statistics, Computer Science, or the equivalent, PhD or MS preferred
5+ years of ETL & data migration experience
5+ years of API integration experience
5+ years of SQL & data warehouse or database development experience (DDL, DML, Views, Triggers, Functions, Stored Procedures)
5+ years of relational data modeling
5+ years of experience with a third generation programming language such as Python or Java
5+ years working in a cross-functional team that must include some Marketing counterparts
Skills and Abilities:
3+ years of experience working in a cloud environment, Azure or GCP preferred
5+ years of API integration experience
Exposure to NoSQL databases
Experience with large volumes of data / data warehousing
Experience with database development and administration, SQL server preferred
Experience with database / query optimization
Extremely proficient with writing complex queries and best practices
More about Marketing
Marketing is a powerful growth engine for Clorox. We create winning ideas that drive consumer value and energize our brands and businesses around the world. Consumers are at the center of everything we do, and our brand teams translate passion for the consumer into business results. We use consumer insights to develop and implement marketing plans, create and evaluate business-building projects, and inspire new product development opportunities. Join our team to help us develop human-centered, technology-enabled, purpose-driven brands.
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 Clorox recruiters via unsolicited texts during these uncertain times.
Learn more about:
Working at Clorox (https://www.thecloroxcompany.com/careers/working-at-clorox/)
Inclusion & Diversity (https://www.thecloroxcompany.com/who-we-are/our-people/inclusion-diversity/) .
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 is 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 (firstname.lastname@example.org) @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
- The Clorox Company Jobs