SQL Data Architect

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.

Please Note: At this time, we are unable to provide visa sponsorship. Candidates must be authorized to work in the United States without sponsorship now or in the future.

Primary Function

The Data architect will play an integral role in defining solutions for data projects in support of business and data strategy initiatives. The incumbent will work closely with process teams, systems integrators, and developers to identify requirements and define solutions for all data integration requests. 

Responsibilities

SPECIFIC DUTIES/ACCOUNTABILITIES (List in order of importance)

• Work closely with the process teams, systems integration, and developers to identify solutions for all data and process integration requests for websites, portals, & ERP systems.
• Support Data Integration/Conversion Initiatives by being responsible for the identification and resolution of information flow, content issues and the transformation of business requirements into logical data models.
• Defining technical standards, designs, and guidelines for movement of data through the enterprise.
• Provide guidance and direction for data and process integration projects in support of business initiatives.
• Performs ETL, ELT operations and administration of data and systems securely and in accordance with enterprise data governance standards.
• Actively participate in requirements and design meetings for data integration, conversion, & migration initiatives.
• Create views and data extracts for archived and legacy data using SSIS & SSRS.
• Engineer and orchestrate data flows & pipelines.

Qualifications

BASIC QUALIFICIATIONS:

• Bachelor’s Degree in Information Technology, Computer Science, or related degree with IT Experience.
• Professional experience can be substituted in lieu of degree.
• Minimum of 5 years of experience in Information Technology disciplines.
• Deep understanding of relational databases, queries, & database programming.
• Knowledge and experience with:
  • a. Data Quality & Analysis.
  • b. Data migration, Integration, & management tools
  • c. Data modeling and Database design
  • d. Data warehousing, BI and analytics.
• In-depth understanding of database migration principles & experience with the migration of mission critical databases across multiple database platforms.
• Experience in MSSQL, SSIS, and SSRS.

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.

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.