Data Analyst
The Data Analyst is responsible for providing sales and expense reporting, budgets and forecasts, and financial planning and analysis of a wide array of data to support the initiatives and business plans of the SOPREMA Group (SOPREMA Inc. (SOPREMA, RESISTO and Private Label), Chem Link, Inc., Tropical Roof Products, Inc., Furbish and Performance Roof Systems, Inc.).
This position is primarily responsible for maintaining sales reporting, providing periodic reports to functional areas, and working with the senior financial analyst in analyzing sales and market-level data including planning & forecasting. In addition, this position is responsible for defining, analyzing, and reporting for a variety of projects including cost forecasting, raw materials, inventory and capital. Assists in other activities of data analysis, database management, reporting, accounting, strategy, business development, and other functional areas as needed. Any or all reports can be provided at both the highest level (executive) down to the individual unit (e.g. sales person) This position will be called upon to look at both sales and financial data across multiple regions and departments to identify opportunities for improvement and will work with other department managers to develop strategies for improvement.
Essential Functions and Responsibilities:
1. Financial Analysis
a. Maintain and update business intelligence tools, databases, dashboards, systems, or methods.
b. Assist in creating strategic plans and regional/departmental capital and operating budgets as necessary. Monitor and report on the status of regional/department, objectives and budgets that were developed during the planning process.
c. Assist in developing models to meet various business needs.
2. Data Analysis
a. Script queries in data warehouses to meet various business needs.
b. Assist in management and execution of data warehouse environments.
c. Develop, implement and deploy additional machine learning models.
3. Results Reporting
a. Develop, modify, and improve periodic sales reports to all levels of the organization from executive management to sales representatives.
b. Develop, modify, and improve sales scorecards for each division of SOPREMA Group.
c. Create and execute reports for senior/executive management highlighting company-wide as well as region/department performance.
d. Provide variance reporting against operating, capital, and/or business unit forecasts/budgets.
e. Generate standard or custom reports summarizing business, financial, or economic data for review by executives, managers, clients, and other stakeholders.
f. Other reports requested by sales, business development, marketing, finance, or executives as needed.
g. Identify and drive process improvements, including the creation of standard and ad-hoc reports, tools, and Tableau and Excel dashboards.
h. Increase productivity by developing automated reporting/forecasting tools.
i. Maintain a strong financial analysis foundation creating forecasts and models.
j. Work with Performance Roof Systems and Chem Link to maintain/create analytics dashboards including: personnel retention, freight, price discount, and rebates.
k. Assist with researching product issues and market opportunity findings.
Minimum Qualifications:
1. Bachelor’s degree in Data Science, Applied Mathematics, Computer Science, Corporate Finance, or Accounting
2. High Proficiency with Microsoft Excel
3. Familiarity with data query/data management tools is helpful (Access, SQL, Business Objects)
4. Tableau Software, preferred (or similar data visualization software, PowerBI, Qilk, Zoho Analytics, Looker, etc.)
5. Experience writing queries and reports (preferred)
6. Coding experience preferred: Python, R, C++, VBA, SQL, etc.
7. Data-analysis
8. Problem-solving
9. Excellent written and verbal communication skills
10. Ability to prioritize and multi-task professionally and efficiently
11. Ability to prepare executive-level recommendations and reports, including PowerPoint presentations.
Working Conditions and/or Physical Demands:
1. The Data Analyst works regular hours during the week.
2. Prolonged periods sitting at a desk and working on a computer.
3. Must be able to lift up to 15 pounds at times.
4. Travel may be required for this position.
Benefits:
- 401(k) matching
- Dental insurance
- Disability insurance
- Health insurance
- Life insurance
- Paid holidays
- Paid time off
- Parental leave
- Professional development assistance
- Retirement plan
- Vision insurance
Application Question(s):
- Do you have experience creating dashboards for financial reporting?
- Have you identified and mitigated a financial risk in a past role?
- What type of business intelligence software experience do you have?
- What is your desired salary for this role?
Work Location: In person
