Operations Reporting Analyst

American Restoration Operations LLC•Farmers Branch, TX

4h•Remote

About The Position

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.

Requirements

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

Nice To Haves

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)

Responsibilities

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
Clean and structure raw data for reporting use
Identify inconsistencies or data integrity issues
Support ongoing data standardization efforts
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