Lead Product Data Enginee

Lead Product Data Engineer - Service Sales & Performance

Location: Leslie, Illinois ( Onsite)

Job Description

We are looking for an experienced Lead Product Data Engineer with strong SQL and Python skills to design, develop, and maintain production-grade data pipelines and data models. The ideal candidate will have experience in data engineering, data reconciliation, data quality, lineage, monitoring, and data platform modernization across multiple enterprise systems.

The role will focus on improving data reliability, building scalable data solutions, and integrating data from systems such as CAPM, SAP, DB2, and Hadoop to support service sales and performance analytics.

Key Responsibilities

• Design, develop, and maintain scalable data pipelines using advanced SQL and Python.
• Build and optimize data models to support service sales, performance reporting, and business analytics.
• Perform data reconciliation across multiple source systems and investigate data discrepancies.
• Implement data quality checks, data validation, lineage tracking, and monitoring processes.
• Integrate and transform data from enterprise systems, including CAPM, SAP, DB2, and Hadoop.
• Modernize existing data pipelines and improve data processing performance, reliability, and scalability.
• Collaborate with business stakeholders, product teams, and engineering teams to understand data requirements.
• Troubleshoot data pipeline failures, resolve data quality issues, and ensure data accuracy and consistency.
• Establish best practices for data engineering, documentation, governance, and production support.
• Support cloud-based data engineering solutions and enterprise data platform modernization initiatives.

Required Qualifications

• Strong hands-on experience with advanced SQL and Python programming.
• Proven experience building and supporting production data pipelines.
• Experience designing, developing, and optimizing data models.
• Strong knowledge of data reconciliation, data quality, data lineage, and monitoring.
• Experience working with enterprise data systems such as SAP, DB2, Hadoop, or similar platforms.
• Experience with data integration, transformation, troubleshooting, and performance optimization.
• Ability to lead technical initiatives and collaborate with cross-functional teams.
• Strong analytical, problem-solving, and communication skills.

Preferred Qualifications

• Experience with Databricks and Azure data services.
• Exposure to Palantir Foundry.
• Experience in service contracts, service sales, billing, claims, or automotive service data.
• Experience with enterprise data modernization and data governance initiatives.
• Experience supporting large-scale production data platforms.