Operations Data Analyst

Harvard IntegrationsTea, SD

Apply with Sonara

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.¹

Reclaim your time by letting our AI handle the grunt work of job searching.

We continuously scan millions of openings to find your top matches.

Overview

Schedule

Full-time

Career level

Senior-level

Job Description

Apply

Description

The Data Analyst supports operational decision making through data discovery, visualization, dashboard maintenance, and automation. This role focuses on identifying trends and anomalies across ERP, SQL, and Excel data sources; creating intuitive visual representations of findings; and maintaining the company's KPI reporting systems. The ideal candidate is proficient in Excel/VBA, SQL, and business process improvement, with the ability to work independently and develop clean, accurate, and reliable analytics.-making through data discovery, visualization, dashboard maintenance, and automation.

Extract, clean, and analyze data from ERP systems, SQL databases, and Excel based sources.-based sources.
Identify trends, anomalies, and actionable insights to support operational and strategic decisions.
Produce clear, visually compelling graphics and reports that effectively communicate data patterns.
Maintain and enhance existing dashboard systems, ensuring data accuracy and consistent updates.
Develop new reporting tools, dashboards, and lookup utilities used across the organization.
Utilize advanced Excel and VBA to automate manual workflows and improve reporting efficiency.
Write SQL queries to gather, join, and optimize datasets for analysis.
Support and evolve business process improvement (BPI) initiatives through data-driven insights.
Develop and support Power BI tools to deliver actionable analytics and enhance business process improvement initiatives.
Update and manage HTML-based dashboard pages where needed.
Document processes, maintain version control, and provide troubleshooting support for users.

Requirements

Required

Advanced Excel capability, including formulas, Power Query, Pivot Tables, and VBA automation.
Average to advanced SQL experience (querying, joins, data preparation, optimization).
Strong analytical ability to detect patterns, outliers, and process inefficiencies.
Experience creating engaging data visualizations and trend summaries.
Working knowledge of HTML for dashboard updates and presentation.
Understanding of business process improvement methodologies.
Ability to manage multiple priorities, work independently, and meet deadlines.
Strong communication skills, including documentation and cross-functional collaboration

Preferred

Additional scripting experience (VBA, HTML/CSS, Python, JavaScript).
Experience with APIs and data integration tools.
Familiarity with Power Automate or similar workflow automation tools.

Automate your job search with Sonara.

Submit 10x as many applications with less effort than one manual application.

Apply with Sonara Apply manually

FAQs About Operations Data Analyst Jobs at Harvard Integrations

What is the work location for this position at Harvard Integrations?

This job at Harvard Integrations is located in Tea, SD, according to the details provided by the employer. Some roles may also include multiple work locations depending on the requirement.

What pay range can candidates expect for this role at Harvard Integrations?

Employer has not shared pay details for this role.

What employment applies to this position at Harvard Integrations?

Harvard Integrations lists this role as a Full-time position.

What experience level is required for this role at Harvard Integrations?

Harvard Integrations is looking for a candidate with "Senior-level" experience level.

What is the process to apply for this position at Harvard Integrations?

You can apply for this role at Harvard Integrations either through Sonara's automated application system, which helps you submit applications 10X faster with minimal effort, or by applying manually using the direct link on the job page.