Apply on Employer Site

Colgate-Palmolive · 2 weeks ago

Master Data Analytics Engineer

Piscataway, NJ

Full-time

Onsite

Mid Level

$94K/yr - $133K/yr

3+ years exp

Colgate-Palmolive Company is a global consumer products company specializing in various sectors including Oral Care and Personal Care. They are seeking a Master Data Analytics Engineer to design, develop, and operationalize scalable master data solutions that support analytics and digital transformation initiatives.

BeautyConsumer GoodsHealth CarePersonal Care and Hygiene

Comp. & Benefits

No H1B

Responsibilities

Transform raw master data into analytics-ready datasets through robust ETL/ELT pipelines, data modeling, and documentation to enable business intelligence, advanced analytics, and self-service initiatives

Apply data modeling best practices to create and maintain scalable data models on Snowflake (using SQL, Python, DBT, or similar tools)

Develop, maintain, and enhance data assets for enterprise-wide consumption using the CP Enterprise Data Platform on Snowflake

Design, implement, and optimize technical data governance and analytics solutions that serve end-to-end business processes and data domains

Manage a centralized and reliable data repository to ensure consistent, standardized, and accurate master data (Product, Supplier, Customer) across systems and analytics use cases

Ensure high data quality, governance, and compliance with company standards and best practices throughout the data lifecycle

Provide day-to-day support for solution delivery, ongoing operations, and application management

Collaborate cross-functionally to gather requirements, troubleshoot data issues, and continuously improve master data analytics capabilities

Facilitate clear, timely communication across cross-functional teams; synthesize updates, risks, and decisions

Qualification

SnowflakeDBTETL/ELTPythonSQLData modelingData governanceAnalytical skillsVersion controlCI/CD processesSAP ERP

Required

Bachelor's degree in Computer Science, Information Technology, Engineering, or a related field

3+ years of experience in data engineering, data architecture, or a similar role

Demonstrated hands-on experience with enterprise level Snowflake and DBT for data warehousing, data modeling, and analytics pipeline development

Strong Python, SQL, and analytical skills; experience building analytics datasets and ETL/ELT pipelines with large, complex data

Strong understanding of data modeling techniques, modern data architectures, ETL/ELT practices, data integration patterns, and API management

Familiarity with data governance frameworks, metadata management, and data lineage concepts

Familiarity with version control and CI/CD processes (e.g., GitHub, GitHub Actions)

Preferred

Experience with SAP ERP environments, including familiarity with SAP Master Data Governance and understanding of SAP data structures and integration methods

Demonstrated experience implementing or supporting data registry solutions, and experience integrating with both on-premise and cloud-based sources