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. Responsibilities 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. Requirements Conditions of Employment See Duties and Qualifications EVALUATIONS: Qualifications Bachelor's degree from an accredited college or university in Computer Science, Information Systems, Engineering, Data Science, or a related field appropriate to the work of the position (Master's degree preferred) AND 6 years of experience performing data architecture, data engineering, enterprise data integration, or related technical leadership functions for a large, complex, or regulated organization OR an appropriate combination of education and experience demonstrating possession of knowledge and skill equivalent to that gained in the above, OR appropriate experience that demonstrates the applicant has acquired the knowledge, skills, and abilities equivalent to those gained in the above. Experience must include senior level expertise with ODI in large enterprise or government environments, as well as hands-on experience designing and implementing ETL/ELT pipelines using AWS Glue and leading data migrations to AWS for government or for other highly regulated environments. Applicants must possess advanced SQL, database normalization, and data modeling skills; a strong understanding of ETL versus ELT architectural patterns; and experience with major enterprise cloud services including AWS (S3, RDS, Redshift, IAM, CloudWatch), Snowflake, and MicroStrategy. Required competencies also include data validation, reconciliation, operational monitoring, change control, configuration management, and technical documentation standards. Applicants must possess or be able to obtain an advanced cloud architecture certification (e.g., AWS Solutions Architect). Highly preferred certifications include TOGAF Enterprise Architecture Certification, AWS Certified Data Engineer -Associate, AWS Certified Solutions Architect - Professional, Snowflake SnowPro Core Certification, and MicroStrategy Certified Architect. 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. Education Additional Information GENERAL INFORMATION: Applicants are assured of equal consideration regardless of race, age, color, religion, national origin, sex, GINA, political affiliation, membership or non-membership in an employee organization, marital status, physical handicap which has no bearing on the ability to perform the duties of the position. This agency provides reasonable accommodations to applicants with disabilities. If you need a reasonable accommodation for any part of the application and hiring process, please notify the agency. The decision on granting reasonable accommodation will be on a case-by-case basis. It is Department of Navy (DON) policy to provide a workplace free of discrimination and retaliation. The DON No Fear Act policy link is provided for your review: https://www.secnav.navy.mil/donhr/Site/Pages/No-Fear-Act.aspx As part of the employment process, Human Resources Division may obtain a Criminal Record Check and/or an Investigative Consumer Report. Employment is contingent upon the successful completion of a National Agency Check and Inquiries (NACI). For all positions requiring access to firearms or ammunition, the Federal Government is prohibited from employing individuals in these positions who have ever been convicted of a misdemeanor crime of domestic violence, or a felony crime of domestic violence adjudged on or after 27 November 2002. Selectees for such positions must submit a completed DD Form 2760, Qualification to Possess Firearms or Ammunition, before a final job offer can be made. Direct Deposit of total NET pay is mandatory as a condition of employment for all appointments to positions within MCCS. Required Documents: Education/certification certificate(s), if applicable. If prior military, DD214 Member Copy This activity is a Drug-free workplace. The use of illegal drugs by NAF employees, whether on or off duty, cannot and will not be tolerated. Federal employees have a right to a safe and secure workplace, and Marines, sailors, and their family members have a right to a reliable and productive Federal workforce. Involuntarily separated members of the armed forces and eligible family members applying through the Transition Assistance Program must submit a written request/statement (may be obtained from the MCCS Human Resources Office) and present ID card with "TA" stamped in red on front of card. INDIVIDUALS SELECTED FROM THIS ANNOUNCEMENT MAY BE CHANGED TO PART-TIME OR FULL-TIME AT MANAGEMENT'S DISCRETION WITHOUT FURTHER COMPETITION. ALL ONLINE APPLICATIONS MUST BE RECEIVED BY 1159PM EASTERN TIME (ET) ON THE CLOSING DATE LISTED IN THE JOB POSTING.
