What are the responsibilities and job description for the Data Analyst position at SIEGEL GROUP NEVADA INC?
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.
- Must have 3 years of hands-on data experience in the Hospitality, Retail or F&B space.
- 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.
- Must be capable of working in fast-paced, self-directed, ever-changing environment with the ability to meet strict deadlines.