← back to jobs
> job detail
M
👽Other

Senior Data Engineer

McCormick & Company · GURGAON, IN, 122001
// classified as
Other (Adjacent or hard to classify.)
posted
1d ago
location
GURGAON, IN, 122001
languages
sql
tools
azure
> stack
sqlazurepyspark
> description
<p> </p> <p><span style="font-family:georgia, palatino, serif;color:black">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.</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">McCormick employees – all 14,000 of us across the world – are what makes this company a great place to work.</span></p> <p><span style="font-family:georgia, palatino, serif;color:black"><strong>What We Bring To The Table:</strong></span></p> <p><span style="font-family:georgia, palatino, serif;color:black">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:</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">• Competitive compensation</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">• Career growth opportunities</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">• Flexibility and Support for Diverse Life Stages and Choices</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">• 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)</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">• Wellbeing programs including Physical, Mental and Financial wellness</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">• Tuition assistance</span></p> <p> </p> <p> </p><p><span style="font-family:georgia, palatino, serif;color:black">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. </span><br><br><span style="font-family:georgia, palatino, serif;color:black">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.</span><br><br><span style="font-family:georgia, palatino, serif;color:black">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 from <strong>2-5 source systems.</strong></span></p> <p> </p> <p><span style="font-family:georgia, palatino, serif;color:black"><strong>Design and Execute<br></strong>• Partner with data product managers to gather and deliver data pipelines.</span><br><span style="font-family:georgia, palatino, serif;color:black">• Design ETL solutions including data quality, data security, and data pipeline resiliency. </span><br><span style="font-family:georgia, palatino, serif;color:black">• Execute ETL solutions including data security, data quality and performance requirements.</span></p> <p><span style="font-family:georgia, palatino, serif;color:black"><strong>Data Extraction, Load and Transformation<br></strong>• Design, build and implement ELT pipelines to efficiently ingest and transform data from a wide variety of data sources and deliver datasets that meet business requirements. </span><br><span style="font-family:georgia, palatino, serif;color:black">• Optimize performance for large datasets and data workflows for performance, scalability, and reliability to support business needs.</span><br><span style="font-family:georgia, palatino, serif;color:black">• Develop and maintain scalable data pipelines leveraging Azure Synapse, PySpark, APIs, and SQL &amp; performing advanced data cleaning, transformation, and manipulation to ensure high-quality, and reliable data flows. </span><br><span style="font-family:georgia, palatino, serif;color:black">• Implement CI/CD processes to streamline and automate data pipelines deployment</span><br><span style="font-family:georgia, palatino, serif;color:black">• Apply data validation frameworks (Great Expectations, Fabric-native tools) to maintain accuracy</span><br><span style="font-family:georgia, palatino, serif;color:black">• Utilize partitioning, indexing, clustering strategies to enhance query performance</span></p> <p><span style="font-family:georgia, palatino, serif;color:black"><strong>Process Improvement, Performance and Cost optimization tuning<br></strong>• Collaborate with Data Science, AI, and Data product teams to optimize performance and cost effectiveness of their solutions. </span><br><span style="font-family:georgia, palatino, serif;color:black">• Identify and support the design of internal process improvements, including automating manual processes, optimizing data product delivery, and redesigning solutions for enhanced scalability. </span><br><span style="font-family:georgia, palatino, serif;color:black">• Implement solution adjustments to improve performance and cost-effectiveness of data products.</span></p> <p><span style="font-family:georgia, palatino, serif;color:black"><strong>Issue Resolution and Support<br></strong>• Monitor and troubleshoot the data pipelines proactively, which includes leading the support of data-related product pipeline issues to resolve data errors. </span><br><span style="font-family:georgia, palatino, serif;color:black">• Provide expert-level support and guidance to data teams across the Enterprise.</span></p> <p> </p> <p><strong><span style="font-family:georgia, palatino, serif;color:black">Desired Candidate Profile: </span></strong></p> <ul> <li><span style="font-family:georgia, palatino, serif;color:black">Bachelor’s degree in Mathematics, Statistics, Computer Science, Data Analytics/Science, or related field</span></li> <li><span style="font-family:georgia, palatino, serif;color:black">Microsoft Certified: Azure Data Engineer (DP203)</span><br><span style="font-family:georgia, palatino, serif;color:black">or Microsoft Certified: Fabric Data Engineer Associate or related cloud technologies, Fabric IQ/Databricks certifications a plus</span><span style="font-family:georgia, palatino, serif;color:black"><strong>3-6+ years</strong> of data engineering experience.</span></li> <li><span style="font-family:georgia, palatino, serif;color:black">Demonstrated ability coding in one or more languages (PySpark preferred).</span></li> <li><span style="font-family:georgia, palatino, serif;color:black">Experience with building data pipelines.</span></li> <li><span style="font-family:georgia, palatino, serif;color:black">Experience with knowledge graphs a plus.</span></li> <li><span style="font-family:georgia, palatino, serif;color:black">Demonstrated ability to manage multiple priorities simultaneously.</span></li> <li><span style="font-family:georgia, palatino, serif;color:black">Demonstrated ownership of production-grade pipelines.</span></li> </ul> <p> </p> <p> </p><p> </p> <p><span style="font-family:georgia, palatino, serif;color:black">McCormick &amp; 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.</span></p> <p><span style="font-family:georgia, palatino, serif;color:black">As a general policy, McCormick does not offer employment visa sponsorships upon hire or in the future. </span></p>