Senior IT Subject Matter Expert – Data Migration & Engineering

Data Intelligence LLC; Huntsville (AL); On-site; USD 130,000 - 190,000; Full time

Job summary

Data Intelligence LLC is seeking a Senior IT Subject Matter Expert for data migration and engineering to support a high-visibility FBI data modernization program in Huntsville, AL. You will oversee planning, architecture, and execution of large-scale data migrations, ensuring data and metadata integrity and security across legacy systems.

The role requires deep expertise in data engineering, database systems, data integration, and enterprise data platforms, with a focus on secure handling of

Qualifications

• 8+ years of professional IT experience in data migration, data engineering, or related fields.
• Experience with large-scale data migration or modernization projects.
• Strong experience with database systems, data architecture, and data integration.
• Experience with ETL/ELT, data transformation, validation, and data quality.
• Experience migrating data from multiple legacy environments and preserving data attributes.

Responsibilities

• Serve as a senior SME for data migration, data engineering, and enterprise data platforms.
• Lead planning, execution, and oversight of large-scale ELSUR/FISA data migration from legacy systems.
• Analyze legacy databases, schemas, and metadata to design migration strategies.
• Design and oversee data extraction, transformation, cleansing, validation, and loading processes.
• Ensure preservation of data, metadata, relationships, and user markings during migration.
• Validate migrated data for accuracy, integrity, and security in the new system.
• Provide guidance on database architecture, data modeling, and legacy modernization.
• Identify and resolve complex data quality and migration issues.
• Ensure secure handling of sensitive information throughout migration and testing.
• Collaborate with architects, engineers, cybersecurity, and government stakeholders.
• Develop and maintain migration plans, data mappings, and validation procedures.
• Provide senior-level risk assessments and recommendations throughout the lifecycle.

Skills

Data migration

Data engineering

Database engineering

ETL/ELT

Data integration

Data modeling

Data architecture

Problem solving

Security controls

Independent work

Job description

We are seeking a highly experienced Senior IT Subject Matter Expert (IT SME) - Data Migration & Engineering to play a critical technical role supporting a mission-critical program for the Federal Bureau of Investigation (FBI) in Huntsville, Alabama. This is an opportunity for a seasoned IT professional to work on complex, high-visibility data modernization efforts supporting sensitive federal law-enforcement systems.

In this role, you will serve as a senior technical authority responsible for the planning, architecture, engineering, execution, validation, and oversight of large-scale data migration activities. You will provide deep expertise in data engineering, database systems, data integration, legacy system modernization, and enterprise data platforms while helping transition critical ELSUR/FISA data from multiple legacy environments into a unified data platform.

Your work will directly support the secure modernization and consolidation of sensitive FBI data. You will be responsible for ensuring that data, metadata, relationships, and user-applied markings are accurately preserved throughout the migration process while maintaining data integrity, security, accessibility, and operational continuity.

This is an ideal opportunity for an IT professional who enjoys working at the intersection of data engineering, database architecture, legacy system modernization, data migration, cybersecurity, systems integration, and mission-critical federal IT.

Key Responsibilities:

• Serve as a senior technical SME for data migration, data engineering, database systems, and enterprise data platforms.
• Lead the planning, execution, and technical oversight of large-scale ELSUR/FISA data migration from legacy systems into a unified data platform.
• Analyze legacy databases, applications, storage environments, schemas, metadata, and data dependencies to develop effective migration strategies.
• Design and oversee data extraction, transformation, cleansing, validation, reconciliation, and loading processes.
• Ensure accurate preservation of data, metadata, relationships, user-applied markings, and other critical data attributes throughout migration.
• Validate migrated data for accuracy, completeness, integrity, security, and accessibility within the new system.
• Provide technical expertise in database architecture, data modeling, integration, storage, and legacy system modernization.
• Identify and resolve complex data quality, database, integration, and migration issues.
• Ensure sensitive information is securely handled throughout migration, testing, validation, and deployment.
• Collaborate with architects, engineers, cybersecurity personnel, government stakeholders, and other technical teams.
• Develop and maintain migration plans, data mappings, technical documentation, validation procedures, and test results.
• Provide senior-level technical guidance, risk assessments, and recommendations throughout the migration lifecycle.

Required Qualifications:

• 8+ years of professional IT experience in data migration, data engineering, database engineering, or related disciplines.
• Demonstrated success supporting large-scale data migration or modernization projects.
• Strong experience with database systems, data architecture, data modeling, and data integration.
• Experience with ETL/ELT, data transformation, validation, reconciliation, and data quality.
• Experience migrating data from multiple legacy applications, databases, and/or storage environments.
• Experience preserving data, metadata, relationships, markings, and other critical data attributes during migration.
• Strong analytical and problem-solving skills with experience troubleshooting complex data and database issues.
• Experience securely handling sensitive information and applying appropriate data security controls.
• Ability to work independently and collaborate with technical teams and government stakeholders.
• U.S. citizenship and ability to obtain and maintain the required U.S. government security clearance.

Preferred Qualifications:

• Experience supporting the FBI, DOJ, Intelligence Community, DoD, or other federal mission organizations.
• Experience with ELSUR, FISA, intelligence, investigative, or sensitive law-enforcement data.
• Experience with large-scale database consolidation, legacy modernization, or enterprise data platforms.
• Experience with cloud, hybrid-cloud, or modern data architectures.
• Knowledge of data governance, metadata management, data lineage, and data security.
• Experience working directly with federal government customers and technical stakeholders.
• Experience serving as a senior technical lead, architect, or SME on enterprise data programs.
• Relevant technical certifications in data engineering, databases, cloud, cybersecurity, or related fields.
• Active U.S. government security clearance.

Why This Opportunity

This is more than a traditional database or data engineering position. You will have the opportunity to apply your expertise to a highly complex data modernization effort supporting critical FBI mission requirements.

You will work alongside experienced engineers, data professionals, cybersecurity specialists, government stakeholders, system architects, and other technical experts while solving challenging problems involving legacy systems, enterprise databases, data migration, data integrity, security, and modern data platforms.

Your work will have a direct line from migration strategy and engineering to data validation, system integration, production deployment, and operational use within a mission-critical federal environment.

If you are a senior IT professional who enjoys solving difficult data and technology problems, leading complex migration efforts, working with enterprise-scale data environments, and seeing your technical expertise directly support national security and law-enforcement missions, Data Intelligence, LLC offers an opportunity to make a meaningful impact.