Data Engineer

DataJobs; Huntsville (AL); On-site; USD 95,000 - 140,000; Full time

Job summary

EKASYS INC in Huntsville, AL is hiring a Data Engineer to support a mission-critical application modernization effort. In this onsite role, 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.

You will design and optimize SSIS-based ETL pipelines, define source-to-target mappings, and collaborate with SMEs to ensure data accuracy and compliance

Qualifications

• Minimum 4 years of data engineering, ETL, database, or data migration experience.
• Experience designing ETL pipelines with SSIS or similar tools.
• Strong proficiency with Microsoft SQL Server, including schema design and query optimization.
• Experience with enterprise data migration (source-to-target mapping, transformation, validation, data quality).
• Experience building data architectures for transactional and/or analytical workloads.
• Excellent analytical, troubleshooting, documentation, and communication skills.
• Ability to obtain and maintain a Public Trust Background Investigation.

Responsibilities

• Design, develop, and maintain ETL and data pipelines (SSIS or equivalent).
• Define and document source-to-target mappings, transformations, and data migration procedures.
• Collaborate with SMEs to validate data mappings and migrated data.
• Design and maintain scalable data architectures, schemas, dictionaries, and ERDs.
• Manage ETL execution, monitor data quality, and ensure traceability to user stories.
• Optimize SQL Server schemas, queries, indexes, and data workflows.
• Design data interfaces and integrations with internal/external systems, including APIs.
• Ensure data governance, security, and API standards compliance.
• Support CI/CD and automated data-layer testing.

Skills

SSIS

SQL Server

ETL

CI/CD

Agile/Scrum

APIs

JSON

XML

CSV

NIST SP 800-53

FedRAMP

Digital.ai

ERDs

Data Governance

Data Quality

GIS/ESRI

Education

Bachelor’s degree in Computer Science, Information Systems, Engineering

Tools

SSIS

Microsoft SQL Server

REST APIs

JSON

XML

CSV

GIS

ERDs

Job description

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