The company is looking to solve the problem of coordinating, maintaining, and managing reporting, master data, and data structure in multiple data sets across various functions, including sales, product/technical, and finance.
Requirements
- Proficiency with Computers, Microsoft Office, Excel, Access/SQL.
- Strong knowledge of accounting/business principles, systems and practice; analysis, budgeting, forecasting.
- Ability to build analytical tools, templates, and financial models.
- High degree of detail, analytical, organizational skill, and problem-solving ability; ability to work as self-starter.
- High competency in Excel inclusive of more advanced functions such as pivot, slicers, macros.
- Literate in database design and functions (Field definitions, unique IDs, relationships) and functions/applications (Access, SQL, Python).
- Competent in MS access, SQL and/or Python (ability to write queries, reports from multiple tables)
Responsibilities
- Creation, analysis, improvement, and dissemination of BI reports and/or dashboards for Management and Leadership.
- Assist management in the design of databases and models.
- Leveraging data to identify opportunities and improvements, and present findings across multi-levels of the organization.
- Prepare and provide thoughtful analysis on variances for reports including but not limited to: Revenue, gross margin, expenses, and profit for the areas supported.
- Initiate and Institute KPIs to measure the effectiveness of the company’s business decisions and risks.
- Assist finance and business teams in the annual budget and quarterly financial forecast process
- Creation of graphs, charts, spreadsheets, and other methods to visualize data.
Other
- Progress towards a Bachelor’s degree in Business Management, Supply Chain, Finance, or Data Science (but not limited to) or equivalent work experience.
- Ability to work hours office hours as assigned by management. Typical office hours are Monday-Friday 8am-5pm; overtime as required/approved by management.
- Effective written and verbal communication skills.
- Ability to consolidate information into actionable insight.
- Ability to work in a professional office and warehouse/shop environment
