Analytics Engineer

Company: Colgate-Palmolive
Location: Piscataway
Posted on: March 18, 2023

Job Description:

No Relocation Assistance Offered
# 147440 - Piscataway, New Jersey, United States
Do you want to come to work with a smile and leave with one as well? In between those smiles, your day consists of working in a global organization, continually learning and collaborating, having 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.
What role will you play as a member of the Colgate's Information Technology team?
Analytics Engineers focus on expanding and optimizing our data, data pipeline architecture, data flow and collection for multi-functional teams. The Analytics Engineer will be an experienced data pipeline builder and data wrangler who enjoys optimizing data systems and building them from the ground up. You will support our software developers, data analysts and data scientists on data initiatives and will ensure efficient data delivery architecture is consistent throughout ongoing projects. You must be self-directed and comfortable supporting the data needs of multiple teams, systems and products. You will be excited by the prospect of optimizing or even re-designing our company's data architecture to support our next generation of products and data initiatives. This team is a group of innovators and technologists that love to learn and collaborate!
Main Responsibilities

• 
  
• 
  Build and maintain optimal data pipeline architecture
  
  
• 
  Build the infrastructure required for efficient extraction, transformation, and loading of data from a wide variety of data sources
  
  
• 
  Assist with data-related technical issues and support their data infrastructure needs
  
  
• 
  You connect the dots -
  
  
• 
  Assemble large, sophisticated data sets that meet functional / non-functional business requirements
  
  
• 
  Build data tools for analytics and business that assist them in building and optimizing our product into an innovative industry leader
  
  
• 
  You are a collaborator
  
  
• 
  Work with data and analytics specialists to strive for greater functionality in our data systems
  
  
• 
  Performs other duties as assigned
  
  
• 
  Complies with all policies and standards
  
  
  Basic Required Qualifications
  
  • 
    
  • 
    Bachelor's degree in Computer Science, Information Technology, Engineering, similar degree or experience.
    
    
  • 
    At least 5 years of experience in a Data Engineering role
    
    
  • 
    Experience with cloud services: GCP,AWS,Azure
    
    
  • 
    Experience with data pipelines and streaming frameworks such as dbt, Pub/Sub and Airflow
    
    
  • 
    Experience with object-oriented/object function scripting languages: Python, Java, etc.
    
    
  • 
    Working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases
    
    
    Preferred Qualifications:
    
    • 
      
    • 
      Master's Degree Computer Science, Statistics, Informatics, Information Systems or another quantitative field
      
      
    • 
      Experience with data warehousing platforms/storage platforms such as Snowflake, SAP BW/HANA Bigquery, Google cloud storage, etc.
      
      
    • 
      Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement
      
      
    • 
      Experience with business analytics tools such as Tableau, Domo, Data studio,Looker etc.
      
      
    • 
      Strong analytic skills related to working with unstructured datasets
      
      
      #LI-Hybrid
      #LI-Hybrid
      Salary Range $96,640 - $141,435
      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.

Keywords: Colgate-Palmolive, Trenton , Analytics Engineer, Engineering , Piscataway, New Jersey