Lead Data Engineer - SAP HANA

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 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 Data Architecture & Modeling Design and implement scalable enterprise data architectures using dimensional modeling (Kimball/star schema) and modern lakehouse patterns Develop and maintain conceptual, 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 Data Engineering & Pipeline Development Architect and oversee development of scalable ETL/ELT pipelines using modern tooling (Databricks, Azure Data Factory, Fabric pipelines, Python) Optimize ingestion 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 SAP & Legacy Platform Integration Leverage SAP HANA expertise to support existing data models, views, and integrations Optimize SAP 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 Cloud & Modern Data Platform Leadership Drive adoption and optimization of Microsoft Azure ecosystem (Fabric, Data Lake, Synapse, Databricks) Design and implement lakehouse architectures 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 SAP & Enterprise Systems 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 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. www.DormanProducts.com