Senior Business Intelligence Analyst

Senior Business Intelligence Analyst - Rose Paving LLC
Information Technology & Business Systems

Rose Paving is seeking a Senior Business Intelligence Analyst to lead the development, management, and evolution of the company's business intelligence, analytics, and reporting environment. This individual will be responsible for transforming enterprise data into actionable insights through Power BI, Snowflake, and data warehousing technologies while supporting strategic decision‑making across Finance, Operations, Sales, and Executive Leadership.

The ideal candidate possesses a strong analytical mindset, understands financial and operational reporting, and can translate complex business requirements into meaningful dashboards, reports, data models, and executive insights. Construction, contracting, field services, or manufacturing industry experience is strongly preferred.

This role also serves as the primary business owner for the Experlogix CPQ platform, the system Rose Paving uses to configure, price, and quote every customer bid. The successful candidate will own the pricing structures, cost models, units of measure, business rules, and calculation logic that directly affect quoting accuracy, margin, and profitability across multiple operating locations. Because CPQ sits where construction, finance, and technology meet, this position calls for someone who blends construction or field services knowledge with financial and systems depth.

As Rose Paving expands its use of Artificial Intelligence, this individual will also help identify and implement AI‑driven analytics capabilities that improve reporting, forecasting, trend identification, and decision‑making.

• Design, develop, and maintain enterprise Power BI dashboards, reports, scorecards, and KPI metrics.
• Partner with executive leadership to identify key performance indicators (KPIs) and reporting requirements.
• Develop reporting for revenue, gross margin, backlog, job costing, production, equipment utilization, sales performance, and operational efficiency.
• Create executive dashboards and self‑service reporting solutions.
• Ensure reporting accuracy, consistency, and usability across the organization.
• Deliver meaningful business insights and recommendations based on data analysis and trends.

• Serve as the primary business owner and administrator for Experlogix CPQ, the configuration and pricing engine behind every bid and proposal Rose Paving delivers to customers.
• Build, maintain, and enhance the logic‑based configuration rules, pricing formulas, cost models, and rate tables that drive accurate, consistent quotes.
• Manage units of measure, location‑specific and territory‑based pricing, and multi‑office configuration across Rose Paving and its acquired entities.
• Maintain guided selling, quote approval workflows, and discount governance that protect margin and enforce pricing consistency.
• Manage quote and proposal document output, templates, and related automation.
• Support and maintain the integration between Experlogix CPQ and Dynamics 365 Sales (XRM) and Business Central.
• Partner with Sales, Estimating, and Finance to improve quoting accuracy and speed, and troubleshoot and optimize CPQ functionality as the business evolves.

• Manage and support the company's Power BI, Snowflake, and Fivetran data warehouse environment.
• Develop and maintain data models, reporting structures, and data relationships.
• Collaborate with IT and business stakeholders to ensure data quality and integrity.
• Support data governance initiatives and reporting standards.
• Continuously improve data accessibility, reporting performance, and analytics capabilities.

• Evaluate and implement AI‑driven analytics capabilities within Power BI, Snowflake, and related platforms.
• Leverage AI tools to improve forecasting, trend analysis, anomaly detection, and executive reporting.
• Identify opportunities to automate reporting and enhance decision‑making through artificial intelligence and machine learning capabilities.
• Stay current on…