Job description

We are in search of a Data Analyst to become a part of our team in the Service industry, based in Chattanooga, Tennessee. In this role, you will be tasked with assisting internal teams with various different internal data, helping with forecasting, and ad hoc reporting. Advanced Excel proficiency is a requirement for this role. Ideal candidate will have hands-on experience working with and creating complex data and reporting spreadsheets and dashboards. This role offers a long-term contract employment opportunity.Specific Excel experience needed:• Utilizing PowerQuery for data import from various spreadsheets/systems.• Implementing Dynamic Array Functions.• Utilizing functions for analysis, including index, match, indirect functions, etc.• Utilizing logic-based arithmetic functions, and logical functions.• Calculating weighted averages.• Manipulating Date functions to organize daily data into monthly, and monthly into yearly formats.• Ensuring data presentations are well-structured.• Employing Data Mining Techniques and Data Visualization for comprehensive analysis.• Using Microsoft tools, Analytics, and Business Intelligence for efficient data processing.• Creating Dashboards using Microsoft Power BI and Microsoft Excel.

Requirements