Data Engineer

Key Skills

Java Programming, Python Programming, C++, C Programming, SQL, Cloud computing, Scala Programming, Machine learning techniques, Data science techniques, MATLAB Programming, PyTorch, TensorFlow, R Programming

Job Description

Your role at Clorox:

At Clorox, we strive to create more meaningful, personalized experiences for our consumers. To do this, we need to know more consumers, to know more about them, and to use that knowledge to create new consumer experiences. We have an ambitious goal of developing 100M relationships with consumers. Our marketing programs span multiple channels (web, mobile, email, app, ecomm, iOT) and we work with a number of program partners to bring these programs to life.

Our marketing tech stack is evolving to support our ambitious goal, including a cloud-based data lake environment where Clorox’s Known Consumer Data (aka our first party data) is centrally stored and managed. Ensuring our KCD is easily and reliably accessible for the different marketing systems (e.g. ESP, CDP, CRM) and/or agency partners (both internal and external) is critical to the success of our mission.

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).

In this role, you will:

Technical Engineering (50%):

• Establish and maintain data integrations between Clorox’s datalake and receiving systems
• Lead the planning of database & data warehouse objects in partnership with our agency partners
• Build and manage APIs
• Understand businesses’ use cases for KCD and their relative priority to help prioritize the engineering queue
• Lead acceptance testing when developing new integrations
• Identify any needs for additional tools or technology; make recommendations as necessary
• Continuously identify optimizations that improve business results
• Integrate KCD ecosystem with Clorox’s privacy software to support compliance procedures for CCPA and GDPR.

Data Quality & Security (30%)

• Proactively manage data quality and connections. Ensure data is delivered to where it needs to be, on time, within budget and with minimal errors.
• Author data quality requirements and ensure they meet business and technical needs
• Manage de-duplication processes
• Ensure KCD follows appropriate legal and regulatory guidance provided by Legal and IT (CCPA/GDPR, IT Security)
• Manage data access rights for KCD based on individual’s business use cases

Data Modeling & Architecture (20%)

• Collaborate with agency partners to create Clorox’s overall KCD data architecture
• On-going management of data architecture as our KCD continues to scale: create structure, schemas, tables, views, stored procedures, and the creation and execution of multiple database queries.
• Maintain appropriate documentation such as Data dictionaries and Entity Relationship diagrams (ERD).
• Maintain our growing data model in support of the business

What we look for:

Years and Type of Experience:

• 5+ years of ETL & data migration experience (Azure Data Factory preferably)
• 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 Python development experience
• 5+ years working in a cross-functional team that must include some Marketing counterparts

Skills and Abilities:

• 3+ years of experience with Azure, or Goolge Cloud, or Amazon Web Services (AWS) technologies
• 3+ years of hand-ons experience with Databricks
• 5+ years of API integration experience
• Exposure to NoSQL databases, and JSON
• Experience with large volumes of data / data warehousing
• MySQL development & administration
• Experience with database / query optimization
• Extremely proficient with writing complex queries and best practices

Education Level/Degree: (Please clarify if equivalent experience is acceptable with no degree)

Bachelor's degree in Computer Science, Information Systems, or relevant field; or 10+ years of relevant work experience.

We seek out and celebrate diverse backgrounds and experiences, and we know you don’t need a degree to succeed. 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.

Benefits we offer to help you be well and thrive:

• Competitive compensation
• Generous 401(k) program in the US and similar programs in international
• Health benefits and programs that support both your physical and mental well-being
• Flexible work environment, depending on your role
• Meaningful opportunities to keep learning and growing
• Half-day Fridays, depending on your location