Data Engineer

EKASYS INC is hiring a Data Engineer for an onsite role in Huntsville, AL to support a mission-critical application modernization effort. In this position, you will help build reliable data infrastructure and pipelines that support legacy-to-modern migration while maintaining strong standards for data quality, integrity, traceability, and governance compliance. This is a full-time opportunity working 40 hours per week.

What you’ll be doing

• Design, develop, and maintain ETL/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 results.
• Create and maintain scalable data architectures, including database schemas, Data Dictionaries, and Entity Relationship Diagrams (ERDs).
• Manage ETL execution and monitor outcomes to ensure data quality, integrity, completeness, and traceability.
• Optimize Microsoft SQL Server schemas, queries, indexes, and data workflows to improve application and reporting performance.
• Design and support data interfaces and integrations with internal and external systems, including APIs and enterprise data sources.
• Ensure migration and database activities comply with applicable data governance, security, and API standards.
• Support CI/CD and automated data-layer testing, maintaining traceability between data activities and applicable user stories.
• Troubleshoot issues across data migration, transformations, integrations, and database performance.
• Participate in Agile/Scrum ceremonies, including sprint planning, standups, reviews, and retrospectives.
• Maintain clear technical documentation for data architecture, transformations, migration activities, validation results, and interfaces.

What you bring

• Minimum 4 years of relevant data engineering, ETL, database, or data migration experience.
• Experience designing and implementing ETL pipelines with SSIS or comparable tools.
• Strong proficiency with Microsoft SQL Server, including schema design, query optimization, and index tuning.
• Demonstrated enterprise experience with source-to-target mapping, data transformation, validation, and data quality.
• Experience designing data architectures for transactional and/or analytical workloads.
• Strong analytical, troubleshooting, documentation, and communication skills.
• Ability to obtain and maintain a Public Trust Background Investigation.
• Preferred: Bachelor’s degree in a technical field.

Preferred qualifications

• 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 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.

Clearance and eligibility

• This position requires U.S. Citizenship to meet federal contract requirements.
• Candidates must be legally authorized to work in the United States without current or future employer sponsorship.
• This position is not eligible for visa sponsorship.
• Public Trust Background Investigation is required.

Technologies you may work with

SQL Server Integration Services (SSIS), Microsoft SQL Server, ETL, CI/CD, Agile/Scrum, APIs, REST APIs, JSON, XML, CSV, NIST SP 800-53, FedRAMP, Digital.ai, GIS, ESRI technologies, i2 Analyst’s Notebook, ERDs.

How to apply

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