OneStream Federal Data Architect

• 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.

• 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.

Salary is commensurate with both location and experience., * 15 days of Paid Time Off + 11 Paid Federal Holidays

• 401K Program (up to 4% employer matching)
• Three Gold Healthcare Options (with 75%-90% employer-paid premiums)
• Flexible Spending Account / Dependent Care Assistance Program
• Employer-Paid Short Term Disability Insurance
• Employer-Paid Long Term Disability Insurance
• Employer-Paid Life Insurance
• Professional Training and Development
• Corporate Team Building Events
• And MORE!

Andrew Morgan LLC, founded in 2017 and headquartered in Alexandria, VA, is a Service-Disabled Veteran Owned Small Business (SDVOSB) and a certified HUBZone Small Business. We specialize in delivering high-quality consulting services to both federal and commercial clients, offering expertise in Strategy and Management Consulting, Technology & Architecture Services, and Industry & Mission Analytics Solutions. Our distinguished clientele includes the Department of Veterans Affairs (VA), National Aeronautics and Space Administration (NASA), the Department of Defense (DoD), and the United Stated Army Corps of Engineers (USACE). We are committed to providing innovative solutions and exceptional service to support our clients’ missions and objectives.