Data Analyst

Support SOPREMA Group planning with reporting, forecasting, analytics, and dashboard development across sales and finance.

Responsibilities

• Deliver sales and expense reporting, budgets and forecasts, and financial planning and analysis for SOPREMA Group business plans
• Maintain and update business intelligence tools, databases, dashboards, systems, and reporting methods
• Assist with strategic plan development and regional/departmental capital and operating budget creation as needed
• Monitor and report on regional/department status versus objectives and budgets created during the planning process
• Build models to address business needs
• Script queries in data warehouses to support varied reporting requirements
• Assist in management and execution of data warehouse environments
• Develop, implement, and deploy additional machine learning models
• Develop, modify, and improve periodic sales reports for all levels of the organization, from executive management to sales representatives
• Develop, modify, and improve sales scorecards for each division within SOPREMA Group
• Create and execute executive reporting that highlights company-wide and region/department performance
• Provide variance reporting against operating, capital, and/or business unit forecasts and budgets
• Generate standard or custom reports summarizing business, financial, or economic data for executives, managers, clients, and other stakeholders
• Produce additional reports requested by sales, business development, marketing, finance, or executives as needed
• Identify and drive process improvements, including creation of standard and ad-hoc reports, tools, and Tableau and Excel dashboards
• Increase productivity by developing automated reporting and forecasting tools
• Maintain a strong financial analysis foundation for forecasts and models
• Partner with Performance Roof Systems and Chem Link to maintain/create analytics dashboards for personnel retention, freight, price discount, and rebates
• Assist with researching product issues and market opportunity findings
• Support periodic sales reporting across functional areas and collaborate with the senior financial analyst on sales and market-level data analysis, including planning and forecasting
• Define, analyze, and report on projects such as cost forecasting, raw materials, inventory, and capital
• Support additional data analysis, database management, reporting, accounting, strategy, and business development activities as needed
• Analyze sales and financial data across multiple regions and departments to identify improvement opportunities and work with other department managers to develop strategies
• Provide reports at executive level and down to individual unit level (e.g., sales person), as applicable

Requirements

• Bachelor’s degree in Data Science, Applied Mathematics, Computer Science, Corporate Finance, or Accounting
• High proficiency with Microsoft Excel
• Familiarity with data query/data management tools is helpful: Access, SQL, Business Objects
• Tableau Software, preferred (or similar data visualization tools: PowerBI, Qilk, Zoho Analytics, Looker, etc.)
• Experience writing queries and reports is preferred
• Coding experience preferred: Python, R, C++, VBA, SQL, etc.
• Data-analysis skills
• Problem-solving skills
• Excellent written and verbal communication skills
• Ability to prioritize and multi-task professionally and efficiently
• Ability to prepare executive-level recommendations and reports, including PowerPoint presentations

Technologies

• Microsoft Excel
• Access
• SQL
• Business Objects
• Tableau
• PowerBI
• Qilk
• Zoho Analytics
• Looker
• Python
• R
• C++
• VBA
• Tableau and Excel dashboards
• PowerPoint

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

Working Conditions and/or Physical Demands

• Regular hours during the week
• Prolonged periods sitting at a desk and working on a computer
• Ability to lift up to 15 pounds at times
• Travel may be required

Application Questions

• 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
• Wadsworth, OH (onsite)