Role Description 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. - Collect and build datasets from multiple sources. - Use statistics to understand the data. - Turn analytics into sustainable workflows that power decision-making, planning, and forecasting. - Help business users work more efficiently by providing better data and resolving data bottlenecks. - Automate the analytics needed to drive the company towards financial goals. 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. 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 and 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. Qualifications - Bachelor's or Master’s Degree in 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. Requirements - 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 of 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 Benefits - Exposure to a wide variety of cutting edge tools, such as Databricks, Sigma, and AWS. - 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. - Incentive eligible under corporate bonus programs.