# Data & Analytics Solutions Architect — AO smith

- Location: Nashville, TN
- Posted: Nov 7, 2026
- Status: open (checked Nov 20, 2026)
- Apply (employer's site): https://jobs.aosmith.com/job/Nashville-Data-&-Analytics-Solutions-Architect-TN-37228/1438842700/
- Employer record: https://visajobs.io/company/ao-smith.md

## Sponsorship history
- Tier: Good history
- Occupation (SOC): Software Developers (15-1252)
- Employer's certified LCAs for this occupation in TN, FY2024–FY2026: 12
- …in the whole US: 13
- With this exact title: 0
- Median DOL prevailing wage, level I / II: $76k / $97k

## Description
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
This position is a unique opportunity to serve as a hands-on BI & Analytics solutions architect and subject matter expert responsible for designing, delivering and modernizing enterprise analytics solutions across SAP and non-SAP platforms, cloud data platforms, and modern analytics ecosystems. The role will partner closely with business stakeholders and technology teams to understand business needs, define scalable solutions, lead solution delivery, and drive measurable business outcomes. This individual will be fully engaged beyond technology, gaining a deep understanding of critical business processes, managing project deliverables, and collaborating across cross-functional teams to deliver innovative and value-driven analytics solutions
Responsibilities
Develop a deep understanding of A. O. Smith business processes and strategy through collaboration and regular engagement with key stakeholders and process owners
Support the identification and implementation of process improvement opportunities, using analytics that support organizational strategy and priorities
Engage and lead high visibility Analytics projects across all BI functional areas from start to finish by
Meeting with stakeholders to understand the work, collaboratively develop project charters and A3s, create, manage timelines, gather, and validate requirements; and define business value
Developing functional and technical specifications that translate complex requirements into robust designs
Design and develop scalable enterprise analytics solutions utilizing SAP BW/4HANA, SAP Business Data Cloud (BDC), SAP Datasphere, Snowflake, AWS (S3, Athena, Iceberg, Glue), Tableau, Power BI, and Data Lakehouse architectures while applying Data as a Product, Hub-and-Spoke, and Data Mesh modeling principles.
Design and develop scalable ELT/ETL pipelines utilizing AWS Glue, SAP Data Services (BODS), SAP SDI, SQL, Python, and cloud-native integration services.
Design governed semantic models and reusable business data layers that enable self-service analytics, natural language querying, and consistent KPI definitions across reporting platforms.
Develop and execute analytics modernization roadmaps supporting the transition from SAP BW on HANA to SAP Business Data Cloud (BDC), SAP Datasphere, AWS Data Lakehouse, and modern self-service analytics platforms.
Design and enable AI-ready data architectures that support Large Language Models (LLMs), Retrieval Augmented Generation (RAG), semantic search, and conversational analytics capabilities.
Develop and maintain solution validation, technical and functional documentation, and ensure that change management and approval processes are completed
Measure actual business value realized, and conduct lessons learned
Interface SAP BW with SAP and third-party analytics tools to improve usability and process efficiency
Advise on development and testing proposals amongst team members across the full analytics stack
Collaborate with other functional architects and business analysts to ensure end-to-end analytic needs are met
Understand non-SAP business systems and support business analysts as needed
Support a data driven decision culture, Analytics Road maps and Audit requests
Mentor team members and functional analysts on best practices
Monitor Analytics trends and best practices and identify optimization opportunities
Cloud & AI Modernization
Design and implement modern cloud-based analytics architectures leveraging SAP Business Data Cloud (BDC), SAP Datasphere, AWS services (Amazon S3, Athena, Glue, Iceberg), Snowflake, and Data Lakehouse patterns.
Drive Data as a Product strategy by developing scalable, governed, and reusable data products that support enterprise analytics and self-service reporting.
Evaluate and implement AI-powered analytics capabilities, including natural language querying, Copilot-enabled analytics, semantic models, and advanced decision-support solutions.
Collaborate with business stakeholders to identify opportunities for generative AI, machine learning, and predictive analytics to improve operational efficiency and business outcomes.
Qualifications
Bachelor’s degree in computer science, Information Systems, Mathematics, or a related field.
8+ years of experience designing and delivering enterprise analytics solutions utilizing SAP BW/4HANA and modern cloud-based analytics platforms such as SAP Business Data Cloud (BDC), SAP Datasphere, AWS, Snowflake, or equivalent cloud analytics technologies.
5+ years of experience developing enterprise reporting and analytics solutions using Business Objects, Analysis for Office, Tableau, Power BI, SAP Analytics Cloud (SAC), SSRS, or equivalent platforms.
Experience leading requirements-gathering workshops, developing functional and technical specifications, defining business value, and translating complex business needs into scalable analytics solutions.
Working knowledge of SAP BW/4HANA, SAP data extraction frameworks, CDS Views, SAP security concepts, SAP integration technologies, testing, data migration, cutover, user training, and hyper-care support.
Experience with SAP Business Data Cloud (BDC), SAP Datasphere, Snowflake, AWS Lakehouse architecture, or equivalent modern data platform technologies.
Experience designing cloud-based data platforms and Lakehouse architecture utilizing AWS services, Snowflake, SQL, Athena, Apache Icebe

> History, not a promise: past H-1B filings do not mean an employer will sponsor you or a given role. Data: U.S. DOL OFLC LCA disclosure (FY2024–FY2026 for role counts, certified LCAs) and the USCIS H-1B Employer Data Hub. Not legal advice. Methodology: https://visajobs.io/methodology
