Sr. Data Analyst, Supply Chain Analytics

Scotts Miracle-Gro•Minneapolis, MN

18h•$125,000 - $147,100•Remote

About The Position

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.

Requirements

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

Nice To Haves

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

Responsibilities

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.
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.
Create automated pipelines to extract, process, and analyze data.
Turn ad hoc analyses and predictive models into sustainable, self-contained processes.
Utilize advanced statistical techniques to establish causal relationships and generate accurate forecasts of how business variables will affect future sales
Design, deploy, and maintain comprehensive reports and dashboards using BI tools in collaboration with our BI team (e.g., Tableau, Looker).
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.

Benefits

Medical coverage
Dental coverage
Vision coverage
Wellness reimbursement program
401K match (up to 7.5%)
15% discount on company stock
Maven Family Planning
Up to $30,000 to accommodate for adoption, fertility and surrogacy
Employee Resource Groups (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)
Community service opportunities