The Data Analyst is a hands-on role responsible for operating and improving all aspects of data management and reporting, including data warehouse management and demand forecasting. This individual plays a crucial role in the business by ensuring data is presented in a way to ensure the right products are available at the right time, minimizing stockouts and reducing excess inventory. Designing, building, managing and reporting on data from multiple data sources will all be key aspects of the position. In-depth knowledge of Python, APIs, Data Warehouse, data querying, demand planning, trends analysis, data visualization, AI, Advanced Excel and building adhoc reports from scratch will all be daily activities.
Responsibilities
- Data Ownership and Stewardship of the information used to make forecasting decisions.
- Key member of the Demand Planning Team providing recommendations and new ways to look at the data to make better decisions.
- Create and maintain an updated forecasting model, tools and spreadsheets that can be regularly updated based on additional data and triggers.
- Ability to create databases from scratch such as SQL or Postgress to assist in data gathering and reporting.
- Writing adhoc reports and gathering the data for those reports through tools such as Python, T-SQL and third-party data tools such as Render, Pipedream, etc.
- Recommend technical changes to the data warehouse to provide the needed data.
- Preparation of executive summaries for management team in the form of dashboard, data graphing, and PowerPoint presentations.
- Custom report writing in Excel and other reporting tools.
- Afterhours work and special projects are expected as part of this position.
- Other duties as assigned.
