> Markdown version of [/jobs/ext/3095030-onestream-federal-data-architect](https://www.wearedevelopers.com/jobs/ext/3095030-onestream-federal-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# OneStream Federal Data Architect

- **Company:** Andrew Morgan
- **Location:** Washington, DC, United States
- **Experience:** Expert
- **Contract:** Permanent contract
- **Skills:** Accounting Systems, Microsoft Azure, C Sharp (Programming Language), Information Systems, Data Architecture, Information Engineering, Data Governance, Data Integration, Extract Transform Load (ETL), Relational Databases, Network Interface Controllers, Microsoft SQL Server, Visual Basic .NET (Programming Language), Open Database Connectivity, Oracle (Applications), Performance Tuning, Cloud Services, OneStream, SAP (Applications), SQL Databases, SQL Server Integration Services, Systems Integration, Technical Data Management Systems, File Transfer Protocol (FTP), Azure Data Factory, Information Technology, Data Management, Api Design, Restful APIs
- **Published:** September 26, 2026
- **Apply:** https://www.dcjobsite.com/job.asp?id=3405605477&tx=KR2121FFG&pt=1&aff=0B19D771-A501-4A5E-8338-2A822B784D54&utm_source=Job%20Feed&utm_medium=textkernel&utm_campaign=DE&utm_term=0B19D771-A501-4A5E-8338-2A822B784D54

## About the Role

* At least 8 years of total professional experience in data architecture, data engineering, ETL development, or enterprise performance management (EPM) solutions.
 * Hands-on experience designing and implementing data integrations within OneStream (via REST API, SFTP, ODBC, Smart Integration Connector-SIC, Flat files), including Data Management, Connectors, transformation rules, and Workflow.
 * Demonstrated ETL experience using tools such as OneStream Data Management, SQL Server Integration Services (SSIS), Informatica, Azure Data Factory, or comparable platforms.
 * Strong proficiency in SQL and relational database design, with experience in Microsoft SQL Server or similar environments.
 * Experience developing OneStream business rules in VB.NET or C#.
 * Experience supporting federal government clients, preferably within DoW, 4th Estate or Federal Civilian Agencies.
 * Working knowledge of federal financial management concepts, including appropriations, budget formulation and execution, and the PPBE process.
 * Excellent written and verbal communication skills, with the ability to explain technical concepts to non-technical stakeholders.
 * U.S. citizenship and the ability to obtain and maintain a Public Trust or Secret security clearance., * OneStream OCA or OCP Certification
 * Familiarity with DoW financial systems and data standards, including the Standard Line of Accounting (SLOA) and audit readiness requirements (FIAR).
 * Experience with cloud data platforms (Azure preferred) and API-based integrations.
 * Bachelor's degree in Computer Science, Information Systems, Finance, or a related field; advanced degree a plus.

## Description

* Design and maintain the end-to-end data architecture for OneStream implementations, including dimensional models, data sources, transformation rules, and integration workflows aligned to federal budget and appropriation structures.
 * Develop, optimize, and document ETL processes that extract, transform, and load data from federal financial and ERP systems (e.g., GFEBS, DAI, Oracle, SAP, Momentum or legacy accounting systems) into OneStream.
 * Build and manage OneStream Data Management jobs, Connectors, Workflow profiles, and transformation rule sets to ensure accurate, timely, and auditable data loads.
 * Author and maintain business rules and scripts (VB.NET and/or C#) and SQL queries supporting data integration, validation, and automation.
 * Establish data quality, reconciliation, and validation controls that support audit readiness and traceability of financial data from source to report.
 * Map federal financial data elements, including appropriations, program elements, funds, object classes, and cost centers, into OneStream metadata and dimension hierarchies.
 * Collaborate with functional leads, budget analysts, and client stakeholders to translate business requirements into scalable technical data designs.
 * Produce technical documentation, including data flow diagrams, interface control documents, mapping specifications, and runbooks for sustainment teams.
 * Support performance tuning, troubleshooting, and root-cause analysis for data load and integration issues across development, test, and production environments.
 * Provide technical guidance and mentorship to developers and analysts and contribute to design reviews and architectural decisions., * Attention to Detail: Produce high-quality deliverables and outputs that align with contract outcomes.
 * Self-Sufficiency: Execute tasks independently, seeking client assistance only after internal resources are exhausted, ensuring requests align with contract goals.
 * Teamwork: Collaborate effectively with team members, including AMC resources, subcontractors, and government stakeholders.
 * Communication/Engagement: Maintain professional conduct in meetings and written communication, participating actively with cameras on.
 * Responsiveness: Stay engaged, communicate promptly, and ensure deadlines are consistently met.