Data Engineer Lead
Dorman Products
We do not know your resume yet
Upload your resume to unlock your actual match score and identify important JD keywords before applying.
Recruiters may search these ATS Keywords in your resume
Keywords
Job Description
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
Data Engineering & Pipeline Development
- 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
- Establish Python development standards (modular design, code reuse, testing practices, dependency management)
- 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
Collaboration & Team Leadership
- 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
About The 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 28 different locations around the world, with a family of brands that also includes SuperATV and Dayton Parts. Publicly traded under the stock ticker DORM, we had revenues surpassing $1.93 billion in 2023 and over $3.5 billion in enterprise value. 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.
How to Apply Better for This Job
This section explains the correct next step without forcing sign-in immediately.
Check ATS score before applying
Scan your resume for ATS readability, formatting issues, missing sections, weak keywords, and content gaps.
Customize your resume for this JD
Match your resume with the job description and add ai , bi , ecc , erp , etl , keywords where they fit naturally.
Find similar jobs too
Do not depend on one opening. Use your resume to find similar frontend jobs across relevant job platforms.
Ready with your customized resume?
Once your resume includes the right skills and is ATS-friendly, you can apply directly on the source platform.
Market Insights:Best Data Engineer Jobs in India
Find the latest Data Engineer jobs across top Indian cities. Compare job counts by location and apply where hiring demand is higher.