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 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 Iceberg, and related analytics technologies.
• Experience designing governed semantic models, reusable business data layers, Data as a Product architecture, and self-service analytics solutions.
• Experience designing and implementing AI-enabled analytics solutions utilizing Natural Language Query (NLQ), Microsoft Copilot, Generative AI, semantic search, and conversational analytics capabilities.
• Experience defining, governing, and managing enterprise data products with measurable business value and adoption metrics.
• Experience implementing enterprise data governance, metadata management, data cataloging, business glossaries, lineage tracking, security, and compliance best practices across SAP and non-SAP analytics platforms.
• Strong functional knowledge of Sales, Distribution, Supply Chain, Procurement, Manufacturing, Logistics, Finance, and other enterprise business processes, including their associated data models, KPIs, reporting requirements, and ERP system integrations.
• Ability to troubleshoot system issues, complete complex reconciliations, and coordinate with process experts to resolve integrated business and data issues.
• Proven ability to mentor senior, intermediate, and junior developers and analysts.
• Strong relationship-building skills and the ability to communicate complex information effectively to technical and non-technical stakeholders across all levels of the organization.

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.