Analytics Engineer
Colgate-Palmolive
Salary
Salary Range $91,200.00 - $140,000.00 USD
Our Analytics Engineer develops digital infrastructure and data pipelines to accelerate product innovation, product design, and product development. You will work with cross functional teams to gather, wrangle, cleanse, structure and build data products that support the analytics goals of the Global Technology community and the broader organization. The Analytics Engineer builds and maintains the foundational data analytics infrastructure to enable new revenue-generating business models and improve underlying business processes for cost savings. You will lead, manage, and mentor others to expand the team’s capabilities and collective knowledge.
What you will do
- Use SQL and Python to write production-quality code to meet the data transformation needs of analysts, data scientists, and other business partners
- Support the use of analytics platforms and data science workflows, while identifying ways to strengthen and scale our data foundation
- Help design and develop transparent ELT pipelines that deliver timely and accurate data to end users
- Translate business requirements and logic into well-documented 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
- Communicate technical concepts to a non-technical audience in a compelling manner
- Evaluate external partners across different dimensions for analytics initiatives
- Partner with IT to align on data architecture, analytics tools, and other technologies
- Performs other duties as assigned
- Complies with all policies and standards
Required Qualifications
- Bachelors’ Degree in Science, Technology, Engineering, Math or Computer Science
- 4+ years of Data Engineering experience
- High level of Python & SQL proficiency
- Experience building ETL/ELT pipelines
- Strong familiarity with cloud computing platforms
- Strong familiarity with SAP S4/ECC tables
Preferred Qualifications
- Consumer Goods Proven Experience
- Active GitHub account with examples of past work is helpful
- Master’s Degree or Professional Certification in Data Engineering or Cloud Computing Platform
- Proficiency with at least one other programming language in addition to Python
- Familiarity with Google Cloud Platform
- Familiarity with Apache Airflow
- Familiarity with dbt
- Familiarity with Snowflake or Google Big Query
- Familiarity with data analytics workflows, objectives, tech stacks, common terminology