Operations Analyst

Integra Testing Services; Croxton; On-site; GBP 36,000 - 54,000; Full time

Job summary

Integra Testing Services is seeking an Operations Analyst to support business operations through data analysis, Excel-based reporting, process improvement, and documentation. The role involves analyzing data, maintaining Excel tools, and identifying efficiency opportunities to help teams execute processes consistently.

The candidate will work with cross-functional teams, validate data, develop dashboards, and translate insights into actionable recommendations to drive operational excellence.

Qualifications

• Bachelor's degree or equivalent experience in a related field.
• Strong proficiency in Microsoft Excel and handling large/complex datasets.
• Experience creating and maintaining Excel-based tools, reports, and trackers.
• Excellent attention to detail and ability to identify data inconsistencies.

Responsibilities

• Analyze operational data to identify trends and opportunities.
• Develop, maintain, and enhance Excel-based tools, dashboards, and templates.
• Provide day-to-day support for Excel tools and troubleshoot issues.
• Use advanced Excel functions, PivotTables, lookups, charts, for reporting.
• Prepare recurring and ad-hoc operational reports and translate data into insights.
• Document processes, workflows, SOPs, and related documentation.
• Review processes to improve efficiency, accuracy, and consistency.
• Collaborate with cross-functional teams to meet operational requirements.

Skills

Data analysis

Documentation

Cross-functional collaboration

Attention to detail

Excel reporting

Problem solving

Education

Bachelor's degree in Business/Operations/Analytics/Finance

Tools

Microsoft Excel

PivotTables

XLOOKUP/INDEX-MATCH

SUMIFS

Power Query/Power Pivot

Data visualization tools

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.