Data Analyst

Job Title : Data Analyst Location: Chattanooga, TN – Day 1 Onsite Duration: Full Time Position
Job Description:

• The Data Analyst works across company functions to coordinate, maintain, and manage reporting, master data, and data structure in multiple data sets (sales, product/technical, for example).
• The Data Analyst will work across company systems (ERP, Excel, Access, SQL) and departments to ensure consistent and high-fidelity information.
• The position will work primarily with the Product, Finance, and Supply Chain teams.
• The role will require experience with data analytics and understand data analysis tools and databases with the ability to mine data for reporting purposes.

 
Data analysis and Reporting

• Creation, analysis, improvement, and dissemination of BI reports and/or dashboards for Management and Leadership.
• Assist management in the design of databases, models.
• Leveraging data and experience to identify opportunities and improvements, and present findings across multi-levels of the organization.
• Lead and Coordinate input, structuring, cleaning, improvement, harmonization, and updating of large datasets.
• 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.
• Perform data collection, spreadsheet creation, and data analysis.
• Assists Product Management, Sales, or other departments with analyses including lost sales, trending, gaps, etc.
• 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.
• Assist business planning team with various forecasting and analysis.
• Market research and reporting, competitive analysis.
• Work with Finance and Operations to ensure consistency/validity of reporting.

 
General

• Prepare and format data into presentations.
• Ensure information reported is consistent, accurate, and easy to understand for the intended audience such as Board of Directors, Senior Company leadership, Finance team members, and others.
• Work with ERP data tables such as Item Master, Pricing Master, etc.
• Work with Sr. Management and other business leaders to identify opportunities for improvement.
• Other Duties assigned by Management.  

 
Key skills and competencies of the position include, but are not limited to:

• Proficiency with Computers, Microsoft Office, Excel, Access/SQL.
• Strong knowledge of accounting/business principles, systems and practice; analysis, budgeting, forecasting.
• Effective written and verbal communication skills.
• Ability to perform root cause analysis.
• Ability to build analytical tools, templates, and financial models.

In-depth knowledge of market research, data analysis, in data mining/research – best practices.

• High degree of detail, analytical, organizational skill, and problem-solving ability; ability to work as self-starter.
• Ability to consolidate information into actionable insight.

 
Measurements of the role:

• Consistency and reliability of reporting.
• Business results from analysis (margins, eliminations, etc).
• Data hygiene (duplicates/maintenance).
• As assigned.

 
Qualifications, Education and Experience

• Bachelor’s degree in business management, Supply Chain, Finance, or Data Science (but not limited to) or equivalent work experience.
• 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).
• Competent in MS access and/or SQL (ability to write queries, reports from multiple tables).