Business Analyst II

Reports to: Chief Operating Officer

Cooperates with: Operations, Engineering, Field Service, Proj. Management, Finance

Primary Responsibility: We are seeking an experienced and detail-oriented Business Analyst to support and evolve our data, reporting, and analytics platforms as part of the Operations team. This role is critical in enabling performance improvement and operational effectiveness across departments by enhancing system functionality, maintaining system integrity, and driving configuration and integration initiatives. The ideal candidate combines technical aptitude, platform experience, and strong communication skills to bridge business needs with system capabilities.

This position supports daily operations, larger project initiatives, and long-term scalability of tools that are vital to the Operations function.

• Partner with Operations leadership and frontline teams to understand business needs, operational challenges, and improvement opportunities.
• Serve as the primary analytics and reporting support for the Operations organization.
• Collect, validate, and maintain operational data from multiple sources including Salesforce, Syspro ERP, in-house applications, Excel files, and SQL databases
  .
• Create one-off analysis and ad-hoc reports to support operational decision-making, customer needs, audits, and leadership requests.
• Build and maintain Power BI dashboards
  , including data models, relationships, measures, and refresh schedules.
• Write, optimize, and maintain SQL queries to extract and transform data for reporting, analysis, and process monitoring.
• Develop Excel-based tools and templates (Power Query, Pivot Tables, formulas/macros as needed) to support operational workflows.
• Ensure data accuracy through reconciliation, error checks, and ongoing data integrity monitoring.
• Translate raw operational data into actionable insights, trends, and recommendations to improve performance.
• Define and document key metrics and business rules to ensure consistent KPI reporting across the organization.
• Identify inefficiencies, bottlenecks, and root causes using structured problem-solving and analytical methods.
• Lead and support continuous improvement initiatives
  , including process refinement, standardization, and operational best practices.
• Facilitate workshops and working sessions with stakeholders to map current-state processes and design future-state improvements.
• Support implementation of process changes including communication, training support, adoption tracking, and post-implementation measurement.
• Act as a liaison between Operations and IT/Systems teams to support enhancements, fixes, and new functionality.
• Gather requirements, create user stories/specifications, and support testing (UAT) for system enhancements and new reporting tools.
• Monitor system usage and data flow across platforms; troubleshoot reporting and data issues and coordinate resolution.
• Assist in governance of operational data and reporting, including access controls, version control, and documentation.
• Present findings and recommendations to leadership in clear, concise formats (dashboards, executive summaries, slides, etc.).
• Manage multiple priorities simultaneously while meeting deadlines and maintaining high-quality deliverables.

• 5+ years of experience in a Business Analyst, Systems Analyst, or Data Analyst role.
• Hands-on experience with SQL and Power
  
  BI in a professional environment.
• Familiarity with ERP systems (e.g., Syspro, Net Suite, SAP, etc.) and how they integrate with other business systems.
• Understanding of APIs and system integration concepts.
• Ability to manage competing priorities, communicate effectively across departments, and document technical work clearly.
• Bachelor's degree in MIS, Business, Software Engineering, Computer Science, or related field OR and equivalent combination of education and relevant experience.
• Strong problem-solving and analytical skills with a high attention to detail.
• Excellent verbal and written communication and an ability to translate technical details for non-technical users.
• Self-starter attitude with the ability to work both independently and collaboratively.