Commercial Analytics Lead - Margin & Insights

Craneworks; Houston (TX); On-site; USD 70,000 - 95,000; Full time

Benefits offered by this job

Paid time off

Critical Illness Insurance

Hospital Indemnity Insurance

Job summary

CraneWorks in Houston, TX is seeking a Commercial Analyst to support equipment sales and rental profitability by delivering accurate financial analysis, cost visibility, and reliable reporting. You will serve as a liaison between Sales and Accounting, translating commercial activity into actionable insights to promote profitable growth.

Working with Sales, Accounting, and Finance, you will evaluate deal economics, manage margins and inventories, and prepare clear schedules and forecasts for

Qualifications

• Bachelor’s degree in Finance, Accounting, Business, Economics, Analytics, or related field preferred.
• 3-5+ years of experience in commercial analysis, financial analysis, sales operations, FP&A, pricing, or a similar analytical role.
• Strong financial and analytical skills with demonstrated ability to analyze revenue, gross profit, margins, inventory, and sales performance.
• Advanced Microsoft Excel skills.
• Experience with ERP, CRM, business intelligence, and financial reporting systems.
• Ability to work with large datasets and translate findings into practical business recommendations.
• Strong attention to detail with the ability to identify inconsistencies and challenge data when appropriate.
• Strong communication skills and ability to effectively partner with Sales, Finance, Operations, and senior leadership.
• Ability to manage multiple priorities and meet recurring reporting deadlines.
• Comfortable working independently and asking questions to understand the business behind the numbers.

Responsibilities

• Review deal economics and pricing, equipment costs, discounts, and credits.
• Maintain view of deal economics including commissions and expenses.
• Scrub transaction data for missing costs and reconcile margins.
• Prepare commission calculations and payroll documentation.
• Track inventory costs and carrying costs, advise stocking and pricing.
• Build and maintain Excel models and recurring reports using Power Query and pivots.
• Coordinate with Finance and Sales on discrepancies and forecasts.
• Explain accounting requirements to sales managers and communicate deal structures.
• Support month-end review with reconciliations and documentation.

Skills

Analytical skills

Excel skills

Communication skills

Multi-tasking

Independence

Attention to detail

Education

Bachelor’s degree in Finance, Accounting, Business, Economics, Analytics, or related field

3-5+ years in commercial/financial analysis or FP&A

Tools

Power BI

ERP/CRM/BI systems

Job description

CraneWorks in Houston, TX is seeking a Commercial Analyst to support equipment sales and rental profitability by delivering accurate financial analysis, cost visibility, and reliable reporting. You will serve as a liaison between Sales and Accounting, translating commercial activity into actionable insights to promote profitable growth.

Working with Sales, Accounting, and Finance, you will evaluate deal economics, manage margins and inventories, and prepare clear schedules and forecasts for