Senior Data Engineer - T&T

McCormick & Company, Incorporated; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Benefits offered by this job

Career growth opportunities

Flexibility and Support for Diverse/ L

Wellbeing programs

Job summary

McCormick & Company, Incorporated is seeking a Data Engineer in India to build and deliver data products, support analytics needs, and ensure data quality and security. You will develop scalable ETL/ELT pipelines, model data, and collaborate with Data Scientists and Analysts to translate business requirements into reliable data assets.

The role focuses on data ingestion from source systems, data cleansing, and deploying data solutions that enable AI, reporting, and data-driven recommendations

Qualifications

• Experience in data engineering with ETL pipelines.
• Experience with data modeling, data quality, and data security.
• Experience using Azure Synapse, PySpark, APIs, and SQL.

Responsibilities

• Execute ETL solutions with data security and quality requirements.
• Ingest and transform data from multiple sources using ELT pipelines.
• Maintain and optimize scalable data pipelines (Azure Synapse, PySpark, SQL).
• Collaborate with data product teams to improve performance and cost efficiency.
• Support data-related product pipelines and troubleshoot data issues.

Skills

ETL development

Data modeling

Data quality

Data security

Azure Synapse

PySpark

SQL

APIs

Documentation

Tools

Azure Synapse

APIs

PySpark

SQL

Job description

Select how often (in days) to receive an alert:

At McCormick, we bring our passion for flavor to work each day. We encourage growth, respect everyone's contributions and do what's right for our business, our people, our communities and our planet. Join us on our quest to make every meal and moment better.

Founded in Baltimore, MD in 1889 in a room and a cellar by 25-year-old Willoughby McCormick with three employees, McCormick is a global leader in flavour. With over 14,000 employees around the world and more than $6 Billion in annual sales, the Company manufactures, markets, and distributes spices, seasoning mixes, condiments and other flavourful products to the entire food industry, retail outlets, food manufacturers, food service businesses and consumers.

While our global headquarters are in the Baltimore, Maryland, USA area, McCormick operates and serves customers from nearly 60 locations in 25 countries and 170 markets in Asia-Pacific, China, Europe, Middle East and Africa, and the Americas, including North, South and Central America

What We Bring To The Table:

The best people deserve the best rewards. In addition to the benefits you’d expect from a global leader (401k, health insurance, paid time off, etc.) we also offer:

• Career growth opportunities
• Flexibility and Support for Diverse Life Stages and Choices
• We prioritize our communities and the planet we share. We are proud to be awarded as a Diversity Inc. Top 50 company for Diversity and have multiple Sustainability awards (ranking #22 in the World and #1 in Food Products)
• Wellbeing programs including Physical, Mental and Financial wellness

Position Overview

As a Data Engineer at McCormick, you will play a pivotal role in the build and delivery of data products from simple to complex and supporting McCormick business units with their data and analytics needs.

Your responsibilities will include delivering and supporting data for existing analytics solutions, tooling, and solutions, researching new features and implementing automations. You will support business users, Data Scientists and Data Analysts to convert business expectations into data products and data models usable by business to deliver AI, analysis, reporting, and data-driven recommendations to stakeholders and executives.

This role will be accountable for building and maintaining scalable data pipelines from source systems. The Data Engineer will ensure the availability, reliability, and performance of data products by integrating raw data from various sources. Key responsibilities include data modeling, ETL (Extract, Transform, Load) development, and ensuring data quality and security. This role will be accountable for data coming in from1-3 source systems.

Key Responsibilities

1. Execute

   Collaborate with data product managers to gather data requirement

   Execute ETL solutions including data security, data quality and performance requirements.

   Prepare documentation of data product lineage and all other related ETL topics.

2. Data Extraction, Load and Transformation
   • Implement and maintain ELT pipelines to efficiently ingest and transform data from a wide variety of data sources and deliver datasets that meet business requirements.
   • Ensure efficient and reliable data mapping to support business needs.
   • Deliver complete documentation and knowledge transfer sessions for the Team and business partners.
   • Maintain existing solutions, implement optimizations and enhancements, monitor data quality.
   • Support the development and maintenance of scalable data pipelines leveraging Azure Synapse, PySpark, APIs, and SQL & performing advanced data cleaning, transformation, and manipulation to ensure high-quality, and reliable data flows.
3. Process Improvement, Performance and Cost optimization tuning
   • Collaborate with Data Science, AI, and Data product teams to optimize performance and cost effectiveness of their solutions.
   • Identify and support the design of internal process improvements, including automating manual processes, optimizing data product delivery, and redesigning solutions for enhanced scalability.
   • Implement solution adjustments to improve performance and cost-effectiveness of data products.
4. Issue Resolution and Support
   • Assist stakeholders with data-related product pipeline issues and support their data product needs.
   • Work with the Analytics Operational Support team to investigate, troubleshoot, and resolve data errors / discrepancies.

At McCormick, we have over a 100-year legacy based on our “Power of People” principle. This principle fosters an unusually dedicated workforce requiring a culture of respect, recognition, inclusion and collaboration based on the highest ethical value

WHY WORK AT MCCORMICK?

As a McCormick employee you’ll be empowered to focus on more than your individual responsibilities. You’ll have the opportunity to be part of something bigger than yourself—to have a say in where the company is going and how it’s growing.

Between our passion for flavor, our 130-year history of leadership and integrity, the competitive and comprehensive benefits we offer, and our culture, which is built on respect and opportunities for growth, there are many reasons to join us at McCormick.