Business Intelligence Analyst

Job Description:

Position Overview

The Business Intelligence Analyst sits within the Financial Planning & Analysis (FP&A) organization as a direct report to the VP of FP&A, with a strong dotted-line relationship to the Home Services Segment. This hybrid role bridges rigorous financial analysis and operational data intelligence—translating complex datasets into decisions that drive segment profitability, sales performance, and operational efficiency.

The analyst will serve as the primary quantitative partner for the Home Services General Managers, Home Services Sales Managers, and front-line sales teams, and will maintain a regular executive-level interface with the SVP of Home Services. While embedded day-to-day in the Home Services segment, this role is anchored in FP&A rigor—ensuring that all analysis, reporting, and recommendations meet the standards of board-level financial storytelling.

Organizational Alignment

Solid-Line Report

VP, Financial Planning & Analysis

Dotted-Line Partners

SVP, Home Services; GM, Home Services; Sales Manager, Home Services

Day-to-Day Collaboration

Home Services Sales Team, Operations Leadership, FP&A Team

Location

Dallas, TX (Home Services Segment – On-site or Hybrid)

Classification

Full-Time | Individual Contributor

Key Responsibilities

1. FP&A Reporting & Financial Analysis

• Own the monthly P&L reporting and variance analysis for the Home Services Segment, with commentary suitable for both operational managers and executive leadership.
• Support the VP of FP&A in preparing board-level and executive summaries, translating segment-level data into concise financial narratives.
• Maintain and enhance budget vs. actuals tracking across revenue, gross profit, and key cost drivers; identify and flag material variances proactively.
• Assist in the annual budgeting and quarterly reforecast cycles for the Home Services segment, partnering with the GM and Sales Manager on bottom-up build assumptions.
• Perform margin analysis across service lines (e.g., HVAC installation, maintenance agreements, repair tickets) to surface profitability mix insights and guide strategic decisions.

2. Operational & Sales Analytics

• Design and maintain real-time dashboards (Power BI / Tableau) tracking key Home Services KPIs, including:

• Average ticket size vs. budget (RNC and replacement revenue)
• Technician productivity: billable hours, callbacks, first-time fix rate
• Lead-to-close conversion rates by salesperson and market
• Customer acquisition cost (CAC) and cost-per-lead trends
• Maintenance agreement attach rates and renewal performance

• Analyze job-mix and pricing trends to identify drivers of ticket price compression or growth; distinguish between demand-side and pricing/mix issues.
• Develop forecasting models leveraging seasonal demand patterns, weather data, and historical booking rates to support staffing and inventory planning.
• Evaluate unsold estimate pipelines, WIP, and backlog metrics to provide forward-looking revenue visibility to the GM and Sales Manager.

3. Stakeholder Partnership & Executive Communication

• Act as the analytical bridge between the FP&A team and the Home Services operational and sales leadership, translating financial findings into actionable operational guidance.
• Prepare and present segment performance decks and briefing materials for the SVP of Home Services and senior leadership reviews.
• Partner with the Home Services Sales Manager and sales team on sales performance analytics—highlighting high-conversion opportunities, underperforming markets, and pricing optimization levers.
• Collaborate with the VP of FP&A on any cross-segment financial modeling, special projects, or board-level deliverables requiring Home Services data.
• Communicate complex analytical findings in plain language; tailor delivery for field operations leaders as well as C-suite audiences.

4. Data Integrity & Systems

• Serve as the data quality steward for Home Services reporting, ensuring accuracy and consistency of data flowing from ServiceTitan (or equivalent FSM software) into financial and BI systems.
• Partner with IT and operations teams to improve data pipelines, automate recurring reports, and eliminate manual data silos.
• Develop and maintain a single source of truth for segment KPIs, reconciling operational metrics with general ledger financials.
• Identify opportunities to leverage advanced analytics tools (SQL, Python, Power Query) to increase reporting efficiency and analytical depth.

Required Qualifications & Skills

Education

Bachelor’s degree in Finance, Accounting, Business, Statistics, Data Science, or a related field.

FP&A Experience

2–5 years in a financial analysis or business analytics role; FP&A background strongly preferred.

Data & BI Tools

Proficiency in Power BI or Tableau (required); SQL (required); Advanced Excel including Power Query, Pivot Tables, and dynamic modeling.

Financial Acumen

Demonstrated ability to read, interpret, and construct P&L statements; variance analysis; budgeting and forecasting.

Industry Knowledge

Familiarity with home services, field service operations, or a multi-unit service business is a plus.

Soft Skills

Executive communication, intellectual curiosity, attention to detail, ability to manage multiple stakeholder relationships simultaneously.

Success Metrics (KPIs for This Role)

The Data Analyst / Business Analyst will be evaluated on the following outcomes:

• Accuracy & timeliness of monthly segment P&L reporting and variance commentary delivered to the VP of FP&A and SVP of Home Services.
• Quality and adoption of Power BI dashboards by Home Services operational and sales leadership.
• Measurable reduction in manual reporting errors and time spent on ad-hoc data pulls through automation and process improvement.
• Depth and actionability of analytical insights contributing to Home Services revenue growth, margin improvement, or cost reduction.
• Feedback from both the VP of FP&A (solid-line) and the Home Services GM / SVP (dotted-line) on collaboration effectiveness and analytical value-add.

Ideal Candidate Profile

The right candidate is an analytically rigorous professional who thrives in a matrixed environment—comfortable operating at the speed of an operational business while maintaining the discipline of a finance organization. Specifically:

• The FP&A Bridge Builder: Equally comfortable in a monthly close review with the VP of FP&A and a Monday morning sales huddle with the Home Services field team. Doesn’t just produce reports—provides the “so what” behind the numbers.
• The Operational Translator: Can take raw ServiceTitan dispatch data and turn it into a clean, executive-ready narrative about why average ticket price missed budget by $X and what specifically needs to change.
• The Self-Starter: Proactively identifies data gaps, builds new reporting frameworks, and surfaces insights without waiting to be asked. Understands that in a dynamic home services business, the questions worth asking aren’t always on the agenda.
• The Trusted Analytical Partner: Earns credibility with both the FP&A team and segment leadership by being reliable, precise, and genuinely curious about the business—not just the data.

A Note on the Dual Reporting Structure

This role operates within a matrixed organizational design. The VP of FP&A retains full accountability for this role’s performance management, professional development, and analytical standards. The Home Services General Manager and SVP of Home Services direct the day-to-day analytical priorities of the segment. Success in this role requires strong relationship management, transparent communication across both reporting lines, and the ability to deliver for both without compromising quality or independence.

Airtron is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees.