/Lead Data Engineer

Lead Data Engineer

IIllinoisLisleusvia direct
// Job Type
Full Time
// Salary
Not disclosed
// Posted
2 months ago

About the Role

Job Description Visa Requirement: This position is open only to candidates authorized to work in the United States under the following categories: U.S. Citizen, Green Card Holder, GC-EAD, H-4 EAD, L-2s, L-2 EAD, or J-2 EAD. Candidates requiring other visa sponsorship are not eligible for this role. Job Summary: We are looking for a highly experienced Lead Data Engineer to lead enterprise-level data migration and data quality initiatives as part of SAP ERP transformation programs. The ideal candidate will have deep hands-on experience in data extraction, cleansing, transformation, and migration from legacy systems such as PeopleSoft, BAAN, and Infor LN into SAP ERP / S4 HANA environments. Key Responsibilities: Lead end-to-end data conversion and migration activities including scoping, extraction, mapping, transformation, validation, and loading of master and transactional data into SAP systems. Design and implement data migration solutions to move data from PeopleSoft, BAAN, Infor LN, and other legacy systems to SAP ERP / S4 HANA. Define and standardize development, testing, and validation templates for data extraction and conversion. Evaluate, select, and implement data extraction, data quality, and cleansing tools. Develop and maintain automated ETL/ELT pipelines using Python, Spark/PySpark, SQL, and cloud-native services. Identify and resolve data duplication, integrity, and quality issues; implement preventive governance controls. Create and maintain data mapping documents, including mappings to SAP Business Partner (Customer/Supplier) objects. Define, monitor, and improve data quality rules, dashboards, and controls. Collaborate with data stewards, business owners, architects, and cross-functional teams to resolve data quality issues. Provide technical leadership and mentorship to data engineers and data migration team members. Support mock conversions, cutover activities, reconciliation, and post-migration validation. Required Qualifications: 12+ years of overall IT experience, including strong hands-on experience in data engineering and system architecture. 8+ years of experience in data extraction, data migration, data cleansing, and data management. Proven experience leading large-scale data migrations to SAP ERP / S4 HANA. Hands-on experience with SAP HANA and at least one or two SAP implementations. Strong programming skills in Python, SQL, PL/SQL, and experience with Spark / PySpark. Experience with Azure Data Factory, Azure Functions, Synapse, ADLS and/or AWS Glue and other AWS data services. Hands-on experience with data migration tools such as Syniti or IBM DataStage. Experience using data quality tools such as Informatica Data Quality, Talend DQ, or Ataccama. Strong understanding of ETL/ELT processes, Master Data Management (MDM), and data governance. Excellent analytical, problem-solving, and communication skills. Preferred Qualifications: Experience building and maintaining data quality dashboards and scorecards. Experience managing data quality issue trackers and coordinating with data stewards or data owners. Strong experience with SQL-based reporting, Excel, Access, and data analysis tools. Familiarity with data warehousing concepts and analytics platforms. Experience with data visualization tools. Prior experience in a Lead or Architect-level data engineering role. Ability to work independently and lead cross-functional technical teams. Apply Online Your Name * Your Phone Number * Your Email Address * Job id What is your current U.S. visa or immigration status? * SelectU.S. Citizen (USC)Lawful Permanent Resident (Green Card holder)H1BF1-OPT/Stem-OPT/CPT EADH4-EADL-2SGC-EADOther Valid Visa Where are you currently located at? * W2 or C2C * SelectW2C2C How many years of total experience do you have? * How many years of relevant experience do you have? * Do you require H1B sponsorship? * YesNo Do you require sponsorship? * NoYes – H-1B transferYes – Green Card sponsorshipYes – Both H-1B transfer and Green Card sponsorship Upload Resume * Ī” Visa Requirement: This position is open only to candidates authorized to work in the United States under the following categories: U.S. Citizen, Green Card Holder, GC-EAD, H-4 EAD, L-2s, L-2 EAD, or J-2 EAD. Candidates requiring other visa sponsorship are not eligible for this role. Job Summary: We are looking for a highly experienced Lead Data Engineer to lead enterprise-level data migration and data quality initiatives as part of SAP ERP transformation programs. The ideal candidate will have deep hands-on experience in data extraction, cleansing, transformation, and migration from legacy systems such as PeopleSoft, BAAN, and Infor LN into SAP ERP / S4 HANA environments. Key Responsibilities: Lead end-to-end data conversion and migration activities including scoping, extraction, mapping, transformation, validation, and loading of master and transactional data into SAP systems. Design and implement data migration solutions to move data from PeopleSoft, BAAN, Infor LN, and other legacy systems to SAP ERP / S4 HANA. Define and standardize development, testing, and validation templates for data extraction and conversion. Evaluate, select, and implement data extraction, data quality, and cleansing tools. Develop and maintain automated ETL/ELT pipelines using Python, Spark/PySpark, SQL, and cloud-native services. Identify and resolve data duplication, integrity, and quality issues; implement preventive governance controls. Create and maintain data mapping documents, including mappings to SAP Business Partner (Customer/Supplier) objects. Define, monitor, and improve data quality rules, dashboards, and controls. Collaborate with data stewards, business owners, architects, and cross-functional teams to resolve data quality issues. Provide technical leadership and mentorship to data engineers and data migration team members. Support mock conversions, cutover activities, reconciliation, and post-migration validation. Required Qualifications: 12+ years of overall IT experience, including strong hands-on experience in data engineering and system architecture. 8+ years of experience in data extraction, data migration, data cleansing, and data management. Proven experience leading large-scale data migrations to SAP ERP / S4 HANA. Hands-on experience with SAP HANA and at least one or two SAP implementations. Strong programming skills in Python, SQL, PL/SQL, and experience with Spark / PySpark. Experience with Azure Data Factory, Azure Functions, Synapse, ADLS and/or AWS Glue and other AWS data services. Hands-on experience with data migration tools such as Syniti or IBM DataStage. Experience using data quality tools such as Informatica Data Quality, Talend DQ, or Ataccama. Strong understanding of ETL/ELT processes, Master Data Management (MDM), and data governance. Excellent analytical, problem-solving, and communication skills. Preferred Qualifications: Experience building and maintaining data quality dashboards and scorecards. Experience managing data quality issue trackers and coordinating with data stewards or data owners. Strong experience with SQL-based reporting, Excel, Access, and data analysis tools. Familiarity with data warehousing concepts and analytics platforms. Experience with data visualization tools. Prior experience in a Lead or Architect-level data engineering role. Ability to work independently and lead cross-functional technical teams. [contact-form-7 id="ac31dcc" title="Job Apply Form"]

Interested in this job?

Login to Apply

Use our AI to tailor your resume for this Lead Data Engineer position at JPS Tech Solutions LLC.