Data Architect - Global Technology
About The Position
Colgate-Palmolive is seeking a Data Architect to support digital transformation and data engineering initiatives, particularly involving global supply-chain data. The role is described as a hands-on technical lead who partners with Data Delivery Leads and Data Engineers to build and deliver high-performance data products. Responsibilities include resolving technical blockers, reviewing code, ensuring engineering standards, delivering datasets for core supply-chain metrics, and coordinating work across concurrent initiatives. The posting also describes work associated with Python, SQL, Snowflake, dbt, Airflow, and cloud data warehousing and orchestration. The position is based in Piscataway, New Jersey, and is marked hybrid. No relocation assistance is offered. The stated salary range is $86,000–$121,000 USD. Salaried employees may be eligible for discretionary bonuses, profit-sharing, and, for executive-level roles, long-term incentives. Benefits include medical, dental, vision, basic life insurance, paid parental leave, disability coverage, a 401(k) plan with company matching subject to eligibility, at least 15 vacation/PTO days, 13 paid holidays, and paid sick leave subject to role, location, and applicable policies or laws.
Requirements
- Bachelor’s degree in Computer Science, Industrial Engineering, Supply Chain, or a related quantitative field.
- At least 4 years of total experience in Data Engineering and Data Architecting.
- Hands-on experience with Python, SQL, dbt, and Airflow.
- Hands-on experience creating ERDs and DFDs.
- Data warehouse experience; Snowflake is preferred.
- Must be eligible to work in the United States without current or future visa sponsorship.
Nice To Haves
- Background in Consumer Packaged Goods or high-volume retail/logistics environments.
- Exposure to automated testing tools such as Great Expectations, Monte Carlo, or dbt tests.
- Experience using Lucid.
Responsibilities
- Serve as the hands-on lead resolving technical blockers across Python, SQL, Snowflake, and dbt pipelines.
- Review GitHub pull requests to enforce testing, quality, and platform standards.
- Ensure engineering aligns with modern cloud data warehousing and orchestration standards, including Airflow and GKE.
- Deliver datasets for core metrics, including OTIF, Forecast Accuracy, and Inventory, using data from SAP, Kinaxis, and WMS/TMS tools.
- Manage sprint backlogs, project timelines, internal engineers, and third-party consultants across concurrent initiatives.
- Partner with Data Delivery Leads and Data Engineers to build and deliver high-performance data products.
Benefits
- Medical insurance
- Dental insurance
- Vision insurance
- Basic life insurance
- Paid parental leave
- Disability coverage
- 401(k) retirement plan with company matching contributions, subject to eligibility
- Minimum of 15 vacation/PTO days for salaried employees
- 13 paid holidays
- Paid sick leave, adjusted based on role and location in accordance with local laws
- Potential eligibility for discretionary bonuses and profit-sharing
- Long-term incentives for Executive-level roles
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Mid Level
