Data & Analytics Solutions 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 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