Operations Reporting Analyst

Location: Fully Remote (United States)
Reports To: Data Manager Department: Operations Analytics & Reporting (OAR)

The Operations Reporting Analyst is a founding member of the Operations Analytics & Reporting (OAR) team, a new function built to be the single source of truth for operations performance across all American Restoration brands. You’ll work directly alongside the Data Manager to deliver the reporting and insights that GMs, VPs, and the executive leadership team rely on to run the business.

This is an ideal role for someone early in their analytics career who is eager to learn, loves working with data, and wants to grow into a well-rounded BI professional. You’ll start with ad hoc reporting and QA, then progressively take on SQL development and dashboard creation in Domo and Power BI as you develop. You’ll have a clear growth path and direct mentorship from experienced analytics leaders.

• Ad Hoc Reporting & Operational Support
  • Respond to ad hoc data requests from operations and leadership teams
  • Deliver timely, accurate analyses that help support decision-making
  • Validate results before distribution and reconcile against source data when needed
  • Write SQL queries to build datasets for Domo and/or Power BI reports
  • Develop and maintain dashboards within Domo and/or Power BI
  • Improve clarity, usability, and consistency of visual reporting
• Data Preparation & Quality
  • Clean and structure raw data for reporting use
  • Identify inconsistencies or data integrity issues
  • Document query logic and reporting assumptions
  • Communicate clearly with business stakeholders to define reporting requirements
  • Present findings in a concise and understandable way
  • Work closely with the Data Manager to follow established modeling and reporting standards

• 1–4 years of experience in data analytics, reporting, or business intelligence (internships and academic projects count)
• Comfortable in Excel (pivot tables, XLOOKUP/INDEX-MATCH, basic formulas)
• Working knowledge of SQL, including
  • Multi-table joins
  • Aggregations and GROUP BY
  • Basic understanding of query logic and data relationships
• Exposure to at least one BI tool (Domo, Power BI, Tableau, or similar)
• Strong written and verbal communication skills
• Ability to manage multiple requests in a fast-paced environment

• Experience with Domo & Power BI
• Exposure to window functions in SQL
• Experience with Power Query (M)
• Python for data analysis or automation
• Power Automate
• Industry experience in service-based businesses
• Foundational understanding of data modeling concepts (fact vs. dimension tables, data grain)

Within the first 90 days, you will:

• Own the ad hoc reporting queue and deliver requests with minimal oversight
• Write and maintain SQL queries for recurring data pulls
• Understand the OAR data model and begin contributing to dashboard development
• Become the go-to person for data QA and cleansing
• Build trust with operations stakeholders through accuracy, responsiveness, and clear communication

• Ground-floor opportunity:
  You’re joining a brand-new team. You’ll help shape how reporting works across the entire company.
• Real impact:
  Your work goes directly to GMs, regional leaders, and the executive team.
• Modern tech stack:
  You’ll work with SQL, Domo, Power BI, cloud data warehouses, and an industry leading ERP system.
• Fully remote with a small, collaborative team that values clarity over complexity.

Competitive Pay

Company Paid Basic Life insurance and additional Optional Life Insurance