No Relocation Assistance Offered
# 153255 – Piscataway, New Jersey, United States
Do you want to be part of a team that is building a future to smile about? What about having the opportunity to connect with others across the world, full of stimulating discussions, and making impactful contributions?
If this is how you see your career, Colgate is the place to be!
Our dependable household brands, dedicated employees, and sustainability commitments make us a company passionate about building a future to smile about for our employees, consumers, and surrounding communities. The pride in our brand fuels a workplace that encourages creative thinking, champions experimentation, and promotes authenticity which has contributed to our enduring success.
If you want to work for a company that lives by their values, then give your career a reason to smile…every single day.
We’re looking for an experienced data and analytics professional to join our Global Analytics Data Foundation team. The Data Solutions Architect and Ops Manager will play a meaningful role in architecting and evolving the data foundation to fuel the next generation of commercial analytics platforms and data products at Colgate-Palmolive. The ideal candidate will be comfortable wearing multiple hats – architecting, developing and automating data transformation pipelines integrating global data sources in operationally efficient manner to enable strategic analytics capabilities in key business practices such as Revenue Growth Management and helping define and run a data ops approach for supporting our production data architecture once scaled.
At Colgate-Palmolive, we have a culture of strong global, cross-functional collaboration so as a Lead/Manager, you will partner with teams across the world, including Global IT, data science and advanced analytics within Global and Divisional Analytics teams as well as various business functions such as Customer Development, Finance, Marketing, etc. In addition to architecting robust data transformation pipelines, your responsibilities will include leading the support, maintenance and operational stability, timeliness and quality of data delivery in partnership with the Global IT data ops team. Lastly, as a lead technical member of the Global Analytics Data Foundation Team, there will be opportunities to recruit, mentor and lead junior staff and/or external support as we further build out our expertise and capabilities over time.
What you will do
- Lead the development of the data foundation architecture that will deliver timely and accurate data to power strategic Pricing & RGM Analytics as well as other data products for use throughout the global commercial organization
- Use SQL (dbt) and Python (Airflow) to architect production-quality code/pipelines to meet the data transformation needs of Global Analytics applications, data scientists, and other business partners
- Translate business requirements and logic into well-documented data architecture and data models to drive clarity and efficiency for end users
- Collaborate cross functionally to understand and identify data needs and opportunities to use data to drive business solutions
- Support the use of analytics platforms and data science workflows, while identifying ways to strengthen and scale our data foundation
- Partner with Global IT to align on data architecture, analytics tools, and other related data technologies (e.g. data quality tools, data catalog, etc.)
Required Qualifications
- Bachelor’s Degree in a quantitative field
- 8+ years of professional experience as “hands-on” lead data architect, data solutions architect or data engineer with track record of architecting and supporting a complex, global scale data architecture/implementation for BI and/or downstream analytics workloads
- Proven experience of modern data warehouse design principles within leading cloud warehouse (Snowflake, Databricks, Bigquery) along with data architecture/modeling and data engineering best practices including CI/CD
- Proven expertise in the use of complex SQL and/or Python to clean and integrate data from a variety of sources in reproducible, robust production transformation pipelines including complex data processing frameworks for handling different cadence of data delivery from various external and internal sources, incremental processing vs. full refreshes, etc.
- Mentoring or resource management experience- either internal or consultants
- A change maker – an ambitious, partnering data technologist that is motivated to solve business problems through thoughtful, fit-for-purpose data solutions
Preferred Qualifications
- Master’s degree in a relevant field or related subject area (Computer Science, Engineering, Business Management, etc.)
- Experience working on a global team that spans many geographies/timezones
- Demonstrated expertise with Git/GitHub, dbt Core/Cloud, and Airflow
- Proven understanding and experience with syndicated sales (Nielsen, IRI) and/or retailer POS (point of sale) data sources for use within BI/analytics
#LI-Hybrid
Salary Range $100,000 – $147,000 USD
Pay is based on several non discriminatory factors including but not limited to experience, education, skills and office location. In addition to your salary, Colgate-Palmolive offers a performance based bonus and competitive benefits package.
Equal Opportunity Employer
Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, gender, gender identity, sexual orientation, national origin, ethnicity, age, disability, marital status, veteran status (United States positions), or any other characteristic protected by law.
Are you interested in working for Colgate-Palmolive? You can apply online and attach all relevant documents such as a cover letter and resume or CV. Applications received by e-mail are not considered in the selection process. Become part of our team. We look forward to your application.
Colgate-Palmolive is a leading global consumer products company, tightly focused on Oral Care, Personal Care, Home Care and Pet Nutrition. Colgate sells its products in over 200 countries and territories around the world under such internationally recognized brand names as Colgate, Palmolive, elmex, Tom’s of Maine, Sorriso, Speed Stick, Lady Speed Stick, Softsoap, Irish Spring, Protex, Sanex, Elta MD, PCA Skin, Ajax, Axion, Fabuloso, Soupline and Suavitel, as well as Hill’s Science Diet and Hill’s Prescription Diet.
For more information about Colgate’s global business, visit the Company’s web site at http://www.colgatepalmolive.com. To learn more about Colgate Bright Smiles, Bright Futures® oral health education program, please visit http://www.colgatebsbf.com. To learn more about Hill’s and the Hill’s Food, Shelter & Love program please visit http://www.hillspet.com. To learn more about Tom’s of Maine please visit http://www.tomsofmaine.com.
Reasonable accommodation during the application process is available for persons with disabilities. Please contact Application_Accommodation@colpal.com with the subject “Accommodation Request” should you require accommodation.