Apply on Employer Site

LMI · 5 months ago

Data Engineer - Clearance Required

Washington, DC

Full-time

Onsite

Senior Level

$149K/yr - $207K/yr

5+ years exp

LMI is a digital solutions provider focused on enhancing government impact through innovation and speed. The Data Engineer will design, develop, and maintain enterprise database systems for government and defense projects, implementing ETL processes and managing application databases to ensure performance and availability.

AnalyticsConsultingInformation TechnologyLogisticsManagement ConsultingProfessional Services

Comp. & Benefits

No H1B

Security Clearance Required

U.S. Citizen Only

Responsibilities

Oversee data architecture for large-scale APIs and web application back-end data stores

Implement ETL processes to supply application data for usage in web applications

Manage critical low latency application databases on various platforms

Develop and maintain packages, scripts, and reusable components for system enhancements and interfaces

Develop scripts to validate various data on systems and improve database performance

Troubleshoot and correct code problems identified during ETL and refresh processes

Develop, implement, and execute quality assurance programs and quality control standards

Establish database backup/recovery strategy and implement automation of DBA utility functions

Document database design, data definition language, and data migration strategy

Engineer extensive database solutions and interfaces for enhanced data requests performance

Qualification

SQLETL pipeline designCloud database developmentData migration proceduresBachelor's degreeSecurity clearance

Required

5+ years of experience designing, developing, and maintaining enterprise database systems

Strong understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle)

Demonstrated experience with ETL pipeline design and implementation using third-party vendor solutions (NNCompass, Pentaho) or developing custom solutions

Experience with cloud database development and implementation

Robust understanding of data migration procedures for backup, restore, as well as schema migration

Bachelor's degree in Computer Science, Data Science, or a related field

Ability to obtain and maintain a security clearance (Confidential/NAC required)