Lead data engineering work to design, build, and maintain a modernized data infrastructure in an onsite role in Huntsville, AL.

Design and implement ETL pipelines using SQL Server Integration Services (SSIS) to migrate legacy data to the modernized platform
Deliver 100% source-to-target traceability for migrated data
Define and document data mappings, transformation rules, and validation logic for all migrated data elements
Partner with Subject Matter Experts (SMEs) to validate mappings prior to implementation; target ≥90% SME sign-off
Maintain a Data Dictionary and Entity Relationship Diagrams, updated each sprint
Optimize Microsoft SQL Server schemas, queries, and indexes to meet performance targets (search queries ≤ 2 seconds, record retrieval ≤ 1 second)
Design and adapt data interfaces, including Spartan and EODIMS integrations, aligned to the Modernization lexicon and schema
Ensure all database activities comply with Data Governance Manual v4.2 and relevant API standards and best practices
Monitor and validate ETL execution outcomes; document row counts, successes, and failures each sprint
Support CI/CD with data-layer test automation and ensure ETL tasks are linked to user stories in Digital.ai
Participate in Agile Scrum ceremonies, including sprint planning, standups, reviews, and retrospectives
Serve as Key Personnel for designing, building, and maintaining the overall data infrastructure, including leading the migration from legacy to modernized systems

Bachelor’s degree in Computer Science, Information Systems, or related field; equivalent experience accepted
3+ years designing and implementing ETL pipelines using SSIS or comparable tools
Proficiency in Microsoft SQL Server, including schema design, query optimization, and index tuning
Experience with source-to-target data mapping and enterprise data migration
Familiarity with federal data governance frameworks
Strong written and verbal communication skills, including ability to clearly document complex data transformations

Experience supporting federal law enforcement or case management systems
Knowledge of NIST SP 800-53 data security controls and FedRAMP compliance
Experience integrating REST APIs and working with JSON, XML, and CSV formats
Familiarity with Agile/Scrum methodologies and tools such as Digital.ai
Experience with GIS data formats (e.g., .shp, ESRI) and i2 Analyst’s Notebook

Data Engineer

Job Description