Dorman Products seeks a seasoned Lead Data Engineer to architect and optimize an enterprise data ecosystem centered on SAP HANA. This hybrid position in Colmar, PA blends hands-on development with leadership responsibilities, requiring onsite collaboration two days per week and offering a salary range of USD 102,900 to 153,100 annually.
Compensation
USD 102,900 - 153,100 per year
Location and Schedule
Colmar, Pennsylvania, hybrid work arrangement with on-site presence required two days per week.
Responsibilities
- Design and deploy end-to-end data warehousing solutions using dimensional modeling approaches.
- Create and maintain enterprise data models across conceptual, logical, and physical layers to support analytics and operational reporting.
- Tune SAP HANA models and views including Calculation views, CDS, and standard SQL for performance and reusability.
- Establish and enforce modeling standards, naming conventions, and best practices across projects.
- Integrate data and semantic models with Microsoft Azure analytics services.
- Oversee the development and ongoing support of ETL processes and data integration solutions.
- Collaborate with ETL and reporting developers to design scalable, high-performance solutions.
- Assist with SLT replication setup to enable real-time data synchronization with SAP ECC.
- Manage and optimize cloud-based data platforms.
- Work with SAP administration teams on HANA upgrades, migrations, and environment refreshes.
- Utilize GitHub for version control and coordinating deployment of HANA objects.
- Identify and resolve database performance and scalability issues.
- Incorporate data quality tooling and maintain thorough data lineage and source-to-target mappings.
- Review technical designs to ensure alignment with architectural standards.
- Support QA efforts during testing activities.
- Lead and mentor a team of data engineers, fostering technical excellence and continuous improvement.
- Advance BI infrastructure modernization by evaluating and adopting emerging technologies.
- Implement the strategic vision for data engineering and BI platforms.
- Partner with product managers, business analysts, and development teams to translate business requirements into robust data architectures.
- Communicate complex architectural concepts to both technical and non-technical audiences.
- Participate in data governance and architecture review meetings to ensure consistency and compliance.
Requirements
- Experience with SAP HANA and other relational databases such as SQL Server.
- Proficiency in relational and dimensional modeling (ER models, star/snowflake schemas).
- Familiarity with ETL tools and frameworks such as SAP Data Services and SLT.
- Working knowledge of reporting and analytics tools such as SAP Business Objects, Qlik, and Power BI.
- Understanding of SAP ECC and SAP SCM/APO data structures and integration methods.
- Experience with Microsoft Azure analytics services including Data Fabric, Data Lake, Delta Lake, and Databricks.
- Experience with GitHub for version control.
- Familiarity with Jira for project tracking.
Education
Bachelor's degree
Experience
- SAP HANA experience: 1 year (Required)
- Minimum 2 years of overall data engineering experience
Technologies
SAP HANA, SQL Server, SAP ECC, SAP SCM/APO, SAP Data Services, SLT, SAP Business Objects, Qlik, Power BI, Microsoft Azure analytics services including Data Fabric, Data Lake, Delta Lake, Databricks, GitHub, Jira
Benefits
- Medical
- Dental
- Vision
- Basic life insurance
- Paid time off (sick/vacation)
- Paid Parental Leave
- Paid holidays
- Floating holidays
- 401k retirement plan (with company match and profit-sharing)
- Discounted Employee Stock Purchase Plan
Application Question
Will you now, or at any time in the future, require sponsorship for employment visa status (for example H-1B visa status)?
