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

Application Process

Qualified candidates are invited to submit a resume and a cover letter detailing relevant experience and qualifications. Include certifications and references that support your application.