Data Warehouse SME

OVERVIEW:

We are seeking a highly experienced Information Technology/Data Warehousing Subject Matter Expert to support an enterprise-scale migration of legacy data into a secure commercial cloud solution. The selected candidate will play a key role on our technical team and will participate in the architecture, design, deployment, validation, and transition of legacy systems and data into a new secure, scalable, cloud-based data platform. The selected candidate will oversee the successful migration into the new data platform, ensure accessibility in the modernized system, and maintain secure handling of all sensitive information throughout the migration lifecycle. This role requires working onsite in customer spaces and regularly interfacing with government personnel at all levels. The ideal candidate will have a solid background in enterprise IT networks, data engineering, data migration, and secure cloud solutions within federal government environments.

This position requires active Top Secret (TS) clearance and the ability to obtain SCI access with a CI polygraph. This position is on-site with our customer in Huntsville, Alabama, and cannot be supported remotely.

REQUIRED QUALIFICATIONS:

• Bachelors Degree in Information Technology, Computer Science, or related field of study; or in lieu of education, five (5) years of additional documented experience that addresses all requirements of the position.
• Minimum of 8 years of experience in Information Technology, Data Engineering, or Data Warehousing.
• Demonstrated expertise supporting successful large-scale, enterprise modernization or migration projects, preferably in a federal government environment.
• Senior-level expertise in system modernization, data migration, data engineering, and engineering database systems.
• Experience performing accurate, secure, and seamless migration of sensitive data from multiple legacy systems into a modern cloud-based environment.
• Experience analyzing and extracting data, metadata, and user-applied markings from legacy applications and underlying storage solutions.
• Expertise designing and engineering storage solutions for both legacy and modern architectures.
• Familiarity with on-premises and cloud-based environments, with AWS preferred.
• Experience planning and executing end-to-end data validation, quality checks, and data reconciliation.
• Excellent verbal and written communication skills with the ability to clearly document requirements, findings, risks, and recommendations.
• Ability to work on site in Huntsville, Alabama.
• Active Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI) and the ability to obtain a CI polygraph.

DESIRED QUALIFICATIONS:

• CompTIA Security+ , CISSP, CISM, or other industry standard certs.
• Working knowledge of operating systems, network security, and application security to support secure cloud implementations.
• Experience assessing and documenting results for systems, infrastructure, and applications in on- premises and cloud environments.
• Familiarity with data, metadata structures, and user-applied data markings or dissemination controls.
• Experience implementing auditability, lineage tracking, and traceability for migrated datasets.
• Strong understanding of security controls, risk mitigation, incident response, configuration management, and continuous monitoring practices.
• Experience with secure data transport mechanisms or multi-domain data handling considerations.

CLEARANCE REQUIREMENT:

• Active Top Secret (TS) clearance with eligibility for Sensitive Compartmented Information (SCI) and the ability to obtain a CI polygraph.