Mission-Critical Data Engineer — SSIS/SQL Server Expert

RiseMe

Herndon (VA)

On-site

USD 90,000 - 130,000

Full time

3 days ago

Be an early applicant

Application generator

Get a reply from this employer — a resume and cover letter tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

RiseMe in Huntsville, AL is hiring a Data Engineer to design, build, and maintain data infrastructure for a critical modernization project. You will migrate data from legacy systems to a modern platform, develop ETL processes, and ensure quality, integrity, traceability, and governance across the data lifecycle.

You will collaborate with SMEs to define mappings, optimize SQL Server schemas and data workflows, and support CI/CD and data-layer testing.

Qualifications

Minimum 4 years of data engineering, ETL, or data migration experience.
Experience designing ETL pipelines with SSIS or comparable tools.
Proficiency with Microsoft SQL Server for schema design and query optimization.
Ability to obtain and maintain a Public Trust Background Investigation.

Responsibilities

Design, develop, and maintain ETL/data pipelines using SSIS or comparable technologies.
Define and document source-to-target mappings, transformation rules, validation logic, and data migration procedures.
Collaborate with SMEs to validate data mappings, rules, and migrated data.
Design and maintain scalable data architectures, database schemas, Data Dictionaries, and ERDs.
Manage ETL processes and monitor execution to ensure data quality and traceability.
Optimize SQL Server schemas, queries, indexes, and data workflows for performance.
Design and support data interfaces with internal/external systems, including APIs.
Ensure data governance and security compliance; support CI/CD and automated tests.