PGW Auto Glass (PGWAG) is seeking a highly motivated Data Engineer to help modernize and scale our enterprise analytics platform on Microsoft Azure and Microsoft Fabric. This role will focus on designing, developing, and maintaining cloud-native data engineering pipelines that support enterprise reporting, real-time analytics, AI/ML initiatives, pricing optimization, and operational intelligence across our network of branches and distribution centers throughout the United States and Canada.
The ideal candidate will possess strong experience in Azure-based data engineering, real-time event streaming, batch processing, Lakehouse architectures, and modern analytics platforms. This role sits at the intersection of Data Engineering, Cloud Architecture, Real-Time Analytics, and AI enablement.
The candidate will work closely with Pricing, Supply Chain, Operations, IT Infrastructure, and Executive Leadership teams to build scalable and resilient analytics solutions using Microsoft Fabric, Azure Databricks, Event Streaming technologies, and Power BI.
We are seeking a mid-level Data Engineer to design, scale, and maintain our dual-engine enterprise data platform on Microsoft Azure and Microsoft Fabric. This role balances both batch and real-time processing architectures, ensuring seamless data flow from transactional systems into analytics-ready storage and semantic models.
This position is critical to PGWAG’s Cloud Modernization, Data Warehouse Modernization, and AI enablement initiatives.
Key Responsibilities & Duties:
Microsoft Fabric & Azure Data Engineering
o Microsoft Fabric
o Azure Data Factory
o Fabric Data Factory
o Azure Databricks
o Azure Event Hubs
o OneLake
o Fabric Lakehouse
o Fabric Data Warehouse
o Pricing Analytics
o Supply Chain Analytics
o POS Sales Analytics
o Customer Behavior Analytics
o Executive Dashboards
o AI/ML workloads
Dual-Engine Data Pipelines
o Azure Data Factory for structured batch processing
o Azure Event Hubs / Kafka for real-time event ingestion
o Batch ETL/ELT
o Change Data Capture (CDC) / Database mirroring
o Streaming ingestion
o API-based integrations
o SaaS integrations
Stream & Batch Processing
o Azure Databricks
o Fabric Spark
o Spark Structured Streaming
o High-volume historical datasets
o XML/JSON log files
o Streaming transactional events
o Operational telemetry data
Data Modeling & Transformation
o ANSI SQL
o T-SQL
o dbt (Data Build Tool)
o Lakehouse design principles
o Star schemas
o Snowflake schemas
o Semantic models
o Curated analytical datasets
Storage & Lakehouse Architecture
o Delta Lake table formats
o ACID-compliant storage patterns
o Schema evolution and enforcement
o Partitioning and performance tuning
Power BI & Analytics Enablement
o Power BI dashboards
o Executive scorecards
o KPI reporting
o Self-service analytics solutions
o Semantic models
o Direct Lake datasets
o Row-level security
o Data governance standards
Infrastructure, Automation & DevOps
o Terraform
o Azure Resource Manager (ARM)
o Infrastructure-as-Code principles
o Azure DevOps
o Git
o Docker
o Azure Data Factory
o Fabric Pipelines
o Managed Apache Airflow
o Control-M integrations where applicable
Data Observability & Reliability
o Batch failures
o Streaming interruptions
o Data quality issues
o Schema drift
o Pipeline latency
Qualifications & Skills:
Required Technical Skills
Cloud & Data Platforms
Programming & Query Languages
Streaming & Batch Technologies
Data Transformation & Storage
Data Modeling
Preferred Qualifications
o Data Science
o Computer Science
o Information Systems
o Engineering
o Statistics
o Mathematics
o or related field
o Data Engineering
o Cloud Analytics
o Enterprise Data Platforms
o Real-Time Data Processing
o Power BI Analytics
o Fabric Real-Time Intelligence
o OneLake
o REST APIs
o XML/JSON processing
o Event-driven architecture
o AI/ML workloads
o Azure OpenAI
o Copilot integrations
o Predictive analytics
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.
