Sr. Data Analyst, Supply Chain Analytics
Job
The Scotts Company LLC
Columbus, OH (In Person)
$136,050 Salary, Full-Time
Review key factors to help you decide if the role fits your goals.
Pay Growth
?
out of 5
Not enough data
Not enough info to score pay or growth
Job Security
?
out of 5
Not enough data
Calculating job security score...
Total Score
72
out of 100
Average of individual scores
Skill Insights
Compare your current skills to what this opportunity needs—we'll show you what you already have and what could strengthen your application.
Job Description
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:
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
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 salesReport 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.
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. Looking to stay connected for potential future opportunities? Join our talent community and let us find opportunities that match your talent. Leave your contact details and CV/Resume and our Talent Acquisition Team will reach out to you if we find a ScottsMiracle-Gro or Hawthorne role that suits your skills. Don't see a job you're interested in? Sign in to your account or create an account by going to "Sign In". Then click "Job Alerts" to set up alerts for future jobs that may be of interest. To change the language, click on "English" at the top right corner of the screen and select your preferred language. If you are already signed in, click the cloud icon and go to Change Language. Para cambiar el idioma, haz clic en "English" en la esquina superior derecha de la pantalla y selecciona tu idioma preferido. Si ya habías iniciado sesión, has clic en el icono de la nube y ve a "Cambiar idioma". Si vous souhaitez changer la langue, merci de sélection-ner "English" en haut, à droite de l'écran et de choisir la langue dans laquelle vous souhaitez postuler. Si vous êtes déjà connecté à votre compte, cliquez sur le nuage en haut à droite de l'écran et sélectionnez "Change Language". Om de taal te wijzigen, klikt u op "Engels" rechtsboven op het scherm en selecteert u uw voorkeurstaal. 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. ScottsMiracle-Gro will never ask for payment or financial information at any stage in the recruitment process. Learn more here Are you currently a Scotts Miracle-Gro associate? Log into the company's network and apply through Workday via the Garden.Similar remote jobs
Fujifilm
Honolulu, HI
Posted2 days ago
Updated17 hours ago
Hixson Architecture, Engineering and Interiors
Cincinnati, OH
Posted2 days ago
Updated17 hours ago
Cardinal Health
Harrisburg, PA
Posted2 days ago
Updated17 hours ago
Similar jobs in Columbus, OH
HEART OF OHIO FAMILY HEALTH CENTERS
Columbus, OH
Posted2 days ago
Updated17 hours ago
Similar jobs in Ohio
Anywhere Real Estate
Cleveland, OH
Posted2 days ago
Updated17 hours ago
NOVO DISTRIBUTION LLC
Rocky River, OH
Posted2 days ago
Updated17 hours ago
Hixson Architecture, Engineering and Interiors
Cincinnati, OH
Posted2 days ago
Updated17 hours ago