OneStream Solutions Architect at Acuity in Atlanta, GA | USD150,900-271,600 | Kablio

Role

Description

onestream implementation

financial modeling

etl design

scripting

dashboard development

data integration

Lead implementation teams and manage project timelines.
Build and maintain complex financial models using OneStream capabilities (consolidation, budgeting, forecasting, reporting).
Define and configure 2-way ETL processes, ensuring data integrity during migration and transformation.
Implement scripting (e.g., VB.NET or JavaScript) for advanced customization.
Develop custom dashboards, reports, and analytics.
Collaborate with finance, product management, and program management teams to gather requirements.
Support business development through solution demos and proposals.
Configure allocations for cost and revenue distribution across entities.
Utilize OneStream extensibility features (business rules, workflows, Smart View).
Design, configure, and implement OneStream solutions based on business requirements.
Implement driver-based forecasting models to support predictive planning.
Translate business needs into technical solutions and workflows.
Provide quality assurance and best practices for OneStream deployments.
Lead architecture and design discussions for new implementations and upgrades.
Enable drill-through capabilities for detailed transactional analysis from summary reports.
Prepare and execute data flow architecture and validation strategies.
Integrate OneStream with ERP, CRM, and data warehouses.
Conduct workshops, training sessions, and provide ongoing support.

Requirements

vb.net

onestream

bachelor

5+ years

ai/ml

onestream certified

Expertise with scripting languages (VB.NET, SQL, JavaScript).
Experience in AI/ML-based analytics and predictive modeling (a plus).
Advanced Configuration
Strong understanding of enterprise architecture and financial data models.
A Bachelor’s degree in Accounting, Finance, MIS, Computer Science, or related field.
Ability to lead client workshops and provide strategic guidance.
Technical Skills: Proficiency in OneStream workflows, cube views, drillable dashboards, and security.
5+ years of experience in financial systems implementation, with at least 2–6 years in OneStream.
Expertise in metadata concepts (cubes, hierarchies, dimensions, including extensibility).
Strong knowledge of financial consolidation, budgeting, and forecasting processes.
Certifications (Preferred): OneStream Certified Professional – Lead Architect.
Experience with data integration tools and transformations.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Revenue $3.8b

Annual Revenue 2023

The company generates approximately $3.8 billion in annual revenue (2023).

Formed 2001

Year of Reinvention

The company was reinvented as Acuity Brands in 2001, pivoting into lighting and smart building technology.

Acquired 2015

Strategic Acquisitions

The company has made significant strategic acquisitions, including Distech in 2015.

Expansion 2021

Global Expansion

The company expanded its global presence with the acquisition of OSRAM DS in 2021.

Generates roughly $3.8 billion in annual revenue (2023), trading publicly under ticker AYI.
Designs and manufactures luminaires, lighting controls, power supplies, skylights and integrated systems.
Typical projects span new‑build and retrofit installations in commercial offices, industrial facilities, institutional campuses, transportation infrastructure and homes.
Under brands like Lithonia, Holophane, Juno and nLight, it blends LED innovation with IoT‑enabled controls.
Stands out with its Atrius IoT platform and a unique combo of lighting, building analytics and smart controls—blurring lines between hardware and software.

Culture + Values

We value transparency and open communication.
We strive to foster a culture of inclusion and respect.
We encourage a growth mindset and constant learning.
We prioritize customer satisfaction and focus on delivering results.
We embrace innovation and challenge the status quo.

Environment + Sustainability

2040 Target

Net Zero Goal

Committed to achieving net zero greenhouse gas emissions across operations and value chain by 2040.

Efficiency initiatives reduce energy consumption in operations.
Renewable energy sources power their operations.
Sustainability is integral to product development and design.

Inclusion & Diversity

Everyone feels valued in an inclusive culture.
Specific goals have been set to increase gender diversity within leadership roles.
Gender diversity in the workforce is tracked and reported.
Equal opportunity is promoted in hiring and career development.

Articles

About Us

Careers

Role

Description

onestream implementation

financial modeling

etl design

scripting

dashboard development

data integration

Lead implementation teams and manage project timelines.
Build and maintain complex financial models using OneStream capabilities (consolidation, budgeting, forecasting, reporting).
Define and configure 2-way ETL processes, ensuring data integrity during migration and transformation.
Implement scripting (e.g., VB.NET or JavaScript) for advanced customization.
Develop custom dashboards, reports, and analytics.
Collaborate with finance, product management, and program management teams to gather requirements.
Support business development through solution demos and proposals.
Configure allocations for cost and revenue distribution across entities.
Utilize OneStream extensibility features (business rules, workflows, Smart View).
Design, configure, and implement OneStream solutions based on business requirements.
Implement driver-based forecasting models to support predictive planning.
Translate business needs into technical solutions and workflows.
Provide quality assurance and best practices for OneStream deployments.
Lead architecture and design discussions for new implementations and upgrades.
Enable drill-through capabilities for detailed transactional analysis from summary reports.
Prepare and execute data flow architecture and validation strategies.
Integrate OneStream with ERP, CRM, and data warehouses.
Conduct workshops, training sessions, and provide ongoing support.

Requirements

vb.net

onestream

bachelor

5+ years

ai/ml

onestream certified

Expertise with scripting languages (VB.NET, SQL, JavaScript).
Experience in AI/ML-based analytics and predictive modeling (a plus).
Advanced Configuration
Strong understanding of enterprise architecture and financial data models.
A Bachelor’s degree in Accounting, Finance, MIS, Computer Science, or related field.
Ability to lead client workshops and provide strategic guidance.
Technical Skills: Proficiency in OneStream workflows, cube views, drillable dashboards, and security.
5+ years of experience in financial systems implementation, with at least 2–6 years in OneStream.
Expertise in metadata concepts (cubes, hierarchies, dimensions, including extensibility).
Strong knowledge of financial consolidation, budgeting, and forecasting processes.
Certifications (Preferred): OneStream Certified Professional – Lead Architect.
Experience with data integration tools and transformations.

Benefits

Information not given or found

Training + Development

Information not given or found

Interview process

Information not given or found

Visa Sponsorship

Information not given or found

Security clearance

Information not given or found

Company

Overview

Revenue $3.8b

Annual Revenue 2023

The company generates approximately $3.8 billion in annual revenue (2023).

Formed 2001

Year of Reinvention

The company was reinvented as Acuity Brands in 2001, pivoting into lighting and smart building technology.

Acquired 2015

Strategic Acquisitions

The company has made significant strategic acquisitions, including Distech in 2015.

Expansion 2021

Global Expansion

The company expanded its global presence with the acquisition of OSRAM DS in 2021.

Generates roughly $3.8 billion in annual revenue (2023), trading publicly under ticker AYI.
Designs and manufactures luminaires, lighting controls, power supplies, skylights and integrated systems.
Typical projects span new‑build and retrofit installations in commercial offices, industrial facilities, institutional campuses, transportation infrastructure and homes.
Under brands like Lithonia, Holophane, Juno and nLight, it blends LED innovation with IoT‑enabled controls.
Stands out with its Atrius IoT platform and a unique combo of lighting, building analytics and smart controls—blurring lines between hardware and software.

Culture + Values

We value transparency and open communication.
We strive to foster a culture of inclusion and respect.
We encourage a growth mindset and constant learning.
We prioritize customer satisfaction and focus on delivering results.
We embrace innovation and challenge the status quo.

Environment + Sustainability

2040 Target

Net Zero Goal

Committed to achieving net zero greenhouse gas emissions across operations and value chain by 2040.

Efficiency initiatives reduce energy consumption in operations.
Renewable energy sources power their operations.
Sustainability is integral to product development and design.

Inclusion & Diversity

Everyone feels valued in an inclusive culture.
Specific goals have been set to increase gender diversity within leadership roles.
Gender diversity in the workforce is tracked and reported.
Equal opportunity is promoted in hiring and career development.

Articles

About Us

Careers