The business problem is to ensure the right products are available at the right time, minimizing stockouts and reducing excess inventory by operating and improving all aspects of data management and reporting, including data warehouse management and demand forecasting.
Requirements
- 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.
- Must be an expert with Python, APIs, Excel and other Data Warehouse BI/Reporting Tools.
- Strong understanding of Data Warehouse views, cubes, etc. (Snowflake experience a plus)
- Knowledge of AI tooling and how to utilize AI platforms to enhance data.
Responsibilities
- Operating and improving all aspects of data management and reporting, including data warehouse management and demand forecasting.
- Designing, building, managing and reporting on data from multiple data sources.
- 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.
Other
- 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.
- Afterhours work and special projects are expected as part of this position.
- Other duties as assigned.
- Must have 3+ years of hands-on data experience in the Hospitality, Retail or F&B space.
- Must be capable of working in fast-paced, self-directed, ever-changing environment with the ability to meet strict deadlines.
