RiseMe
LoginSign Up
Harvard Integrations logo
Harvard Integrations Verified
IT Services, Systems Integration, Security Solutions

Operations Data Analyst

Tea, South Dakota, United StatesOnsiteFull TimePosted 2 months agoVisa sponsorship available

Is this role right for you?

Upload your resume and get a skill-by-skill breakdown — see exactly where you match, where you're close, and what to highlight. Not a mystery percentage.

Get a tailored resume highlighting what this role needs.

Role summary

The Operations Data Analyst will support operational decision-making by performing data discovery, creating visualizations, maintaining dashboards, and automating processes. This role involves analyzing data from ERP, SQL, and Excel sources to identify trends and anomalies, and communicating findings through clear, visual reports. Key responsibilities include maintaining KPI reporting systems, developing new reporting tools, and leveraging advanced Excel/VBA for workflow automation. The analyst will also write SQL queries for data analysis and support business process improvement initiatives, with a need for strong analytical skills and the ability to work independently.

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.
Ready to apply?
You'll be redirected to Harvard Integrations's application page.

Similar roles