Cloud Architect

Team (Organization) Introduction 
9th Way Insignia is looking for a Cloud Architect to support an enterprise data warehouse, leading the migration of a large enterprise Oracle database and data warehouse from a legacy on-premises environment to the Oracle Federal Cloud. This role provides technical architecture and delivery leadership across planning, readiness assessment, execution, and cutover—ensuring the migrated solution meets FedRAMP-aligned requirements, preserves continuity of existing ETL and integrations, and supports mission reporting needs across platforms such as OBIEE, Tableau, and Power BI. The Cloud Architect will coordinate stakeholders, drive technical decision-making, manage risks and dependencies, and ensure migration outcomes are operationally supportable in a regulated VA environment. 

Responsibilities 

• Lead architecture and execution planning and implementation for the EDW Oracle migration to Oracle Federal Cloud, ensuring a secure, scalable, and supportable target-state design. 

• Conduct and coordinate legacy environment readiness assessments (database, infrastructure, integrations, security, operations) and drive remediation actions required to make systems migration-ready. 

• Define, develop and maintain target cloud architecture artifacts, including environment designs, networking and connectivity patterns, security controls, identity/access considerations, and operational supportability requirements. 

• Ensure security and compliance requirements are incorporated into the architecture and delivery approach, including FedRAMP-aligned controls, auditability, and documentation discipline and address deviations. 

• Coordinate preservation and validation of existing ETL processes and integrated data flows during and after migration, including dependencies on Informatica and Oracle GoldenGate. 

• Lead architecture planning and execution for integrated systems that send/receive data to the EDW, ensuring continuity of interfaces, data quality, and minimal disruption during transition. 

• Drive performance and reporting continuity planning, including efforts to optimize materialized views and ensure reporting tools (OBIEE, Tableau, Power BI) continue to function as expected. 

• Lead cutover architecture and execution readiness, including rollback strategy, stakeholder readiness, post-migration validation, and stabilization to ensure mission continuity. 

• Drive technical risk, issue, and decision management; facilitate architecture reviews and working sessions; document outcomes; and ensure actions are tracked to closure. 

• Partner with engineering, data, security, and operations teams to ensure migration deliverables are complete, tested, documented, and operationally supportable. 

• This position may perform other duties as assigned. The responsibilities listed above are representative and not intended to be all-inclusive. 

Requirements 

• Demonstrated experience leading large enterprise Oracle database and data warehouse migrations to cloud environments, specifically Oracle Federal Cloud. 

• Proven experience designing and delivering cloud solutions in regulated environments with security/compliance constraints (including FedRAMP-aligned requirements and audit-ready documentation practices). 

• Experience evaluating legacy databases and integrated systems and identifying/leading the remediation needed to enable successful cloud migration while maintaining operational continuity. 

• Strong understanding of enterprise data integration and ETL operations, including maintaining existing pipelines and dependencies leveraging Informatica and Oracle GoldenGate. 

• Working knowledge of data warehouse performance considerations, including materialized view optimization and support for downstream reporting platforms (OBIEE, Tableau, Power BI). 

• Strong leadership and execution skills across architecture governance, technical decision-making, risks/issues, dependencies, and stakeholder communications. 

• Ability to obtain and maintain a VA Public Trust clearance (Tier 2, Moderate Risk). 

• Ability to work remote, with up to 10% travel to customer locations as required. 

Preferred / Desired 

• Prior experience supporting VA programs, including familiarity with VA data structures and enterprise database environments. 

• Experience architecting cloud migration cutovers for mission-critical reporting systems with tight availability and performance requirements. 

• Experience with Oracle cloud migration tooling/approaches and structured migration frameworks (assessment → remediation → migration → validation → stabilization). 

• Relevant certifications such as Oracle Cloud, cloud architecture credentials, and/or security-focused certifications.