OneStream Architect

A. O. Smith Corporation; Oregon; Hybrid; USD 150,000 - 210,000; Full time

Benefits offered by this job

Medical and dental insurance

Retirement plan

Company-sponsored life insurance

Disability programs

Tuition assistance

Job summary

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

You will own and administer the platform after go-live, ensuring stability, scalability, and alignment with evolving business needs. Collaborate with the Systems Integrator during implementation and take full accountability for ongoing operations, governance, and compliance.

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.

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 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 ensure changes tested with correct data.
• Prepare the test scenarios and scripts for testing.
• Represent the changes to CAB and migrate changes after approval.
• 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.

Skills

FP&A knowledge

Financial processes

Communication

Stakeholder engagement

Education

Bachelor's degree in Information Systems, Finance, or related field

Tools

SAP BW

Power BI

Excel (Advanced)

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.