Operations Reporting Analyst at American Restoration Operations LLC – Farmers Branch, Texas

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

Position Overview

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.

Key Responsibilities

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

Domo / Power BI Reporting & SQL Development

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

Support ongoing data standardization efforts

Document query logic and reporting assumptions

Collaboration & Communication

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

Required Qualifications

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 Have

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)

What Success Looks Like in This Role

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

Why Join OAR

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.

Benefits

Competitive Pay

Comprehensive Medical/Dental/Vision insurance

Company Paid Basic Life insurance and additional Optional Life Insurance

Long and Short term Disability

Hospital and other auxiliary benefits

Paid Time Off

7 Paid Holidays

Continued Education in relevant fields

Career Growth Opportunities