Data Engineer

EKASYS INC is hiring a Data Engineer to support a mission-critical application modernization effort. In this onsite role in Huntsville, AL, you will design, build, and maintain data infrastructure and architecture, with responsibility for legacy-to-modern migration, ETL pipeline development, and governed data quality across the data lifecycle. Responsibilities Design, develop, and maintain ETL and data pipelines using SQL Server Integration Services (SSIS) or comparable technologies for legacy data migration. Define and document source-to-target mappings , transformation rules, validation logic, and data migration procedures. Collaborate with SMEs and stakeholders to validate data mappings, business rules, and migrated data. Design and maintain scalable data architectures, including database schemas , Data Dictionaries , and Entity Relationship Diagrams (ERDs) . Manage ETL execution and monitor results to support data quality , integrity, completeness, and traceability. Optimize Microsoft SQL Server schemas, queries, indexes, and data workflows to support application and reporting performance. Design and support data interfaces and integrations with internal and external systems, including APIs and enterprise data sources. Ensure database and data migration activities comply with applicable data governance , security, and API standards. Support

CI/CD

and automated data-layer testing while maintaining traceability between data activities and user stories. Troubleshoot issues related to data migration, transformation, integration, and database performance. Participate in Agile/Scrum ceremonies, including sprint planning, standups, reviews, and retrospectives. Maintain technical documentation covering data architecture, transformations, migration activities, validation results, and data interfaces. Required Qualifications Minimum 4 years of relevant experience in data engineering, ETL, database, or data migration. Experience designing and implementing ETL pipelines using SSIS or comparable tools. Strong proficiency with Microsoft SQL Server , including database and schema design, query optimization, and index tuning. Demonstrated experience with enterprise data migration, including source-to-target mapping, data transformation, validation, and data quality. Experience designing data architectures optimized for transactional and/or analytical workloads. Strong analytical, troubleshooting, documentation, and communication skills. Ability to obtain and maintain a Public Trust Background Investigation . Preferred Qualifications Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related technical field from an accredited institution. Microsoft Certified: Azure Data Engineer Associate or comparable certification. Experience with federal data governance frameworks and NIST SP 800-53 / FedRAMP environments. Experience with REST APIs , JSON , XML , and CSV data integrations. Experience supporting federal law enforcement, case management, or other government systems. Familiarity with Agile/Scrum and Digital.ai or similar tools. Experience with GIS data formats, ESRI technologies , or i2 Analyst’s Notebook . Technologies SQL Server Integration Services (SSIS) Microsoft SQL Server ETL CI/CD Agile/Scrum APIs, including REST APIs

JSON, XML, CSV

NIST SP 800-53

FedRAMP Digital.ai GIS, ESRI technologies i2 Analyst’s Notebook ERDs Location and Employment Details Location: Onsite, Huntsville, AL Employment Type: Full-Time, 40 hours per week Clearance and Eligibility Public Trust Background Investigation required U.S. Citizenship required to meet federal contract requirements Legally authorized to work in the United States without current or future employer sponsorship Not eligible for visa sponsorship #J-18808-Ljbffr DataJobs