• SQL Data Architect

    AO Smith (Nashville, TN)


    SQL Data Architect

     

    Date: Sep 26, 2025

    Location(s):

    Nashville, TN, US, 37228

     

    Company: A. O. Smith Corporation

     

    Company / Location Information

     
     

    Please Note: At this time, we are unable to provide visa sponsorship for this role. 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.

     

    Nearest Major Market:Nashville