Data Engineer – Data Products & Delivery (On-site Work Schedule)

Parts Town • Addison, IL

7d • $97,628 - $131,753 • Onsite

About The Position

Position at Parts Town See What We’re All About As the fastest-growing distributor of restaurant equipment, HVAC and residential appliance parts, we like to do things a little differently. First, you need to understand and demonstrate our Core Values with safety being your first priority. That’s key. But we’re also looking for unique enthusiasm, high integrity, courage to embrace change…and if you know a few jokes, that puts you on the top of our list! Do you have a genius-level knowledge of original equipment manufacturer parts? If not, no problem! We’re more interested in passionate people with fresh ideas from different backgrounds. That’s what keeps us at the top of our game. We’re proud that our workplace has been recognized for its growth and innovation on the Inc. 5000 list 15 years in a row and the Crain’s Fast 50 list ten times. We are honored to be voted by our Chicagoland team as a Chicago Tribune Top Workplace for the last four years. If you’re ready to roll up your sleeves, go above and beyond and put your ambition to work, all while having some fun, let’s chat – Apply Today! Perks Parts Town Pride – check out our virtual tour and culture! Hybrid work schedule Team member appreciation events and recognition programs Volunteer opportunities Monthly IT stipend Casual dress code On-demand pay options: Access your pay as you earn it, to cover unexpected or even everyday expenses All the traditional benefits like health insurance, 401k/401k match, employee assistance programs and time away – don’t worry, we’ve got you covered. The Job at a Glance The Data Engineer- Data Products & Delivery will specialize in turning raw data into business-ready products within GCP. They will design and optimize data models, marts, and semantic layers in BigQuery , enabling analytics, BI, and ML use cases across the enterprise. You will also support downstream systems and APIs that deliver trusted data for operational and AI-driven processes. Y ou will play a foundational role in shaping this future — building the pipelines, products, and platforms that power the next generation of digital distribution.

Requirements

• You have 4+ years of experience in data engineering or BI-focused data modeling
• You have h ands-on expertise in BigQuery (partitioning, clustering, performance tuning, cost management)
• You have st rong knowledge of dbt , Looker, and SQL for transformation and semantic modeling
• You obtain e xperience with Cloud Functions, Cloud Run, and APIs for data delivery
• You’re f amiliar with Pub/Sub and BigQuery streaming for real-time use cases
• You have a strong u nderstanding of data governance frameworks, Dataplex , and metadata management
• You’re an all-star communicator and are proficient in English (both written and verbal)
• You have a quality, high speed internet connection at home

Nice To Haves

• You have e xposure to ML feature engineering in Vertex AI or similar platforms a plus

Responsibilities

• Build silver/gold layers in BigQuery , transforming raw data into clean, business-ready models.
• Design semantic layers using Looker or dbt for consistent business metrics
• Develop data marts and star schemas optimized for analytics and self-service BI
• Build APIs and services for data delivery (Cloud Functions, Cloud Run)
• Partner with analysts, data scientists, and ML engineers to ensure data & AI readiness and support advanced modeling
• Collaborate with the Data Governance team to embed stewardship, lineage, and metadata into Dataplex and other MDM tooling
• Support real-time analytics using BigQuery streaming and Pub/Sub as needed.
• Optimize query performance and cost efficiency in BigQuery
• Drive adoption of AI/automation by ensuring data models are accessible for predictive and agentic use cases

Benefits

• Hybrid work schedule
• Team member appreciation events and recognition programs
• Volunteer opportunities
• Monthly IT stipend
• Casual dress code
• On-demand pay options: Access your pay as you earn it, to cover unexpected or even everyday expenses
• All the traditional benefits like health insurance, 401k/401k match, employee assistance programs and time away – don’t worry, we’ve got you covered.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Education Level: No Education Listed