Business Operations Analyst

Posted 44ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

Business Operations Analyst managing reporting and analytics for a top Shopify development partner. Collaborating with cross-functional teams to provide insights and improve processes with data.

Responsibilities:

  • Build and maintain operational reports in Excel/Google Sheets and dashboards in Looker
  • Create weekly and monthly reporting for: Delivery health (project status, capacity, utilization, resourcing needs) Financial health (revenue forecasting inputs, margin drivers, delivery efficiency) Pipeline and sales handoff insights (HubSpot → delivery)
  • Pull and reconcile data from: HubSpot Productive.io Spreadsheets and internal trackers
  • Improve reporting consistency by defining: Shared criteria Metric definitions Business health benchmarks
  • Build, maintain, and optimize custom dashboards and reports in Productive.io (Insights)
  • Perform deep-dive analysis on Utilization Rates, identifying trends across departments and individual team members
  • Track and report on Schedule Compliance, analyzing variance between scheduled hours vs. actual logged hours to improve forecasting accuracy
  • Generate forward-looking capacity reports to identify potential resourcing shortages months in advance, enabling proactive hiring and/or resource reallocation
  • Provide clear, data-backed recommendations to leadership on department efficiency, workload balancing, and capacity planning
  • Ensure data integrity across all platforms, performing regular audits of time logging, resourcing plans, and project setups to ensure reporting accuracy
  • Translate reporting into clear summaries leadership can interpret quickly
  • Highlight risks, anomalies, and trends proactively
  • Document reporting logic so metrics remain consistent and repeatable
  • Partner with Operations + Delivery leaders to ensure reports reflect real business needs
  • Identify areas where reporting can be automated or simplified
  • Improve data hygiene by flagging system gaps or inconsistent inputs
  • Build templates and repeatable reporting systems that reduce manual work

Requirements:

  • 3+ years experience in operations reporting, analytics coordination, or business operations
  • Strong Excel/Sheets skills (pivot tables, formulas, data cleaning; PowerQuery a plus)
  • Experience building dashboards (Looker strongly preferred)
  • Experience pulling data from tools like HubSpot, project management systems, and spreadsheets
  • Excellent English communication (written and spoken)
  • Strong time management and ability to work independently in a remote environment
  • High attention to detail and comfort working with imperfect data

Benefits:

  • Flexible working schedule
  • Competitive PTO policy with paid company time off at end of year
  • Remote-first culture
  • Home office stipend
  • Apple gear
  • Continued education and personal development opportunities