Senior Data Engineer - T&T

About the Position

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, McCormick is a global leader in flavor. 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 flavorful products to the entire food industry, retail outlets, food manufactures, food service businesses and consumers.

What We Bring To The Table:

• Competitive compensation
• 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
• Tuition assistance

Responsibilities

As a Senior 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.

Key Responsibilities

1. Execute

   • Collaborate with data product managers to gather data requirements
   • 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

Requirements

Education and Certifications

• Bachelor’s degree in Mathematics, Statistics, Computer Science, Data Analytics/Science, or related field
• Microsoft Certified: Azure Data Engineer Associate (DP-900) or Microsoft Certified: Fabric Data Engineer Associate or related cloud technologies, Fabric IQ/databricks certifications a plus

Experience

• 5-8 years of data engineering experience
• Demonstrated ability coding in one or more languages (PySpark preferred)
• Experience with building data pipelines
• Demonstrated ability to manage multiple priorities simultaneously
• Basic SQL performance tuning
• Structured + semi-structured data handling
• Unit testing for pipelines
• Git-based workflow
• Exposure to medallion architecture
• Understanding of data privacy basics

Interpersonal Skills

• Effective communication skills and ability to communicate effectively on technical and business issues both internally and externally
• Ability to work independently, navigate problems, resolve conflicts, and bring solutions to the table
• Build strong interpersonal relationships
• Time management and prioritization skills
• Strong technical curiosity and passion for problem solving and innovation
• Ongoing aspiration to learn about new industry tools

Other Skills & Competencies

• Knowledge of data analysis, visualization techniques, and frameworks
• Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement
• Experience with the following tooling: SQL, Fabric, Databricks, Synapse, Azure Data Factory, Azure ML, Azure DevOps (for CI/CD), GCP BigQuery, FiveTran, GCP Cloud Composer, GCP DLP (Data Loss Prevention), GCP Cloud Run, Vertex AI etc

We Offer

• Competitive compensation
• Career growth opportunities
• Flexibility and Support for Diverse Life Stages and Choices
• Wellbeing programs including Physical, Mental and Financial wellness
• Tuition assistance

About the Company

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.