Excel Analyst Jobs in Indiana (NOW HIRING)

Summary

The Operations Data Analyst plays a critical role in driving operational efficiency and strategic decision-making through data analysis. This role is responsible for collecting, analyzing, and interpreting data related to business operations, identifying trends, and providing actionable insights to stakeholders across departments.

Essential Duties & Responsibilities
To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodation may be made to enable individuals with disabilities to perform the essential functions.

• Analyze operational data to identify trends, inefficiencies, and opportunities for improvement.

• Utilize data visualization tools (e.g., Tableau, Power BI) to effectively communicate complex data in a simple, repeatable, and understandable manner. Translate complex data sets into clear, actionable insights for non-technical stakeholders.

• Support forecasting, budgeting, and strategic planning efforts with data models and scenario analysis.

• Ensure data integrity and consistency across systems and reports.

• Compile Operations Demand Forecast for Supply Chain, Distribution Operations, and Manufacturing Operations.

• Develop and maintain dashboards, reports, and KPIs to monitor performance across departments.

• Automate recurring reports and streamline data workflows using tools like SQL, Excel, Power BI, or Tableau.

• Assist in the implementation and optimization of ERP and other enterprise systems from a data perspective.

• Perform ad-hoc analysis to answer specific business questions.

• Lead or participate in data-driven projects, ensuring timely and accurate delivery of insights.

• Other duties as assigned.

Education and/or Experience 

• Bachelor’s degree with a concentration in Business, Mathematics, Statistics, Data Science, or a related field 

• 2-5 years of experience in data analysis, preferably in operations or business intelligence.  

• Proficiency in data visualization tools (Power BI, Tableau) and data querying languages (e.g. SQL) 

• Strong Excel skills, including pivot tables, VLOOKUP, and advanced formulas 

• Experience with Salesforce (or other CRM), SQL, Tableau, Traverse (or other ERP System) a plus 

• Excellent problem—solving skills and attention to detail. 

• Strong communication skills with the ability to present findings to diverse audiences.  

• ** This role requires you to already live within daily commuting distance of Indianapolis. We do not offer relocation or remote work for this position. **

Other Skills 

• Language skills:  Ability to read, analyze, and interpret the most complex documents. Ability to respond effectively to the most sensitive inquiries or complaints.  Ability to make effective and persuasive speeches and presentations on controversial or complex topics to top management, public group, and/or boards of directors. 

• Mathematical skills:  Ability to work with mathematical concepts. 

• Reasoning: Ability to define problems, collect data, establish facts and draw valid conclusions.  Ability to interpret an extensive variety of information. 

• Cognitive Skills: Attention to detail, Analytical/strategic Thinking, Problem solving, Creativity 

• Computer skills: Knowledge of Microsoft Office Suite, strong Excel skills 

Competencies 

• Communication: Effectively communicate to internal and external business partners by sharing expertise to encourage accomplishment of shared business goals.   

• Teamwork and Collaboration: Actively support and collaborate with peers and team members to contribute to overall company success.  

• Knowledge: Display knowledge of department, applicable products, services and business objectives. Demonstrate a continuous learning mindset through continued professional and personal development.  

• Accountability: Follow through with tasks and responsibilities in an appropriate and timely manner.  

• Work Quality: Produces results, meets goals, and provides services that meets or exceeds EHOB’s standards.  

• Adaptability: Readily and effectively adapts way of working, thinking and acting in response to changing workplace conditions, targets or goals.  

• Attention to Detail: Ability to focus on the finer aspects of a task or problem, ensuring accuracy, precision, and thoroughness. 

• Strategic Thinking: Demonstrate ability to understand a situation or obstacle from all perspectives. 

• EHOB Ambassador: Reflect EHOB’s mission, vision and values.  

Work Environment 

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this job, the employee is occasionally exposed to moving mechanical parts; risk of electrical shock; risk of radiation and vibration. The noise level in the work environment is usually moderate.  

EHOB does not discriminate in employment on the basis of race, color, religion, sex (including pregnancy and gender identity), national origin, sexual orientation, marital status, disability, genetic information, age, membership in an employee organization, retaliation, parental status or military service.