Data & Analytics Solutions Architect

Requirements:

• Bachelors degree in computer science, information systems, mathematics, or a related field.
• 8+ years of experience designing and delivering enterprise analytics solutions using SAP BW/4HANA and modern cloud analytics platforms such as SAP Business Data Cloud (BDC), SAP Datasphere, AWS, Snowflake, or equivalent technologies.
• 5+ years of experience developing enterprise reporting and analytics solutions with platforms such as BusinessObjects, Analysis for Office, Tableau, Power BI, SAP Analytics Cloud, SSRS, or equivalents.
• Experience leading requirements workshops, preparing functional and technical specifications, defining business value, and translating complex needs into scalable analytics solutions.
• Working knowledge of SAP BW/4HANA, SAP data extraction frameworks, CDS Views, SAP security and integration, testing, data migration, cutover, user training, and hyper-care support.
• Experience with SAP BDC, SAP Datasphere, Snowflake, AWS Lakehouse architecture, or comparable modern data platforms.
• Experience designing cloud data platforms and Lakehouse architectures using AWS services, Snowflake, SQL, Athena, Apache Iceberg, and related technologies.
• Experience designing governed semantic models, reusable business data layers, Data as a Product architectures, and self-service analytics solutions.
• Experience implementing AI-enabled analytics, including natural language querying, Microsoft Copilot, generative AI, semantic search, and conversational analytics.
• Experience defining, governing, and managing enterprise data products with measurable business value and adoption metrics.
• Experience with enterprise data governance, metadata management, data cataloging, business glossaries, lineage, security, and compliance across SAP and non-SAP platforms.
• Strong functional knowledge of enterprise processes such as sales, distribution, supply chain, procurement, manufacturing, logistics, and finance, including related data models, KPIs, reporting needs, and ERP integrations.
• Ability to troubleshoot system issues, perform complex reconciliations, and work with process experts to resolve integrated business and data issues.
• Proven ability to mentor developers and analysts at senior, intermediate, and junior levels.
• Strong relationship-building and communication skills, including the ability to explain complex information to technical and non-technical stakeholders at all organizational levels.

Responsibilities:

• Build a strong understanding of our business processes and strategy through regular collaboration with stakeholders and process owners.
• Identify and implement process improvements using analytics aligned with organizational strategy and priorities.
• Lead high-visibility analytics projects across BI functional areas from initiation through delivery, including stakeholder engagement, project charters and A3s, timelines, requirements gathering and validation, and business-value definition.
• Develop functional and technical specifications that translate complex requirements into robust solution designs.
• Design, develop, and modernize scalable enterprise analytics solutions across SAP and non-SAP platforms, including SAP BW/4HANA, SAP BDC, SAP Datasphere, Snowflake, AWS services, Tableau, Power BI, and Data Lakehouse architectures.
• Apply Data as a Product, Hub-and-Spoke, and Data Mesh modeling principles, and develop governed, reusable data products that enable enterprise analytics and self-service reporting.
• Design and build scalable ELT/ETL pipelines using AWS Glue, SAP Data Services (BODS), SAP SDI, SQL, Python, and cloud-native integration services.
• Create governed semantic models and reusable business data layers that support self-service analytics, natural language querying, and consistent KPIs across reporting platforms.
• Develop and maintain modernization roadmaps for transitions from SAP BW on HANA to SAP BDC, SAP Datasphere, AWS Data Lakehouse, and modern self-service analytics platforms.
• Design AI-ready data architectures for large language models, retrieval-augmented generation (RAG), semantic search, and conversational analytics.
• Evaluate and implement AI-powered analytics, including natural language queries, Copilot-enabled analytics, and advanced decision-support solutions.
• Work with business stakeholders to identify generative AI, machine learning, and predictive analytics opportunities that can improve operational efficiency and business outcomes.
• Maintain solution validation and technical and functional documentation, and ensure change management and approval processes are completed.
• Measure realized business value and conduct lessons learned.
• Connect SAP BW with SAP and third-party analytics tools to improve usability and process efficiency.
• Advise team members on development and testing proposals across the analytics stack.
• Partner with functional architects and business analysts to address end-to-end analytics needs, and support analysts as needed with non-SAP business systems.
• Support a data-driven decision-making culture, analytics roadmaps, and audit requests.
• Mentor team members and functional analysts on best practices.
• Monitor analytics trends and best practices, and identify opportunities to optimize solutions.

Technologies:

• AI
• AWS
• AWS Glue
• Architect
• Cloud
• Copilot
• ETL
• ERP
• Support
• Machine Learning
• Power BI
• Python
• RAG
• SAP BW/4HANA
• SAP
• SAP Analytics Cloud
• SAP BDC
• SAP Datasphere
• SQL
• Security
• Snowflake
• Tableau
• Ada

More

We are A. O. Smith, a global manufacturer of residential and commercial water heating equipment and boilers, as well as water treatment products for residential and light commercial use. We apply innovative technologies and energy-efficient solutions to products marketed worldwide. Headquartered in Milwaukee, Wisconsin, we have approximately 12,000 employees across operations in the United States, Canada, China, India, Mexico, the Netherlands, and the United Kingdom. This hands-on BI and Analytics Solutions Architect and subject matter expert role partners with business stakeholders and technology teams to shape scalable analytics solutions, manage project deliverables, and deliver measurable business outcomes across cross-functional teams. The position is hybrid. We offer competitive compensation and benefits including medical and dental insurance, company-sponsored life insurance, retirement savings, short- and long-term disability programs, and tuition assistance. We consider applicants without regard to protected characteristics and provide reasonable accommodations to qualified individuals with disabilities.

last updated 43 week of 2026