Data Engineer II

You may know McCormick as a leader in herbs, spices, seasonings, and condiments – and we’re only getting started. At McCormick, we’re always looking for new people to bring their unique flavor to our team.

McCormick employees – all 14,000 of us across the world – are what makes this company a great place to work.

We are hiring immediately for a Data Engineer II.

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:

• 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

Role Summary: 

As a Data Engineer at McCormick, you will play a pivotal role in delivering the design, development, implementation, and maintenance of data and analytics solutions from simple to complex, and supporting McCormick business units with their data and analytics needs. Your responsibilities will include delivering and supporting analytics systems, tooling, and solutions, researching new features, developing innovative automations, supporting existing analytics solutions, and collaborating with third-party vendors.  You will support Data Scientists and Data Analysts to convert business expectations into data solutions and data models usable by business to deliver analysis, reporting, and data-driven recommendations to stakeholders and executives.

The role will report to the Azure Analytics Product Owner and requires close collaboration with the entire Enterprise Data Services team to conceptualize, visualize, and build an enterprise data management framework.

Key Responsibilities: 

Plan and Design

• Collaborate with business stakeholders to gather analytics requirements. Design solutions and plan implementation including data security, data quality and performance requirements.

Data Extraction, Load and Transformation

• Implement 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

Performance and Cost optimization tuning

• Identify and design internal process improvements, including automating manual processes, optimizing data delivery, and redesigning solutions for enhanced scalability. Work with Azure Analytics Product Owner to prioritize and schedule implementation.
• Implement solution re-designs to improve performance and cost-effectiveness.

Process Improvement, Issue Resolution

• Collaborate with Data Science, Machine Learning and Business Analytics teams to optimize performance and cost effectiveness of their analytics solutions.
• Assist stakeholders with data-related technical issues and support their data needs. Work with the Analytics Operational Support team to investigate, troubleshoot, and resolve data errors / discrepancies.
• Provide expert-level support and guidance to data teams across the Enterprise.
• Suggest and introduce best practices for data engineering

Key Skills Required/ Qualifications: 

• Bachelor's degree in computer science or other relevant discipline
• 8+ years of experience in data engineering
• Proven experience with Azure Analytics toolset (Data Factory, Synapse, Storage Accounts, Key Vault)
• Proficiency with T-SQL, Python, PySpark
• Performance tuning experience within the Azure analytics environment: parquet/delta files, SQL databases, data warehouses, ingestion tuning, cache optimization, etc.
• Very good communication skills including ability to interact closely with business stakeholders.
• Experience with Agile methodologies (Azure DevOps).
• Familiar with SAP and/or SAP BW.
• Power BI knowledge at level that will allow smooth cooperation with Power BI Engineering team and business Power BI developers.
• Experience with CI/CD tools (Azure DevOps, Git)

McCormick & Company is an equal opportunity/affirmative action employer. All qualified applicants will receive consideration for employment without regard to sex, gender identity, sexual orientation, race, color, religion, national origin, disability, protected veteran status, age, or any other characteristic protected by law.

As a general policy, McCormick does not offer employment visa sponsorships upon hire or in the future.