Senior Enterprise Data Architect, NF5

Summary

Marine Corps Community Services (MCCS) is looking for the best and brightest to join our Team! MCCS is a comprehensive program that supports and enhances the quality of life for Marines, their families, and others in the Marine Corps Community. We offer a team oriented environment comprised of military personnel, civilian employees, contractors and volunteers who keep the organization functioning smoothly and effectively.

Duties

The Senior Enterprise Data Architect directly supports the Senior Data Scientist and Business Intelligence (BI) Manager by providing technical leadership for the design, modernization, and migration of enterprise data integration platforms supporting federal and public sector programs. As a critical redundancy and continuity layer for Marine Corps Community Services (MCCS), this role establishes the enterprise data model, defines integration strategies, and ensures rigorous data lineage across all organizational systems. The incumbent leads the design and maintenance of the enterprise data model, defining how data entities relate across all MCCS systems. This includes performing foundational schema design and database normalization to support both current environments and future enterprise technology stacks. The role is responsible for maintaining current state and future state architecture artifacts required for compliance, continuity, and system onboarding, while also providing critical architectural coverage for enterprise financial, operational, and customer data systems. The Senior Enterprise Data Architect defines the enterprise data integration architecture, detailing how data moves between source systems, the data lake, and downstream reporting environments. The role includes architecting, developing, and optimizing complex ETL and ELT pipelines using Oracle Data Integrator (ODI) and Amazon Web Services (AWS) Glue. The incumbent analyzes and modernizes legacy ODI mappings, packages, workflows, and Cognos reports, converting them into cloud native solutions that support modernization efforts. This position is responsible for establishing and documenting enterprise data lineage to ensure full traceability of data origins, transformations, and destinations in accordance with Department of Defense (DoD) compliance requirements, including NIST, FISMA, the Privacy Act, and HIPAA. Additionally, the incumbent defines technical specifications for ETL and ELT pipelines, including transformation logic and data quality rules at the architectural layer. The incumbent serves as the primary technical authority for contractor deliverables and major enterprise data contracts, ensuring all proposed solutions align with MCCS standards and long-term architectural requirements. The role evaluates contractor architectural proposals, validates technical performance, and reviews integration designs to prevent long term technical debt or system failures. The Senior Enterprise Data Architect partners closely with the Data Governance Supervisor and Contracting Officer to assess technical scope expansions, resolve vendor performance failures, and ensure all contractor provided data solutions meet quality, security, and compliance expectations. This role leads the planning and execution of data migration efforts from on premise and legacy environments to AWS. This includes working directly with external technology providers to map legacy data structures to the new enterprise data model and ensuring that no data assets are lost or orphaned during the transition. The role defines migration strategies, cutover plans, and rollback procedures consistent with federal change management standards and validates data integrity, accuracy, completeness, and performance throughout and after migration activities. The incumbent designs data architectures that comply with federal frameworks and regulatory controls such as FISMA, NIST, and FedRAMP aligned environments. The role implements appropriate data access controls, encryption standards and logging consistent with agency requirements and supports Authority to Operate (ATO) documentation by providing required architectural inputs and technical artifacts. Provides World Class Customer Service with an emphasis on courtesy. Assists customers and communicates positively in a friendly manner. Takes action to solve problems quickly. Alerts the higher-level supervisor, or proper point of contact for help when problems arise. Adheres to safety regulations and standards. Promptly reports any observed workplace hazards, and any injury, occupational illness, and/or property damage resulting from workplace mishaps to the immediate supervisor. Adheres to established standards of actively supporting the principles of the EEO program and prevention of sexual harassment. May work a fluctuating work schedule to complete work assignments outside of the typical work week and work hours. May travel to complete work assignments. Performs other duties as assigned. This is a white-collar position where occasional lifting up to 20 lbs. may be required.

Qualifications

Eight or more years of progressively responsible experience in data architecture, data engineering, enterprise data integration, or related technical leadership in a large, complex, or regulated organization. An equivalent combination of relevant education, training, and experience may substitute for a portion of the experience. Experience must demonstrate the ability to analyze and modernize enterprise ETL/ELT workflows, including Oracle Data Integrator (ODI) mappings and packages; design or implement data pipelines with AWS Glue or comparable cloud integration services; and plan or support migration of data from legacy systems to AWS or a comparable cloud environment. Applicants must demonstrate advanced SQL, database normalization, enterprise data modeling, ETL and ELT patterns, data validation and reconciliation, data lineage, operational monitoring, change control, and technical documentation. Working knowledge of relevant AWS services (S3, RDS, Redshift, IAM, and CloudWatch) and analytics platforms such as Snowflake and MicroStrategy is required. Candidates must demonstrate the ability to assess technical designs and contractor deliverables against documented architecture, security, and performance requirements, and communicate findings to stakeholders. Certifications may document skills but are not required unless applicable workforce or system access rules designate one. As an authorized and privileged user of Department of Defense Information Systems, the applicant must possess or obtain required Information Assurance awareness by completing the DoD8570/DoD8140 requirements (i.e. Security+ Certification) as a condition of access within six months of employment and thereafter in accordance with DoD requirements.

Requirements

See Duties and Qualifications