Operations Analyst

Integra Testing; Midlothian (IL); On-site; USD 60,000 - 85,000; Full time

Job summary

Integra Testing in Illinois seeks an Operations Analyst to support business operations through data analysis, Excel-based reporting, process improvement, and documentation. You will analyze operational data, maintain and support Excel tools, identify efficiency opportunities, and create clear documentation to help teams execute processes consistently.

The role emphasizes deep Excel use, cross-functional collaboration, and meticulous process documentation to drive reliable operational reporting

Qualifications

• Bachelor’s degree or equivalent experience in a related field.
• Strong proficiency in Microsoft Excel and experience with large/complex datasets.
• Strong analytical and problem‑solving skills with the ability to interpret data and communicate findings clearly.
• Experience creating and maintaining Excel-based tools, reports, and trackers.
• Strong process documentation and organizational skills.
• Excellent attention to detail and ability to identify data inconsistencies or process gaps.
• Ability to manage multiple priorities and work effectively with cross‑functional teams.
• Strong written and verbal communication skills.

Responsibilities

• Analyze operational data using Excel to identify trends and opportunities for improvement.
• Develop, maintain, and enhance Excel-based tools, reports, dashboards, trackers, and templates.
• Provide day-to-day support for Excel tools and troubleshoot data and reporting issues.
• Use advanced Excel functions and PivotTables to support business needs.
• Prepare recurring and ad-hoc operational reports and translate data into actionable insights.
• Document business processes, workflows, procedures, and SOPs.
• Review processes and identify opportunities to improve efficiency and accuracy.
• Collaborate with cross-functional teams to understand requirements and develop analytical solutions.
• Maintain accurate documentation for tools and processes.
• Perform data validation and quality checks to ensure reporting reliability.
• Support process improvement initiatives and other operational projects.

Skills

MS Excel

Data analysis

Communication

Problem solving

Education

Bachelor’s degree in Business/Operations/Analytics/Finance or related field

Tools

Excel

Job description

Position Summary

We are seeking a detail-oriented Operations Analyst to support business operations through data analysis, Excel-based reporting, process improvement, and documentation. This role will analyze operational data, maintain and support Excel tools, identify opportunities for process efficiency, and create clear documentation to help teams execute processes consistently.

Key Responsibilities

• Analyze operational data using Excel to identify trends, patterns, issues, and opportunities for improvement.


• Develop, maintain, and enhance Excel-based tools, reports, dashboards, trackers, and templates.


• Provide day-to-day support for Excel tools and troubleshoot data, formula, and reporting issues.


• Use advanced Excel functions, formulas, PivotTables, lookups, charts, and other analytical capabilities to support business needs.


• Prepare recurring and ad-hoc operational reports and translate data into actionable insights.


• Document business processes, workflows, procedures, and standard operating procedures (SOPs).


• Review existing processes and identify opportunities to improve efficiency, accuracy, and consistency.


• Partner with cross-functional teams to understand operational requirements and develop practical analytical solutions.


• Maintain accurate and organized documentation for operational tools and processes.


• Perform data validation and quality checks to ensure accuracy and reliability of reporting.


• Support process improvement initiatives and other operational projects as needed.

Required Qualifications

• Bachelor’s degree in Business, Operations, Analytics, Finance, or a related field, or equivalent experience.


• Strong proficiency in Microsoft Excel and experience working with large or complex datasets.


• Strong analytical and problem‑solving skills with the ability to interpret data and communicate findings clearly.


• Experience creating and maintaining Excel-based tools, reports, and trackers.


• Strong process documentation and organizational skills.


• Excellent attention to detail and ability to identify data inconsistencies or process gaps.


• Ability to manage multiple priorities and work effectively with cross‑functional teams.


• Strong written and verbal communication skills.

Preferred Qualifications

• Experience with advanced Excel functions such as XLOOKUP, INDEX/MATCH, SUMIFS, PivotTables, and conditional logic.


• Experience with Excel Power Query, Power Pivot, or data visualization tools.


• Experience documenting SOPs, workflows, and business processes.


• Familiarity with process improvement methodologies.


• Experience supporting operational reporting or business intelligence initiatives.

Success in This Role

The successful candidate will combine strong Excel and data analysis skills with a process‑oriented mindset. They will be comfortable working with data, troubleshooting Excel tools, documenting how processes work, and partnering with stakeholders to make operations more efficient and reliable.