Cloud Architect

9th Way Insignia•Columbia, WA

2d•Remote

About The Position

9th Way Insignia is seeking a Cloud Architect to support an enterprise data warehouse. This role will lead the migration of a large enterprise Oracle database and data warehouse from a legacy on-premises environment to the Oracle Federal Cloud. The position provides technical architecture and delivery leadership throughout the planning, readiness assessment, execution, and cutover phases. The goal is to ensure the migrated solution meets FedRAMP-aligned requirements, maintains existing ETL and integrations, and supports mission reporting needs across platforms like OBIEE, Tableau, and Power BI. The Cloud Architect will be responsible for coordinating stakeholders, driving technical decisions, managing risks and dependencies, and ensuring the migration outcomes are operationally supportable within a regulated VA environment.

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.

Nice To Haves

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.

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.