Lead Data Engineer - SAP HANA

Data Engineering Lead Company: Dorman Products Dorman was founded on the belief that people should have greater freedom to fix motor vehicles. For over 100 years, we have been driving new solutions, releasing tens of thousands of aftermarket replacement products engineered to save time and money, and increase convenience and reliability. Founded and headquartered in the United States, we are a pioneering global organization offering an always‑evolving catalog of automotive, heavy‑duty and specialty vehicle products. Today, we have more than 3,800 employees across 29 different locations, with a family of brands that also includes SuperATV and Dayton Parts. Reaching a revenue of $2.13 billion in 2025, Dorman is publicly traded under the stock ticker DORM. Everyone who works at Dorman is called a Contributor. We need everyone, regardless of role and experience, to contribute to our success. That means everyone has a unique ability to make an impact on the business. We encourage all our Contributors to bring their authentic selves to work. The freedom to pursue new ideas, offer different perspectives, and grow in your career is fundamental to working at Dorman. Job Summary Dorman Products is seeking a Data Engineering Lead to build and scale modern data engineering capabilities while supporting our existing enterprise data environment. This role is hands‑on and engineering‑driven, with a strong emphasis on dimensional modeling, data pipeline development, and modern cloud platforms including Microsoft Fabric, Azure Data Lake, and Databricks. This role will leverage Python to develop scalable, distributed data pipelines, perform data transformation and validation, and enable advanced data processing within a Lakehouse architecture. Our major ERP source system is SAP ECC, with SAP APO as a key demand‑planning source. SAP HANA remains part of our current analytics and data warehousing environment and will continue to serve as a source system for SAP‑related data as needed. Experience with HANA is helpful but not required. Current tool stack includes SAP ECC, SAP APO, SAP HANA, SAP SLT, SAP Data Services, SQL Server, Power BI, Qlik SaaS, and SAP Business Objects. 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 Build and maintain scalable ETL/ELT pipelines using Databricks, Fabric pipelines, and Python Develop ingestion and transformation frameworks aligned to Lakehouse and Medallion patterns, leveraging Python for distributed data processing and orchestration logic Implement reusable Python‑based data processing modules for parsing, enrichment, and handling semi‑structured data (JSON, XML, APIs) Integrate data from SAP ECC, SAP APO, SAP HANA, and other enterprise systems into the modern platform Ensure reliability, performance, and observability across pipelines, including logging, error handling, and monitoring patterns Dimensional Modeling, Semantic Modeling & Data Structures Design and implement dimensional models using star schema patterns to support analytics and AI workloads Build and maintain semantic models (e.g., business‑friendly datasets, curated subject areas, reusable metrics) Develop conceptual, logical, and physical data structures for enterprise reporting and data products Platform Modernization & Engineering Leadership Contribute to the build‑out of Azure Data Lake, Fabric, Databricks, and Delta Lake environments Lead engineering practices including CI/CD, Git‑based workflows, and code quality standards Drive adoption of notebook‑based and production‑grade Python workflows in Databricks (jobs, pipelines, reusable libraries) Support existing HANA‑based data models and integrations while modern cloud architecture is built and expanded Data Quality, Governance & Performance Implement data quality checks, lineage, and metadata standards Develop data validation frameworks to enforce business rules, schema checks, and data quality thresholds Monitor and optimize pipeline and query performance Align engineering work with enterprise governance frameworks Mentor data engineers and BI/reporting developers Translate business needs into scalable engineering solutions Partner with analytics teams to enable self‑service and AI‑driven use cases Qualifications Core Technical Skills (MUST HAVE) Strong experience in dimensional modeling and semantic modeling Hands‑on experience with Azure Data Lake, Fabric, Databricks, Delta Lake, and Python Experience building ETL/ELT pipelines and working with Lakehouse/Medallion architectures Strong understanding of Python‑based data engineering concepts, including: DataFrames (Spark / pandas) Data cleansing and transformation patterns Handling structured and semi‑structured data Performance optimization in distributed processing SAP (Nice to Have, Not Required) Familiarity with SAP ECC as a primary ERP source system Understanding of SAP APO demand‑planning data structures Exposure to HANA modeling or extraction patterns Analytics & Tools Power BI experience preferred GitHub, CI/CD, and data governance tooling familiarity 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 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. 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. Nearest Major Market: Philadelphia Job Segment: Supply Chain, Demand Planner, Database, ERP, Operations, Automotive, Technology #J-18808-Ljbffr