Specialist/sr. Specialist, Data Engineering

Established in 1806 as a small soap and candle business in New York City Colgate-Palmolive is now a truly global company with products sold in over 200 countries and territories under such internationally recognized brand names as Colgate Palmolive Softsoap Irish Spring Protex Sorriso Kolynos elmex Tom s of Maine Sanex Ajax Axion Soupline Haci Sakir Suavitel PCA SKIN EltaMD Filorga and Hello as well as Hill s Science Diet and Hill s Prescription Diet Colgate-Palmolive is a leading consumer products company that serves hundreds of millions of consumers worldwide with brands and products across four core businesses - Oral Care Personal Care Home Care and Pet Nutrition We are committed to offering products that make lives healthier and more enjoyable and programs that enrich communities around the world Every day millions of people trust our products to care for themselves and the ones they love Our goal is to use our technology to create products that will continue to improve the quality of life for our consumers wherever they live A career at Colgate-Palmolive is an excellent opportunity if you seek a global experience constant challenge and development opportunities in an environment that respects work life effectiveness Information at a Glance Job Title Specialist Sr Specialist Data Engineering Travel Required No Travel Posting Start Date 10 1 25 Hybrid Relocation Assistance Offered Within Country Job Number 169530 - Mumbai Maharashtra India Who We Are Colgate-Palmolive Company is a global consumer products company operating in over 200 countries specializing in Oral Care Personal Care Home Care Skin Care and Pet Nutrition Our products are trusted in more households than any other brand in the world making us a household name Join Colgate-Palmolive a caring innovative growth company reimagining a healthier future for people their pets and our planet Guided by our core values-Caring Inclusive and Courageous-we foster a culture that inspires our people to achieve common goals Together let s build a brighter healthier future for all Brief introduction - Role Summary Purpose Colgate-Palmolive is looking for a Specialist Data Engineer to join its growing Global Information Technology organization The Specialist Data Engineer will work closely with the discrete business areas as well as the Global Information Technology functional organizations across the globe The successful candidate will be managing and developing the solution which entails planning design development and maintenance of our data repositories pipeline and analytical solutions The ideal candidate is self driven and looking to build high quality tools to deliver actionable insights to our business partners to facilitate data-driven decision making The candidate needs to be a self-starter - eager to learn new technologies extract insights and value from data and how to demonstrate technology to deliver those insights through efficient data pipelines Additionally knowledge of cloud environments and automation optimisation skills would be good as well Should be experienced in ETL pipelines and aware of code standards The candidate should be able to play a lead role towards the evolution of technology deployments across the global footprint Responsibilities Major position responsibilities include but are not limited to the following You are excited at the prospect of demonstrating technology to solve complex data problems Build data applications on Google cloud platform and integrate with different data sources tools Design develop and maintain a world class data warehouse and analytics architecture to meet business analysis reporting needs and data science initiatives Work directly with divisional and global business users and data scientists to assist in project analysis Participate in the development and maintenance of ETL jobs and data pipelines to aggregate data from various on premise cloud platforms external data sources Design and develop data marts for consumption by analytics tools and end users Develop code standards guidelines to manage and ensure data quality and integrity Optimize and scale data warehouse and data processing infrastructure Evaluate new technologies and constantly work towards continuous improvements in data engineering our platform and the organization Required Qualifications Bachelor s degree required Graduate degree or equivalent experience in Computer Science Statistics Informatics Information Systems or another quantitative field would be an advantage Ability to work as a Data Engineer with minimum 3years of experience At least 1 year of experience in data warehousing analytical tools like Tableau etc Demonstrates expertise in data modeling ETL development and Data warehousing Knowledge of data management fundamentals and data storage principles Experience with Python or similar programming languages Working SQL knowledge and experience working with relational databases query authoring SQL as well as working familiarity with a variety of databases Experience in CI CD workflow approaches Knowledge of Python Terraform docker Kubernetes cloud functions snowflake BigQuery DBT Experience with Git for version control Strong analytical problem solving conceptual skills Preferred Qualifications Experience building and optimizing big data data pipelines architectures and data sets Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement Experience with data warehousing platforms storage platforms such as SAP BW HANA Experience with SAP data extractors SAP Integration tools like SLT SDI understanding of Supply chain processes is preferred Experience with cloud data warehousing Big data environments like Snowflakes BigQuery Google cloud storage etc is a plus Experience with object-oriented object function scripting languages Python Java etc Experience with data pipelines and streaming frameworks such as Pubsub Spark Airflow Kafka etc Experience with RDBMS NoSQL experience also encouraged Ability to embrace learn and apply new technologies and tools Familiarity with agile software development methodology Should be able to communicate well with both technical and non-technical teams Our Commitment to Inclusion Our journey begins with our people-developing strong talent with diverse backgrounds and perspectives to best serve our consumers around the world and fostering an inclusive environment where everyone feels a true sense of belonging We are dedicated to ensuring that each individual can be their authentic self is treated with respect and is empowered by leadership to contribute meaningfully to our business 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 Reasonable accommodation during the application process is available for persons with disabilities Please complete this