Data Engineering Lead

Job Summary Dorman Products is seeking a Data Engineering Lead to architect, modernize, and scale our enterprise data platform. This role blends hands‑on engineering with leadership, requiring deep expertise in dimensional modeling, data architecture, and ETL development, along with experience across modern cloud data platforms. The ideal candidate will bring strong SAP HANA experience to support current systems while driving the transition toward a cloud‑first architecture leveraging Microsoft Fabric, Azure Data Services, Databricks, and Python‑based data engineering frameworks. This leader will play a key role in enabling advanced analytics and AI‑driven capabilities across the organization. This is a hybrid role in our corporate headquarters in suburban Philadelphia (Colmar, PA) with the expectation to be onsite two days per week. Primary Duties Design and implement scalable enterprise data architectures using dimensional modeling (Kimball/star schema) and modernlakehousepatterns Develop andmaintainconceptual, logical, and physical data models aligned to enterprise analytics needs Define and enforce data modeling standards, governance, and best practices Design architectures aligned with Medallion (Bronze/Silver/Gold) data layering Ensure models support both traditional BI and emerging AI/ML use cases Architect and oversee development of scalable ETL/ELT pipelines using modern tooling (Databricks, Azure Data Factory, Fabric pipelines, Python) Optimizeingestion patterns from SAP (ECC/HANA) and other source systems into cloud platforms Partner with developers to ensure reliability, scalability, and observability of pipelines Support both batch and near real‑time data ingestion frameworks Leverage SAP HANAexpertiseto support existing data models, views, and integrations OptimizeSAP HANA (Calculation Views, CDS) for performance and data extraction Guide integration strategies from SAP ECC/S4 into modern cloud data platforms Support SLT or CDC‑based replication strategies Drive adoption and optimization of Microsoft Azure ecosystem (Fabric, Data Lake, Synapse, Databricks) Design and implementlakehousearchitectures using Delta Lake principles Promote use of Python and modern data engineering frameworks Lead platform modernization initiatives and tool evaluations Data Quality, Governance & Performance Define and enforce data quality frameworks, lineage, and metadata management Ensure observability, monitoring, and performance tuning across pipelines and warehouses Align with enterprise data governance standards Leadership & Strategic Direction Lead, mentor, and grow a team of data engineers and BI/reporting developers Establish engineering best practices including CI/CD, code reviews, and version control (GitHub) Drive roadmap for modern data platform transformation and AI readiness Foster innovation and continuous improvement mindset within the team Stakeholder Engagement Translate business requirements into scalable data solutions Partner with BI, analytics, and data science teams to enable self‑service analytics and AI use cases Communicate technical strategy effectively to leadership and business stakeholders Qualifications Core Technical Skills Strong experience in dimensional modeling and data architecture (MUST HAVE) Expertise in ETL/ELT frameworks and pipeline orchestration Hands‑on experience with modern data platforms: Microsoft Azure (Fabric, Data Lake, Synapse) Databricks / Delta Lake Python for data engineering Experience with medallion/lakehouse architecture patterns Hands‑on experience with SAP HANA modeling and performance tuning (MUST HAVE) Understanding of SAP ECC/S4 data structures and integration patterns Analytics & Reporting Experience enabling reporting solutions (Power BI preferred, plus SAP BO/Qlik familiarity helpful) Strong understanding of how data models support analytics and reporting workloads Tools & Practices GitHub or equivalent for version control CI/CD and DevOps practices for data pipelines Familiarity with data governance, lineage, and cataloging tools Education / Experience Bachelor’s degree in Computer Science , Information Systems, or related field 5+ years in data engineering / data architecture 3+ years in leadership or senior technical role Compensation & Benefits The US base salary range for this full‑time position is $102,900.00 to $153,100.00. This role is also eligible for a bonus. The actual base pay offered to the successful candidate will depend on multiple factors, including but not limited to job‑related knowledge and skills, experience, business needs, geographical location, and internal pay equity. Compensation decisions are made based on the specific facts and circumstances of each role and candidate. As a Dorman US contributor, you (and eligible dependents, as applicable) will have access to medical, dental, vision, basic life insurance, paid time off (sick/vacation), and Paid Parental Leave. U.S. employees are entitled to paid holidays, floating holidays, and paid time off starting in their first year of employment depending on hire date. You are also able to participate in our 401k retirement plan (with company match and profit‑sharing) and Discounted Employee Stock Purchase Plan. EEO Statement Dorman Products is an equal opportunity employer; we value a combination of ideas, perspectives, and cultures at our company. We do not discriminate on the basis of race, religion, color, national origin, gender, sex, gender identity, sexual orientation, age, marital status, veteran status, or disability status. EEO/AA Employer M/F/D/V. Location Nearest Major Market: Philadelphia Job Segment: Computer Science, Information Systems, SAP, ERP, Engineer, Technology, Engineering #J-18808-Ljbffr Allparts, Inc.