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

#LI-EK1

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.