Operations Reporting Analyst
American Restoration Operations LLC
Farmers Branch, TX 75244Remote$60,000 - $80,000 a year
Job Description
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
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