Sr. Data Analyst, Supply Chain Analytics

Here at Scotts Miracle-Gro there is no such thing as a typical day. Our culture is constantly energized by new and exciting growth opportunities and at a rapid pace. Below are details on an open job. If the role interests you and you would like to be considered we encourage you to apply!

As a Senior Data Analyst in our Supply Chain Analytics group you will play a critical role in analyzing complex data, creating insights and predictions, and automating analytical processes.

Your goal is to produce and deploy predictive analytics that help the Scotts Miracle-Gro Supply Chain anticipate the future and make better, faster decisions. You will collect and build datasets from multiple sources, use statistics to understand the data, and turn the resulting analytics into sustainable workflows that power our decision-making, planning, and forecasting. You will also help business users work more efficiently by providing them with better data, resolving data bottlenecks, and automating the analytics they need to drive our company towards our financial goals.

The position requires advanced analytical skills, complete comfort working with large datasets, passion for continuous improvement, and collaboration with cross-functional teams. Good communication skills are as essential as good analytic skills.

This is your opportunity to drive transformative change and make a difference in vital business decisions, while working with best-in-class technologies and growing your skills. If this is your calling, then here is what you can expect to do in the role:

Data Analysis and Interpretation: Conduct in-depth analysis of large, complex datasets that encompass Sales, Marketing, and Operational data to derive meaningful insights for the future. Interpret data trends and patterns, providing actionable recommendations to stakeholders. Leverage the right Python libraries, SQL, or other tools for the job.

Building, Cleaning, and Maintaining Large Datasets: Combine data from various sources (from local text and Excel files to SQL tables and data lakes). Clean and process raw data to create large, actionable datasets that can be analyzed or used in various workflows. Select the right tools for each task. Take ownership of the quality of the resulting data.

Automating Analytical Workflows: Create automated pipelines to extract, process, and analyze data. Turn ad hoc analyses and predictive models into sustainable, self-contained processes.

Predictive Analytics and Modeling: Utilize advanced statistical techniques to establish causal relationships and generate accurate forecasts of how business variables will affect future sales

Report Development and Visualization: Design, deploy, and maintain comprehensive reports and dashboards using BI tools in collaboration with our BI team (e.g., Tableau, Looker).

Stakeholder Collaboration: Collaborate with business stakeholders to understand their information needs. Gather requirements for analytical projects and create a plan of action to deliver the right data in the right way. Present findings and insights to both technical and non-technical audiences.

What you'll need to be successful:

• Bachelor's or Master's Degree: Data Analytics, Data Science, Information Systems, or Statistics (a degree in a different field will be considered if candidate has substantial work experience with predictive data analytics and coding)
• 2 - 3 years of experience with data analytics in Python and SQL
• 2 - 3 years of experience working with cross-functional teams in a corporate environment

Demonstrated experience delivering large scale analytical projects (from raw data to fully deployed models and reports) in a corporate environment

Key Skills:

• Python
• SQL
• Strong knowledge of core Python libraries, Pandas, and Numpy
• Cleaning, combining, and preparing a wide variety of data formats for analysis, including messy data with missing values, problematic data types, etc.
• Handling very large amounts of data (millions or rows, many joined tables) efficiently by selecting the right tool for each task
• Statistics: regressions, probability distributions, confidence intervals, ability to communicate basic statistical concepts to non-technical audiences
• Communicating effectively with business counterparts to understand their needs
• Collaborating with other technical experts on large projects

Preferred skills:

• Some knowledge of Tableau
• Some knowledge of Apache Spark (especially PySpark)
• Some knowledge of SAP and SAP BW
• Some knowledge of machine learning models for predictive analytics
• Experience with cloud-based data pipelines and data lakes, especially in AWS

What you get:

• Exposure to a wide variety of cutting edge tools, such as Databricks, Sigma, and AWS (we are not an Excel shop)

Opportunity to put your own stamp on how analytics are done

• Be a critical part of Scotts Miracle-Gro's transformation journey

Competitive benefits

• Highly collaborative and positive work environment

The starting budgeted pay range for this role will generally fall between $125,000.00 - $147,100.00 per year. Scotts will consider various factors in determining the actual pay including your skills, qualifications, experience, and geographical location.In addition to the determined base salary, this role is also incentive eligible under our corporate bonus programs.For remote roles where the final candidate resides in Alaska, California, Colorado, Illinois, New York, Oregon or Washington, state required pay thresholds will be factored into base salary.

Here at ScottsMiracle-Gro, we believe providing an enriching and engaging employee experience is what sets us apart from other organizations. We recognize our employees are so much more than just their job title so we offer programs and benefits that support them in all aspects of their lives. Wondering how we do it? Below is a glimpse of our highlight reel…

• Our Live Total Health program provides you with options to align to your personal needs. Selections range from medical, dental and vision coverage for you, your spouse/domestic partner and dependents to an outstanding wellness reimbursement program to an unbelievable 401K match (up to 7.5%) as well as a 15% discount on company stock and much more

• We know our talent is our most precious asset and your unique development contributes to our organization's success now and in the future. Career growth at our company is not always a ladder. It's much more like a rock climbing adventure. Grow through exploration and experiences rather than a predictable linear path.

• We value the importance of family. We provide access to Maven Family Planning and up to $30,000 to accommodate for adoption, fertility and surrogacy.

• Be part of something bigger by joining one of our Employee Resource Groups focusing on diversity and inclusion, family, education and sustainability: Scotts Women's Network, Scotts Black Employees' Network, Scotts Veterans Network, Scotts Young Professionals, Scotts Pride Network (GroPride), Scotts Associates for a Greener Earth (SAGE), Scotts Family TREE and our Associate Boards.

• Join a company with a strong belief in giving back to the communities where we live and work. We have a shared passion for service and volunteerism and believe participating in community service benefits our communities and strengthens our team.

Not interested in this role? Stay up to date on future opportunities by joining our ScottsMiracle-Gro and Hawthorne Gardening talent communities.

Scotts is an EEO Employer, dedicated to a culturally diverse, drug free workplace.

EEO/AA Employer/Minority/Female/Disability/Veteran/Sexual Orientation/Gender Identity

Notification to Agencies:

Please note that the Scotts Miracle-Gro company does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Master Service Agreement, and specific approval to submit resumes to an approved requisition, the Scotts Miracle-Gro company will not consider or approve payment regarding recruiter fees or referral compensations.