Senior Enterprise Data Architect, NF5

U.S. Marine Corps•Quantico, VA

About The Position

The Senior Enterprise Data Architect provides technical leadership for designing, modernizing, and migrating enterprise data integration platforms supporting federal and public sector programs. The position supports the Senior Data Scientist and Business Intelligence Manager and establishes the enterprise data model, integration strategies, and data lineage across MCCS systems. It provides architectural coverage for enterprise financial, operational, and customer data systems and maintains current- and future-state architecture artifacts for compliance, continuity, and system onboarding. The role defines enterprise data integration architecture and designs, develops, and optimizes ETL and ELT pipelines using Oracle Data Integrator (ODI) and AWS Glue. It modernizes legacy ODI mappings, packages, workflows, and Cognos reports into cloud-native solutions, documents data lineage, and defines pipeline specifications, transformation logic, and data-quality rules. The architect also serves as the primary technical authority for contractor deliverables and major enterprise data contracts, assessing proposals, performance, integration designs, and technical scope with internal stakeholders. The position leads data migration planning and execution from on-premises and legacy environments to AWS, including legacy-to-enterprise-model mapping, cutover and rollback plans, and validation of data integrity, accuracy, completeness, and performance. It designs architectures aligned with federal security and regulatory frameworks, implements appropriate access controls, encryption, and logging, and provides architectural inputs and technical artifacts for Authority to Operate documentation. The role also provides courteous customer service, follows workplace safety and equal employment opportunity standards, and may work a fluctuating schedule outside typical workdays or hours and travel to complete assignments. Other duties may be assigned. Occasional lifting of up to 20 pounds may be required.

Requirements

At least eight years of progressively responsible experience in data architecture, data engineering, enterprise data integration, or related technical leadership in a large, complex, or regulated organization; a relevant combination of education, training, and experience may substitute for part of the experience.
Experience analyzing and modernizing enterprise ETL/ELT workflows, including ODI mappings and packages.
Experience designing or implementing data pipelines with AWS Glue or comparable cloud integration services.
Experience planning or supporting migration of data from legacy systems to AWS or a comparable cloud environment.
Advanced SQL skills and knowledge of database normalization, enterprise data modeling, ETL/ELT patterns, data validation and reconciliation, data lineage, operational monitoring, change control, and technical documentation.
Working knowledge of AWS S3, RDS, Redshift, IAM, and CloudWatch.
Working knowledge of analytics platforms such as Snowflake and MicroStrategy.
Ability to assess technical designs and contractor deliverables against documented architecture, security, and performance requirements and communicate findings to stakeholders.
Must possess or obtain required DoD8570/DoD8140 Information Assurance awareness, such as Security+ certification, within six months of employment and maintain it as required for access to Department of Defense Information Systems.
Successful completion of a National Agency Check and Inquiries (NACI) is required for employment.
Submit a resume of no more than two pages.

Responsibilities

Lead the design and maintenance of the enterprise data model, including data-entity relationships, schema design, and database normalization.
Define enterprise data integration architecture and document how data moves from source systems through the data lake to downstream reporting environments.
Architect, develop, and optimize ETL and ELT pipelines using Oracle Data Integrator (ODI) and AWS Glue.
Analyze and modernize legacy ODI mappings, packages, workflows, and Cognos reports into cloud-native solutions.
Establish and document data lineage, including origins, transformations, and destinations, in accordance with applicable compliance requirements.
Define technical specifications for ETL and ELT pipelines, including transformation logic and data-quality rules.
Serve as the primary technical authority for contractor deliverables and major enterprise data contracts; evaluate proposals, technical performance, and integration designs.
Partner with the Data Governance Supervisor and Contracting Officer to assess technical scope expansions, address vendor performance failures, and ensure contractor solutions meet quality, security, and compliance expectations.
Plan and execute migrations from on-premises and legacy environments to AWS, including mapping legacy structures to the enterprise data model.
Define migration strategies, cutover plans, and rollback procedures, and validate data integrity, accuracy, completeness, and performance during and after migration.
Design architectures that comply with federal frameworks and regulatory controls, implement data access controls, encryption, and logging, and provide technical artifacts for ATO documentation.
Provide courteous customer service, communicate positively, resolve problems promptly, and alert the appropriate supervisor or contact when assistance is needed.
Adhere to safety regulations and standards and promptly report workplace hazards, injuries, occupational illnesses, and property damage.
Support EEO principles and the prevention of sexual harassment.
Travel or work a fluctuating schedule outside typical workdays and hours when needed to complete assignments.
Perform other duties as assigned.