Data Engineer

Overview

LMI is seeking a Data Engineer to be part of a team that is designing and developing complex, enterprise level information systems.

LMI is a consultancy dedicated to powering a future-ready, high-performing government, drawing from expertise in digital and analytic solutions, logistics, and management advisory services. We deliver integrated capabilities that incorporate emerging technologies and are tailored to customers’ unique mission needs, backed by objective research and data analysis. Founded in 1961 to help the Department of Defense resolve complex logistics management challenges, LMI continues to enable growth and transformation, enhance operational readiness and resiliency, and ensure mission success for federal civilian and defense agencies.

LMI has been named a 2022 #TopWorkplace in the United States by Top Workplaces! We are honored to be recognized as a company that values a people-centered culture, and we are grateful to our employees for making this possible!

Responsibilities

• Supports data architecture for large-scale APIs and web application back-end data stores.
• Implements ETL processes to supply application data for usage in the web application.
• Manages critical low latency application databases on platforms. Develops packages and scripts for system enhancements and interfaces.
• Develops scripts to validate the various data on systems.
• Writes queries to improve the database performance and availability.
• Executes statement to create and update various tables and views utilize for testing of code on a database.
• Establishes database backup/recovery strategy using user-manage backup.
• Engineers database solutions and interfaces enabling performance of data requests.
• Develops reusable components for deployment in a traditional data warehouse environment.
• Standardizes database maintenance activities by standardizing directory structure and documentation of DBA activities.
• Establishes backup and recovery options and implements automation of many DBA utility functions.
• Documents database design, data definition language, and define data migration strategy between different products/versions and develop data migration procedures.

Qualifications

Required

• Confidential/NAC
• Bachelor’s degree in related technical discipline
• Minimum 5 years of hands-on experience in in database management operations
• Experience with cloud database development and implementation (AWS preferred).
• Understanding of data migration procedures for backup and restore as well as schema migration for existing data holdings.
• Demonstrated experience with ETL pipeline design and implementation.
• Strong and robust understanding of SQL (MariaDB/MySQL, Postgres, MS SQL, or Oracle).
• Demonstrated experience implementing ETL pipelines within and without the use of 3rd party vendor solutions (NNCompass, Pentaho).
• Demonstrated experience documenting database architecture and diagrams.

Desired

• Experience with storage on cloud for containerized applications.
• Experience with NoSQL (Cassandra, HBase, MongoDB, etc.).
• Experience with index-based datastores (ElasticSearch, Solr).
• Experience running ETL pipelines over Apache NiFi.

Percentage of Travel Required: 10%