OneStream Architect: Finance Transformation Lead & Admin

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

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.