OneStream Data Architect

Job Summary

To support federal clients, the full-time remote OneStream Federal Data Architect will design and maintain data architecture for financial management solutions, focusing on data integration strategies and ETL processes while ensuring compliance with federal financial standards.

Key responsibilities:

• Design and maintain end-to-end data architecture for OneStream implementations, including dimensional models and integration workflows
• Develop, optimize, and document ETL processes for data extraction from federal financial and ERP systems into OneStream
• Collaborate with stakeholders to translate business requirements into scalable technical data designs and produce technical documentation

Required qualifications:

• At least 8 years of experience in data architecture, data engineering, or ETL development
• Hands-on experience with OneStream data integrations, including Data Management and transformation rules
• Strong proficiency in SQL and relational database design, preferably in Microsoft SQL Server
• Experience developing OneStream business rules in VB.NET or C#
• Knowledge of federal financial management concepts and experience supporting federal government clients