Engineer Jobs in Colmar, PA

1 job found

Include remote jobs

4d ago

Lead Data Engineer - SAP HANA

Dorman Products Colmar, PA

Colmar, PA

4d ago

$103k - $153k/yr Full time Analytics Business Analytics Business Intelligence

Apply Now

Job Description

Dorman Products offers a leadership focused, hybrid data engineering role in Colmar, PA, centered on architecting, building, and optimizing an enterprise SAP HANA data ecosystem. This position combines strategic vision with hands-on delivery, including mentoring a team and driving BI modernization. The role is onsite two days per week and comes with a competitive compensation range of USD 102,900 to USD 153,100 annually.

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

Responsibilities

Design and implement end-to-end data warehousing solutions using dimensional modeling approaches
Develop and maintain enterprise data models (conceptual, logical, physical) to support analytics and operations
Optimize SAP HANA models and views (Calculation, CDS, and Standard SQL) for performance and reusability
Define 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 support of ETL processes and data integration solutions
Partner with ETL and reporting developers to architect scalable, high-performing solutions
Support SLT replication setup to ensure real-time data synchronization with SAP ECC
Manage and optimize cloud-based data platforms
Collaborate with SAP administration teams on HANA upgrades, migrations, and environment refreshes
Use GitHub for version control and deployment coordination of HANA objects
Identify and resolve database performance and scalability issues
Integrate data quality tools and maintain detailed data lineage and source-to-target mappings
Review technical designs to ensure alignment with architectural standards
Support the Quality Assurance team with testing efforts
Lead and mentor a team of data engineers, fostering technical excellence and continuous improvement
Drive modernization of BI infrastructure by evaluating and adopting emerging technologies
Implement the strategic vision for data engineering and BI platforms
Work with product managers, business analysts, and development teams to translate business requirements into sound data architecture
Communicate complex architectural concepts to technical and non-technical audiences
Participate in data governance and architecture review meetings to ensure consistency and compliance

Technologies

SAP HANA
SQL Server
SAP ECC
SAP SCM/APO
SAP Data Services
SLT
SAP Business Objects
Qlik
Power BI
Microsoft Azure analytics services – Data Fabric, Data Lake, Delta Lake, Databricks
GitHub
Jira

Requirements

Experience with SAP HANA and other relational databases (eg SQL Server)
Relational and dimensional modeling (ER models, star and snowflake schemas)
Familiarity with ETL tools and frameworks (SAP Data Services, SLT)
Working knowledge of reporting and analytics tools (SAP Business Objects, Qlik, Power BI)
Understanding of SAP ECC and SAP SCM/APO data structures and integration methods
Experience with Microsoft Azure analytics services – Data Fabric, Data Lake, Delta Lake, Databricks
Experience with GitHub for version control
Knowledge of Jira for project tracking
SAP HANA experience: 1 year (Required)
Education: Bachelor's degree
Minimum experience: 2 years

Application questions

Will you now, or at any time in the future, require sponsorship for employment visa status (e.g. H-1B visa status)?

View full job page →

Get Job Alerts

New jobs delivered to your inbox.