Data & Analytics Solutions Architect

A. O. Smith Corporation•Nashville, TN

1d•Hybrid

About The Position

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.

Requirements

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.

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
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.