Business Operations Analyst
Posted 44ds ago
Employment Information
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



















