OneStream Federal Data Architect
Core
Design, build, and sustain the data foundation for enterprise financial management solutions supporting federal clients, including the Department of War and Federal Civilian Agencies.
Role type
Senior IC OneStream Federal Data Architect
Builds
ETL pipelines, dimensional structures, and data integration workflows for OneStream budget formulation, execution, and reporting processes
Domain
Federal government financial management and enterprise performance management (EPM)
Deliverable
production ML models | product features | dashboards & analysis | infrastructure
Required skills
OneStream data management, ETL development, SQL, VB.NET/C#, federal financial data mapping, data quality controls, technical documentation, performance tuning
Preferred skills
OneStream OCA/OCP certification, cloud data platforms (Azure), API-based integrations
Technologies
OneStream, SQL Server, SSIS, Informatica, Azure Data Factory, REST API, SFTP, ODBC, Smart Integration Connector (SIC)
Responsibilities
Design end-to-end data architecture including dimensional models and transformation rules; Develop and optimize ETL processes from federal financial/ERP systems; Build and manage OneStream Data Management jobs and Connectors; Author business rules and scripts for data integration; Establish data quality and reconciliation controls; Map federal financial data elements into OneStream metadata; Collaborate with functional leads to translate requirements into technical designs; Produce technical documentation including data flow diagrams and mapping specifications; Support performance tuning and troubleshooting for data loads; Provide technical guidance and mentorship to developers and analysts
Seniority
Senior, hands-on IC with mentorship responsibilities