OneStream Architect

Careerwebsite; Nashville, Northern (TN, KY); Hybrid; USD 140,000 - 230,000; Full time

Benefits offered by this job

Medical and dental insurance

Retirement security savings plan

Disability programs

Tuition assistance

Job summary

A. O. Smith is seeking a highly experienced OneStream Architect to lead the enterprise-wide OneStream implementation for planning, consolidation, and account reconciliation.

You will be the sole owner and administrator of the platform post go-live, ensuring stability, scalability, and alignment with evolving business needs. This role requires collaboration with the Systems Integrator during implementation and full accountability thereafter, including governance, compliance, and seamless daily

Qualifications

• 10+ years related software/industry experience with strong preference in extensive knowledge/experience in OneStream.
• Strong understanding of financial processes (FP&A, close, reconciliation).
• Experience with SAP BW, Power BI, and enterprise data integration.
• Advanced skills in Excel, Word, and Visio.
• Excellent communication, documentation, and stakeholder engagement skills.

Responsibilities

• Lead technical design and configuration in partnership with the Systems Integrator.
• Translate business requirements into scalable, maintainable OneStream solutions.
• Oversee data integration with SAP ERP and other source systems.
• Participate in design reviews, testing cycles, and deployment planning.
• Ensure adherence to enterprise architecture and security standards.
• Administer all OneStream environments (Production, Development, Sandbox).
• Manage metadata, hierarchies, and dimensional structures.
• Execute and monitor data loads; troubleshoot integration issues.
• Maintain and enhance data pipelines and connector configurations.
• Serve as primary OneStream support contact and issue resolution.
• Provide guidance to finance users and power users.
• Validate tests when upstream changes occur.
• Migrate changes after CAB approval.

Skills

OneStream architecture

FP&A processes

Stakeholder communication

Data integration

Education

Bachelor’s degree in Information Systems

Finance related field

Tools

SAP BW

Power BI

Excel

Visio

Job 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

A. O. Smith is seeking a highly experienced and technically proficient OneStream Architect to lead the enterprise-wide implementation of OneStream for planning, consolidation, and account reconciliation. This individual will serve as the sole owner and administrator of the OneStream platform post go-live, ensuring its stability, scalability, and alignment with evolving business needs. This role is critical to the success of our financial transformation strategy and will require close collaboration with our Systems Integrator during implementation and full accountability for the platform thereafter.

Responsibilities

Implementation Phase

• Lead technical design and configuration in partnership with the Systems Integrator.
• Translate business requirements into scalable, maintainable OneStream solutions.
• Oversee data integration with SAP ERP and other source systems.
• Participate in design reviews, testing cycles, and deployment planning.
• Ensure adherence to enterprise architecture and security standards.

Post Go-Live: Daily Operations & Maintenance

• Administer all OneStream environments (Production, Development, Sandbox).
• Manage metadata, hierarchies, and dimensional structures.
• Execute and monitor scheduled and ad hoc data loads.
• Troubleshoot and resolve integration and transformation logic issues.
• Maintain and enhance data pipelines and connector configurations.
• Serve as the primary contact for OneStream support and issue resolution.
• Provide technical guidance to finance users and power users.
• Validate and test OneStream processes when changes occur in upstream/downstream systems.
• Copy the data from Production to Non-production environment to make sure new changes are tested with the correct data.
• Prepare the test scenarios and scripts for the testing
• Represent the changes to CAB and migrate changes after approval

Governance & Compliance

• Maintain system documentation, configuration logs, and control matrices.
• Ensure SOX compliance and support internal/external audits.
• Manage user roles, security groups, and access controls.
• Monitor system performance and proactively address issues.

Qualifications

• Bachelor’s degree in Information Systems, Finance, or related field.

• 10+ years related software/industry experience with strong preference in extensive knowledge/experience in OneStream.

• Strong understanding of financial processes (FP&A, close, reconciliation).

• Experience with SAP BW, Power BI, and enterprise data integration.
• Advanced skills in Excel, Word, and Visio.
• Excellent communication, documentation, and stakeholder engagement skills.

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.