Operations Analyst

Integra-Testing-Services; Midlothian (VA); On-site; USD 65,000 - 85,000; Full time

Job summary

Integra-Testing-Services is seeking an Operations Analyst to support business operations through data analysis, Excel-based reporting, and process documentation. The role emphasizes building scalable Excel tools, validating data, and delivering actionable insights for cross-functional teams.

The successful candidate will combine strong Excel skills with a detail-oriented mindset, documenting SOPs and partnering with stakeholders to improve efficiency and reliability across operations.

Qualifications

• Bachelor’s degree or equivalent experience in business, operations, analytics, finance, or related field.
• Strong proficiency in Microsoft Excel; experience with large or complex datasets.
• Analytical mindset with ability to translate data into actionable insights.
• Experience creating and maintaining Excel-based tools, reports, and trackers.

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, formula, and reporting issues.
• Prepare recurring and ad-hoc operational reports and translate data into actionable insights.
• Document business processes, workflows, procedures, and SOPs.
• Review existing processes to improve efficiency, accuracy, and consistency.
• Partner with cross-functional teams to understand operational requirements and develop analytical solutions.
• Maintain accurate documentation for tools and processes.
• Perform data validation and quality checks for reporting accuracy.
• Support process improvement initiatives and other operational projects.

Skills

Data analysis

Reporting

Cross-functional collaboration

Attention to detail

Problem solving

Written & verbal communication

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.