PGW Auto Glass is seeking a highly motivated and analytical Data Scientist to join our Pricing & Analytics team. This role will focus on transforming large-scale enterprise data into actionable business insights that improve pricing strategy, sales performance, inventory optimization, customer experience, and operational efficiency across our branch and distribution center network throughout the United States and Canada.
The ideal candidate will possess strong analytical and visualization capabilities, practical experience with Microsoft Fabric and Azure data services, and exposure to machine learning and AI-driven analytics. This position will work closely with Pricing, Supply Chain, Operations, IT, and Executive Leadership teams to develop modern analytics solutions and self-service reporting platforms.
This role is ideal for someone who enjoys combining data science, business intelligence, and modern cloud analytics technologies to solve real-world business problems.
Key Responsibilities & Duties:
Data Analytics & Visualization
o Microsoft Power BI
o Fabric Direct Lake semantic models
o Power BI Copilot capabilities
o Paginated reports and executive scorecards
o Pricing analytics
o POS sales trends
o Inventory optimization
o Supply chain performance
o Customer purchasing behavior
o Branch and DC operational analytics
Data Science & AI/ML
o Dynamic pricing
o Sales forecasting
o Demand planning
o Customer segmentation
o Lost sales analysis
o Inventory replenishment
o Python
o Spark notebooks
o Fabric Data Science workloads
o Azure AI / OpenAI capabilities
o Copilot-enabled analytics
o Conversational BI
o Sentiment analysis
o Speech-to-text analytics
o Agentic AI use cases
Microsoft Fabric & Cloud Analytics
o OneLake
o Lakehouse
o Data Warehouse
o Data Factory
o Dataflows Gen2
o Eventstream / Real-Time Intelligence
o Spark Notebooks
o Semantic Models
o Power BI
o Oracle
o SQL Server
o APIs
o SaaS platforms
o XML/JSON log files
o Event streaming platforms
Business Collaboration
Qualifications & Skills:
Required Qualifications
o Data Science
o Computer Science
o Information Systems
o Engineering
o Statistics
o Mathematics
o or related field
o Data Analytics
o Business Intelligence
o Data Science
o or related analytics roles
o Power BI
o SQL
o Data modeling
o Dashboard development
Preferred Qualifications
Experience with Microsoft Fabric services including:
o Lakehouse
o Spark
o Data Factory
o Real-Time Analytics
o Semantic Models
Knowledge of:
o Pricing analytics
o Supply chain analytics
o Inventory optimization
o Wholesale/distribution analytics
Experience with:
o REST APIs
o Event streaming
o Kafka/Event Hub
o XML/JSON data processing
Microsoft certifications in:
o Azure
o Power BI
o Fabric
o Data Engineering are a plus.
Technical Skills
Required
Preferred
Soft Skills
Work Environment & Physical Requirements (if applicable):
PGW Auto Glass, LLC is working in a hybrid environment. Team members are expected to commute to our Cranberry Township, PA, Headquarters three days per week. Visa sponsorship is not available for this role.
Why Join PGW Auto Glass?
Benefits and Compensation:
PGW Auto Glass, a highly reputable supplier of auto glass and shop accessories, operates over 130 distribution branches across the United States and Canada. Our vast distribution network enables us to offer small orders and same-day and overnight deliveries of auto glass. This commitment to customer satisfaction has earned us the trust of over 27,000 customers. We are excited to introduce our newest addition, www.EVERYTHINGAUTOGLASS.com (formerly AutoGlassCRM), to give installers a complete auto-glass business platform.
