Senior Enterprise SAP Data Engineer

Company / Location Information

A.O. Smith is a global leader applying innovative technologies and energy-efficient solutions to products manufactured and marketed worldwide. The company is one of the world’s leading manufacturers of residential and commercial water heating equipment and boilers, as well as a manufacturer of water treatment products for residential and light commercial applications. A. O. Smith is headquartered in Milwaukee, Wisconsin, with approximately 12,000 employees at operations in the United States, Canada, China, India, Mexico, the Netherlands, and the United Kingdom.

Primary Function

The Sr Enterprise Data Engineer will be responsible for keeping the SAP BODS system running smoothly and building and supporting data integration solutions. The incumbent is responsible for creating and managing our SAP data replication process using SLT, Data Services, & Information Steward. All activities will be in support of all data integration, data governance, data quality, and virtualization efforts.   

Responsibilities

• Create & Manage SAP Landscape Transformation (SLT) data replication jobs.
• Create datasets, views and data extracts using ETL & virtualization platforms.
• Responsible for developing SAP BODS workflows/dataflows/mapping.
• Actively participate in requirements and design meetings for data integration, conversion, & migration initiatives.
• Data Profiling using SAP Information Steward for Data Cleansing and data governance.
• Create ETL jobs to move data between data systems.
• Create and maintain technical documentation for data integration processes.
• Monitor and optimize the performance of data integration processes.
• Provide round the clock Production support.

Qualifications

• Bachelor’s degree in information technology, Computer Science, or relatable degree with IT Experience.
• Professional eqivalent experience and certifications can be substituted in lieu of a degree.
• 8+ years of experience in Information Technology disciplines.
• Deep understanding of relational databases, queries, & database programming.
• Knowledge and experience with:
  1. Data Quality & Analysis.
  2. Data migration, integration and management tools
  3. Data modeling and database design.
  4. Experience In SAP Information Steward, SAP BODS, SLT

ADDITIONAL QUALIFICATIONS:

• In-depth understanding of database migration principles & experience with the migration of mission critical databases across multiple database platforms.
• Expertise in MSSQL, SSIS, and scripting languages.
• Familiarity with data virtualization tools (Denodo).
• Must have strong organizational and prioritization skills.
• Must demonstrate critical attention to detail and deadlines.
• Must be able to operate independently while establishing strong working relationships with co-workers.

Education

We Offer

Competitive compensation package and comprehensive benefits plans which include medical and dental insurance, company-sponsored life insurance, retirement security savings plan, short- and long-term disability programs and tuition assistance.

#LI-AO

#LI-Hybrid

ADA Statement & EEO Statement

In developing this job description care was taken to include all competencies needed to successfully perform in this position. However, for Americans with Disabilities Act (ADA) purposes, the essential functions of the job may or may not have been described for purposes of ADA reasonable accommodation. All reasonable accommodation requests will be reviewed and evaluated on a case-by-case basis.

We consider all applicants for employment without regard to race, color, religion, gender, sexual orientation, national origin, age, disability, gender identity and expression, marital or military status. We also provide reasonable accommodations to qualified individuals with disabilities in accordance with the Americans with Disabilities Act and applicable state and local law.