Sr. Technical Specialist

Colgate-Palmolive; Mumbai; On-site; INR 800,000 - 1,200,000; Full time

Job summary

Colgate-Palmolive is looking for a Sr. Technology Associate / Specialist in Analytics Engineering located in Mumbai, India. The successful candidate will manage the data lifecycle, develop dashboards in Sigma, and construct resilient ELT pipelines utilizing dbt and Airflow.

This role demands a combination of technical and strategic skills, requiring proficiency in SQL, Snowflake, and Python. You will work closely with business leaders to translate technical requirements into actionable solutions.

Qualifications

• More than 3 years of experience in Data Engineering and Business Intelligence.
• Proficiency in Snowflake and dbt.
• Skilled in workflow orchestration via Airflow.

Responsibilities

• Construct and manage resilient data pipelines into Snowflake.
• Leverage dbt for transformation processes and maintain data lineage.
• Orchestrate workflows via Airflow with CI/CD practices.

Skills

Data Engineering

SQL

Snowflake

Python

dbt

Airflow

Education

Bachelor’s degree in Computer Science, Data Analytics, or related field

Tools

Sigma

Domo

Job description

Title

Sr. Technology Associate / Specialist, Analytics Engineering

Brief Introduction – Role Summary / Purpose

1. This position requires a high-impact Data Engineer capable of connecting sophisticated technical processes with strategic leadership narratives. The candidate will manage the complete data lifecycle, facilitating ingestion within Snowflake and developing influential dashboards to guide organizational decision-making.

2. The role demands expertise in constructing resilient ELT pipelines through dbt and Airflow, combined with the professional insight to design persuasive visual analytics. Acting as a strategic advisor, the individual will convert Customer Development inquiries into actionable technical solutions.

Responsibilities

• Architectural Oversight: Construct and oversee resilient, enterprise-grade pipelines sourcing from diverse environments into Snowflake tiered data structures.
• Logic Implementation: Leverage dbt for sophisticated transformation processes, maintaining rigorous standards for data lineage and modular integrity.
• Workflow Management: Orchestrate sophisticated schedules via Airflow while utilizing GitHub to enforce professional CI/CD versioning protocols.
• Visual Mastery: Engineer high-impact dashboards within Sigma, prioritizing professional aesthetics and seamless user navigation.
• Strategic Storytelling: Transform raw metrics into persuasive narratives, elucidating commercial trends and anomalies for executive-level comprehension.
• Executive Reporting: Direct the automated distribution of high-priority analytics, guaranteeing absolute precision and adherence to reporting timelines.
• Collaborative Discovery: Facilitate strategic sessions with business leads to synthesize technical requirements.
• Inter-Departmental Translation: Function as a technical advisor, bridging the gap between engineering capabilities and strategic organizational goals.
• Standards Governance: Establish team-wide benchmarks for optimized SQL development and sophisticated data visualization methodologies.
• Quality Assurance: Direct rigorous peer evaluations to ensure performance optimization and maintain consistency with brand presentation standards.

Required Qualifications

• Academic Foundation: Bachelor’s degree within Computer Science, Data Analytics, Mathematics, or an equivalent quantitative discipline.
• Professional Tenure: Over 3+ years of technical experience specializing in Data Engineering and enterprise Business Intelligence.
• Technological Mastery: Proficiency in Snowflake, SQL, and dbt transformation protocols.
• Technical Proficiency: Skilled in Python development and workflow orchestration via Airflow.
• Visualization Expertise: Professional-grade design capabilities in Sigma, Domo.
• Ability to translate business requirements into technical specifications.

Preferred Qualifications

• Communication Skills: Written, verbal and Business presentation skills.
• People oriented.
• Cloud Platform Acumen: Demonstrated experience with key services in major public cloud environments (e.g., AWS, GCP, Azure).
• Agile Methodologies: Practical experience operating within Agile/Scrum frameworks, contributing to predictable sprint execution.
• Advanced Data Governance: Familiarity with implementing advanced metadata management and data governance frameworks.

Equal Opportunity Employer

Colgate is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, colour, 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.